|
转载请注明出处。
一.catalog 库： 官方文档：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcatdb.htm#BRADV89642
参考：http://blog.csdn.net/rlhua/article/details/13169205
二.建立catalog 数据库： 1.在要建立catalog database的数据库上操作 (库名:EMREP) ①.创建表空间 SQL> create tablespace rc_data datafile "/u01/app/oracle/oradata/EMREP/rc_data01.dbf' size 100m;
Tablespace created.
SQL> select file#,name from v$datafile;
FILE# NAME ---------- -------------------------------------------------- 1 /u01/app/oracle/oradata/EMREP/system01.dbf 2 /u01/app/oracle/oradata/EMREP/sysaux01.dbf 3 /u01/app/oracle/oradata/EMREP/undotbs01.dbf 4 /u01/app/oracle/oradata/EMREP/users01.dbf 5 /u01/app/oracle/oradata/EMREP/rc_data01.dbf ②.创建用户 并授权 SQL> create user rc_admin identified by rc_admin default tablespace rc_data;
User created. #授权 SQL> grant connect,resource to rc_admin;
Grant succeeded.
SQL> select * from dba_roles where role like '%RECOVERY%';
ROLE PASSWORD AUTHENTICAT ------------------------------ -------- ----------- RECOVERY_CATALOG_OWNER NO NONE
#必须授予 RECOVERY_CATALOG_OWNER 这个角色 SQL> grant RECOVERY_CATALOG_OWNER to rc_admin;
Grant succeeded.
③.创建密码文件 SQL> alter user sys identified by oracle;
User altered.
[oracle@gc2 dbs]$ orapwd file=orapwEMREP password=oracle entries=3 force=y
④.启动监听：
lsnrctl start
2.在主库(目标库)上操作 (库名：PROD)
①.远程连接rman [oracle@localhost dbs]$ rman catalog rc_admin/rc_admin@emrep
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 10 18:43:24 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database ②.在catalog库上 创建恢复目录。
RMAN> create catalog;
recovery catalog created
RMAN> quit ③.注册 同时连上目标库和catalog库 才能进行注册 [oracle@localhost dbs]$ rman target sys/oracle@prod catalog rc_admin/rc_admin@emrep
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 10 18:46:02 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=239015079) connected to recovery catalog database #开始注册： 将元数据同步到catalog库中的表里。 注册完成后，就可以在catalog database查询到相关信息。 RMAN> register database;
database registered in recovery catalog starting full resync of recovery catalog full resync complete
3.从恢复目录（recovery catalog）中注销目标数据库：(在目标库上操作)
[oracle@localhost dbs]$ rman target sys/oracle@prod catalog rc_admin/rc_admin@emrep
RMAN> unregister database;
从恢复目录中注销某一数据库时，恢复目录中的所有RMAN 资料档案库记录都会丢失。你可以重新注册这个数据库。此时，该数据库的恢复目录记录取决于再次注册时控制文件的内容。 通常，只有不再需要使用数据库的恢复目录时或数据库不再存在时，才会注销目标数据库。
三.RMAN存储脚本：
1.存放脚本：(在生产库上执行)
RMAN> create script cold_bak{ 2> shutdown immediate; 3> startup mount; 4> allocate channel c1 type disk; 5> allocate channel c2 type disk; 6> backup database format "/home/oracle/rman_bak/cold_bak/%d_%s_%p.bak'; 7> alter database open; 8> }
created script cold_bak
RMAN> create script hot_bak{ 2> sql 'alter system switch logfile'; 3> allocate channel c1 type disk; 4> allocate channel c2 type disk; 5> backup database format '/home/oracle/rman_bak/hot_bak/%d_%s_%p_hot.bak' 6> include current controlfile plus archivelog delete input 7> filesperset 3; 8> sql 'alter system switch logfile'; 9> }
created script hot_bak
RMAN> create script recover_database{ 2> startup force mount; 3> allocate channel c1 type disk; 4> allocate channel c2 type disk; 5> restore database; 6> recover database; 7> alter da |