日期:2014-05-17 浏览次数:20696 次
?
7. 启动备用数据库?-
C:>set ORACLE_SID=orcl -
SQL>sqlplus "/as sysdba" -
SQL>startup nomount pfile='D:/oracle/product/10.2.0/db_1/database/initorcl.ora'; -
SQL>create spfile from pfile='D:/oracle/product/10.2.0/db_1/database/initorcl.ora'; -
?
若采用Rman备份的, 则在此standby 端进行 Rman还原数据库:-
$rman target?sys/admin@primary?auxiliary /-
RMAN> duplicate target database for standby dorecover nofilenamecheck;
?
?
SQL>alter database mount standby database ; -
SQL>alter database recover managed standby database disconnect from session; -
?
---------------------------------------?-
测试?-
?
注意Data?Guard?启动顺序:
启动顺序:先standby?,后primary;
?????? 关闭顺序:先primary?后standby;
?
?
在备库将实例启动到mount?状态:
SQL>?startup?nomount;
SQL>alter?database?mount?standby?database?;?