1Z0-032-17: Recovery catalog creation and manitance;
recovery catalog: 备份历史记录的信息(可以通过list,report来查看),create、store、run脚本,
维护,重同步,reset,change,delete,backup,restore catalog.
(在只通过controlfile不可创建脚本)
内容: datafile,redolog, backupset and backup pieces; datafile copies; archivelog redo log file;
target db的物理结构。主要是这两三部分(备份信息,DB物理结构),
rman的配置信息,脚本信息。
优点: 可以存多个DB信息;
建立: catalog与target DB在一起,方法如下。
1) create tablespace; //create tablespace rman1 datafile 'E:/oracle/oradata/ora9i/rman011.dbf' size 5m;
2) create catalog owner; //create user rman identified by rman_001 default tablespace rman_space quota unlimited on rman_space temporary tablespace temp;
3) grant privileges //grant connect,recovery_catalog_owner to rman;
4) create catalog //DOS>rman catalog rman/rman_001; RMAN>create catalog tablespace rman_space;
5) connect with target database;
6) register target database ///RMAN>conn sys/admin1; RMAN>register database RMAN>report schema;
重同步:RMAN>resync catalog; 当修改DB的数据结构时,需要同步,可以手工,也可以自动同步。
reset: 当DB使用了alter database open resetlogs; 时要对catalog进行reset catalog;
查询信息: report ,list;
report schema; report need backup redundancy 3; report need backup days 3;
视图: rc_database; rc_datafile; rc_stored_script; rc_stored_script_line; rc_tablespace;
脚本: RMAN>create script level0backup{.........}
RAMN>run {execute script level0backup;}
RAMN>replace script level0backup { ...};
RAMN>print script level0backup;
RAMN>delete script level0backup;
catalog备份: 表空间备份;整个DB备份;作exp备份;
恢复:
维护,重同步,reset,change,delete,backup,restore catalog.
(在只通过controlfile不可创建脚本)
内容: datafile,redolog, backupset and backup pieces; datafile copies; archivelog redo log file;
target db的物理结构。主要是这两三部分(备份信息,DB物理结构),
rman的配置信息,脚本信息。
优点: 可以存多个DB信息;
建立: catalog与target DB在一起,方法如下。
1) create tablespace; //create tablespace rman1 datafile 'E:/oracle/oradata/ora9i/rman011.dbf' size 5m;
2) create catalog owner; //create user rman identified by rman_001 default tablespace rman_space quota unlimited on rman_space temporary tablespace temp;
3) grant privileges //grant connect,recovery_catalog_owner to rman;
4) create catalog //DOS>rman catalog rman/rman_001; RMAN>create catalog tablespace rman_space;
5) connect with target database;
6) register target database ///RMAN>conn sys/admin1; RMAN>register database RMAN>report schema;
重同步:RMAN>resync catalog; 当修改DB的数据结构时,需要同步,可以手工,也可以自动同步。
reset: 当DB使用了alter database open resetlogs; 时要对catalog进行reset catalog;
查询信息: report ,list;
report schema; report need backup redundancy 3; report need backup days 3;
视图: rc_database; rc_datafile; rc_stored_script; rc_stored_script_line; rc_tablespace;
脚本: RMAN>create script level0backup{.........}
RAMN>run {execute script level0backup;}
RAMN>replace script level0backup { ...};
RAMN>print script level0backup;
RAMN>delete script level0backup;
catalog备份: 表空间备份;整个DB备份;作exp备份;
恢复: