oracle 10g rman备份与恢复之一(二)
me=/oracle/ora10g/oradata/wolf/users01.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_TAG20130420T025250_8q4gt34k_.bkp tag=TAG20130420T025250 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:56
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_813207467_8q4h3cvp_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-4月 -13
[oracle@redhat WOLF]$ ls
archivelog autobackup backupset onlinelog
[oracle@redhat WOLF]$ cd autobackup
[oracle@redhat autobackup]$ ls
2013_04_17 2013_04_19 2013_04_20
[oracle@redhat autobackup]$ cd 2013_04_20/
[oracle@redhat 2013_04_20]$ ls
o1_mf_s_813207467_8q4h3cvp_.bkp
[oracle@redhat 2013_04_20]$ cd ..
[oracle@redhat autobackup]$ ls
2013_04_17 2013_04_19 2013_04_20
[oracle@redhat autobackup]$ cd ..
[oracle@redhat WOLF]$ ls
archivelog autobackup backupset onlinelog
[oracle@redhat WOLF]$ cd backupset/
[oracle@redhat backupset]$ ls
2013_04_17 2013_04_19 2013_04_20
[oracle@redhat backupset]$ cd 2013_04_20/
[oracle@redhat 2013_04_20]$ ls
o1_mf_nnndf_TAG20130420T025250_8q4gt34k_.bkp
[oracle@redhat 2013_04_20]$
这里备份的文件可以copy到硬盘然后删除，当需要恢复的时候在copy到这个目录，然今后进行恢复
====================================================================================================
oracle 10grman备份与恢复
海明老师第二讲
备份内容格式是由rman内部默认格式决定的。nocatalog方式备份信息写入control
可以到control目录进入controlfile查看
[oracle@redhat wolf]$ pwd
/oracle/ora10g/oradata/wolf
[oracle@redhat wolf]$ strings control01.ctl
。。。。
delete
2013-04-19T10:39:43
delete
2013-04-19T10:39:43
list
2013-04-19T10:39:43
delete
2013-04-20T02:42:15
RMAN
2013-04-20T02:42:15
list
2013-04-20T02:42:15
delete
2013-04-20T02:42:15
list
2013-04-19T10:39:43
list
。。。。
当然所显示的信息就是一些备份的时间内容等。
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/ora10g/product/10.2.0/db_1/dbs/snapcf_wolf.f'; # default
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18 Full 529.59M DISK 00:04:53 20-4月 -13
BP Key: 18 Statu