oracle 10g rman备份与恢复之二(二)
ora10g/flash_recovery_area/WOLF/archivelog/2013_04_20/o1_mf_1_3_8q4p7fts_.arc recid=12 stamp=813214765
Finished backup at 20-4月 -13
Starting Control File and SPFILE Autobackup at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813214768_8q4p7jrs_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-4月 -13
RMAN>
-----------------------------------------------------------------------------------------------------------
2、备份表空间
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM *** /oracle/ora10g/oradata/wolf/system01.dbf
2 25 UNDOTBS1 *** /oracle/ora10g/oradata/wolf/undotbs01.dbf
3 240 SYSAUX *** /oracle/ora10g/oradata/wolf/sysaux01.dbf
4 5 USERS *** /oracle/ora10g/oradata/wolf/users01.dbf
5 20 RMAN_WOLF *** /oracle/ora10g/oradata/wolf/rmanwolf.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /oracle/ora10g/oradata/wolf/temp01.dbf
RMAN> backup tablespace rman_wolf;
Starting backup at 20-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=/oracle/ora10g/oradata/wolf/rmanwolf.dbf
channel ORA_DISK_1: starting piece 1 at 20-4月 -13
channel ORA_DISK_1: finished piece 1 at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_20/o1_mf_nnndf_TAG20130420T050523_8q4plm6l_.bkp tag=TAG20130420T050523 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-4月 -13
Starting Control File and SPFILE Autobackup at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813215126_8q4plq2t_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-4月 -13
RMAN> list backupset
------------------------------------------------------------------------------
3、备份控制文件 （备份多分控制文件，在恢复时他会自动去找最新的那个）
RMAN> backup current controlfile;
Starting backup at 20-4月 -13
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 20-4月 -13
channel ORA_DISK_1: finished piece 1 at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/backupset/2013_04_20/o1_mf_ncnnf_TAG20130420T052003_8q4qg39b_.bkp tag=TAG20130420T052003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 20-4月 -13
Starting Control File and SPFILE Autobackup at 20-4月 -13
piece handle=/oracle/ora10g/flash_recovery_area/WOLF/autobackup/2013_04_20/o1_mf_s_813216006_8q4qg6y1_.bkp comment=NONE
Finished Control File and SPFILE Autobac