????ORACLE RMAN????????
????1. ORACLE RMAN?????????????л?????????鵵?????
????a. ????????
????SQL> shutdown immediate;
????b. ????????mount??
????SQL> startup mount;
????c. ???ù鵵??
????SQL> alter database archivelog;
????d. ???????????????????????鵵?????λ??
????SQL> archive log list;
???????????archive??????????е???????????Ч??
????e. ????????????????
????Oracle10g????????????????????????????????鵵????
????????SQL> show parameter log_archive_start;??
????NAME TYPE VALUE
????------------------------------------ ----------- --------------
????log_archive_start boolean FALSE
????SQL> alter system set log_archive_start=true scope=spfile;
???????????????????Ч????????????????鵵????
???????????????????5???????
????SQL>archive log start
??????????????????鵵???????????????????????????鵵????
????2. ???У?RMAN target /
????3. RMAN??????棺????????control file?У?????????7??
??????????alter system set control_file_record_keep_time=????;
????4. ?????????????RMAN???????
?????????????????????????????????
????a. ????????RC??create tablespace rc datafile size 10M autoextend on next 1M
????b. ???????RC??
????CREATE USER rc IDENTIFIED BY rc TEMPORARY TABLESPACE temp DEFAULT TABLESPACE rc QUOTA UNLIMITED ON rc;
????c. ???RC?? GRANT RECOVERY_CATALOG_OWNER TO rc;
????d. ????
????rman catalog rc/rc@orcl
????RMAN>create catalog;
????RMAN>exit
????rman target / catalog rc/rc@orcl
????RMAN>register database;
????e. ????
????rman target / catalog rc/rc@orcl
???????????????????????????????catalog???????
????5. ???????????
????????show all;
????????configure ???????? ????????
???????磺?????????????control file??configure controlfile autobackup on;
?????????????configure ???????? clear;
?????????????
????a. ?????????retention policy
?????????redundancy 1??????????????
???????????recovery window of 7 days?????????????7????????????
??????????????飺report obsolete??RMAN??????????????????г?????????????
???????????????delete obsolete
????b. ????????backup optimization??RMAN???????????????????????(??????????鵵??????????)
??????????????????channel
????c. ????????????default device type to disk??????????????·???flash recovery area
?????????????
????disk???????·??
????flash recovery area?????·??
????sbt??????豸
????????????????·????configure channel device type disk format '·??/%U';
???????磺configure channel device type disk format '/tmp/movedata/%U';
????6. ??????
????backupset??backup (as backupset) ???????????????????????backup piece????и???????????????????
????copy??backup as copy ????????
?????????????
????backupset ????list backup summary(list backupset summary)
?????????飺list backupset BS
????copy????list copy
?????????????
?????????????list backup of database;
????tablespace??list backup of tablespace users;
?????????????list backup of datafile n;
?????????????list backup of controlfile;
?????鵵?????list archivelog all;
?????????????
?????????????????????????report obsolete;
????????????????????????????report
????RMAN??OS????飺corsscheck ????;
????7. ??????
????full???????
????Incremental??????????
????????????????????????????????????????
????a. ?????????level 0????????????????磺backup incremental level 0 ????????;?????????????????ù???data block????image copy?????
????b. ?????????
?????????????backup cumulative level 1 ????????;
??????????????backup incremental level 1 ????????;
???????????????????????level 0??????
????????β????????????level 0??????????????????????????????
????c. Image?????????????
????????Σ???Image??????????
????????Σ???????????????????????????????Image???
?????????Σ????????ε?Image??????????????????????????Image???
????????
???????磺???tablespace example
????RUN {
????RECOVER COPY OF tablespace example WITH TAG 'incr_update';
????BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update'
????tablespace example;
????}
????d. ???????"block change tracking"????????????
??????????SELECT status FROM v$block_change_tracking;
??????????DISABLED
?????????ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;???????·??OMF?е?DB_CREATE_FILE_DEST??
???????????·????
????ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u01/oradata/MYSID/rman_change_track.f' REUSE;
????????ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
???????????飺bakcup check logical ????????;
????????????????????backup validate ????????;
???????????б????????v$backup_corruption??v$copy_corruption
????8. ?????????
?????????????RMAN>backup database;
???????????????backup as compressed backupset database include current controlfile plus archivelog delete input;
????tablespace??RMAN>backup tablespace ????;
?????????????RMAN>backup datafile n; (n:???????????????select file_name??file_id??tablespace_name from dba_data_files;)
?????????????RMAN>backup current controlfile;
????????RMAN>backup database include current controlfile;
????????????RMAN>backup archivelog all;
????????RMAN>backup database plus archivelog;
?????????????RMAN>backup spfile;