RMAN - backup, restore and recover
@ backup as compressed backupset database
RMAN> backup as compressed backupset database;
Starting backup at 21-DEC-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=34 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-DEC-12
channel ORA_DISK_1: finished piece 1 at 21-DEC-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_nnndf_TAG20121221T014321_8f7d5blz_.bkp tag=TAG20121221T014321 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:26
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 21-DEC-12
channel ORA_DISK_1: finished piece 1 at 21-DEC-12
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_ncsnf_TAG20121221T014321_8f7d9zkk_.bkp tag=TAG20121221T014321 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 21-DEC-12
@ show a list of backups
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 281.02M DISK 00:02:23 21-DEC-12
BP Key: 1 Status: AVAILABLE Compressed: YES Tag: TAG20121221T014321
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_nnndf_TAG20121221T014321_8f7d5blz_.bkp
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 923674 21-DEC-12 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 923674 21-DEC-12 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 923674 21-DEC-12 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 923674 21-DEC-12 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 923674 21-DEC-12 /u01/app/oracle/oradata/orcl/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 1.03M DISK 00:00:03 21-DEC-12
BP Key: 2 Status: AVAILABLE Compressed: YES Tag: TAG20121221T014321
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_12_21/o1_mf_ncsnf_TAG20121221T014321_8f7d9zkk_.bkp
SPFILE Included: Modification time: 21-DEC-12
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 923743 Ckp time: 21-DEC-12
RMAN>
Comments