使用rman备份和恢复standby数据库
1、在主备库中tnsnames.ora增加以下内容
---rman catalog库
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = training)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
--physical standby
orcl_p =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=tcp)(HOST=192.139.39.16)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)
--primary database
orcl_s =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=tcp)(HOST=192.139.39.17)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)
2、连接到主库进行注册
rac3->rman catalog rmanadmin/rmanadmin@orcl target sys/oracle@orcl_s
RMAN> create catalog tablespace users;
RMAN> register database;
RMAN> CONFIGURE DB_UNIQUE_NAME 'orcl_s' CONNECT IDENTIFIER 'orcl_s';
RMAN> CONFIGURE DB_UNIQUE_NAME 'orcl_p' CONNECT IDENTIFIER 'orcl_p';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
注意:在配置带有standby库的时候,确认主备库用到的passwordfile的密码指定的都是
相同的,也就是orapwd创建密码文件的时候记得指定相同的密码。
1、在主备库中tnsnames.ora增加以下内容
---rman catalog库
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = training)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
--physical standby
orcl_p =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=tcp)(HOST=192.139.39.16)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)
--primary database
orcl_s =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=tcp)(HOST=192.139.39.17)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=orcl))
)
2、连接到主库进行注册
rac3->rman catalog rmanadmin/rmanadmin@orcl target sys/oracle@orcl_s
RMAN> create catalog tablespace users;
RMAN> register database;
RMAN> CONFIGURE DB_UNIQUE_NAME 'orcl_s' CONNECT IDENTIFIER 'orcl_s';
RMAN> CONFIGURE DB_UNIQUE_NAME 'orcl_p' CONNECT IDENTIFIER 'orcl_p';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
注意:在配置带有standby库的时候,确认主备库用到的passwordfile的密码指定的都是
相同的,也就是orapwd创建密码文件的时候记得指定相同的密码。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-697358/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25702/viewspace-697358/