????9. ???
????a. ??????
?????????????????????????????????????????????redo??archive???????????????
????SQL>shutdown immediate
????SQL>startup mount
????RMAN>restore database;
????RMAN>recover database;
????RMAN>sql 'alter database open';
??????????????tag????????????????????????redo ??archive ????????????????????????????????
????1. ???????
????RMAN> list backupset summary;
????Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
????------- -- -- - ----------- --------------- ------- ------- ---------- ---
????25 B A A DISK 25-JUL-11 1 1 NO TAG20110725T104634
????28 B 0 A DISK 25-JUL-11 1 1 NO TAG20110725T104645
????29 B A A DISK 25-JUL-11 1 1 NO TAG20110725T104711
????30 B F A DISK 25-JUL-11 1 1 NO TAG20110725T104713
????31 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105333
????32 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105350
????33 B 1 A DISK 25-JUL-11 1 1 NO TAG20110725T105353
????34 B A A DISK 25-JUL-11 1 1 NO TAG20110725T105408
????35 B F A DISK 25-JUL-11 1 1 NO TAG20110725T105411
????36 B A A DISK 25-JUL-11 1 1 NO TAG20110725T111403
????37 B 1 A DISK 25-JUL-11 1 1 NO TAG20110725T111405
????38 B A A DISK 25-JUL-11 1 1 NO TAG20110725T111421
????39 B F A DISK 25-JUL-11 1 1 NO TAG20110725T111423
????2. ????????
????SQL>shutdown immediate;
????SQL>startup mount;
????RMAN>restore database from tag TAG20110725T104645;
????RMAN> recover database from tag TAG20110725T104645;
????RMAN> alter database open;
????b. ??????????
????SQL>shutdown immediate;
????SQL>startup mount;
????RMAN>restore database from tag TAG20110725T104645;
????RMAN>recover database until time "to_date('2011-08-04 15:37:25'??'yyyy/mm/dd hh24:mi:ss')";
????RMAN>alter database open resetlogs;
?????????ú????е?????????Ч??????????????????????????????ORACLE10G???resetlog?????????????????
???????????????system / undotbs1 / sysaux????
????SQL>shutdown abort
????SQL>startup mount
????RMAN>restore tablespace ????;
????RMAN>recover tablespace ????;
????RMAN>sql 'alter database open';
????????????????example / users ????
????select * from v$datafile_header; ???????????????????
????SQL>alter database datafile ???? offline;
????RMAN>restore tablespace ????;
????RMAN>recover tablespace ????;
????SQL>alter database datafile ???? online;
????10. ???????
????????backup???????delete backup;
????????copy???????delete copy;
??????????????delete backupset 19;
??????????????????????????delete obsolete;
????????????????
????delete expired backupset;
????delete expired copy;
????11. RUN??
???????磺
????RMAN> RUN {
????ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
????ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
????ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
????BACKUP
????INCREMENTAL LEVEL = 0
????FORMAT '/disk1/backup/df_%d_%s_%p.bak'
????(DATAFILE 1??4??5 CHANNEL c1)
????(DATAFILE 2??3??9 CHANNEL c2)
????(DATAFILE 6??7??8 CHANNEL c3);
????ALTER SYSTEM ARCHIVE LOG CURRENT;
????}
????12. ????????
?????????set nls_lang=american
?????????set nls_date_format=yyyy-mm-dd....
????13. RMAN sciprt
???????????????catalog
????д????(global???????????????????)
????create global script ??
????comment "??????"
????{???????}
???????磺
????create global script abc
????comment "test"
????{backup current controlfile;}
?????????run {execute script ??}
???????磺run {execute script abc;}
????????print script ??
??????д??
????replace global script ??
????comment "??????"
????{???????}
?????????delete script ??;
????14. ???????
?????????????????????flash recovery area?У?
????a. ?????????
????RUN
????{
????ALLOCATE CHANNEL c1 DEVICE TYPE disk format '/tmp/autobackup/%U';
????BACKUP tablespace example;
????}
????b. ?????????
????list backupset of tablespace example;
????c. ????????
????change backupset ??? keep forever nologs;
????15. ????????????С?????
???????磺example ????????С?????50M
????run
????{
????allocate channel c1 device type disk maxpiecesize 10M format '/tmp/autobackup/%U';
????backup tablespace example;
????}
????/tmp/autobackup?????????????
????16.???н????backup recovery area
?????????????
????a. control file autobackup;
????b. incremental backup sets
????17.block change tracking
????a. ????????????
????b. ?????·????background_dump_dest