日期:2014-05-17  浏览次数:20696 次

Oracle 10G windows 平台 DataGuard 实例(三)

?

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?;?