在单机上创建物理的Oracle9i standby数据库

核心提示： SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;2.10 激活到物理Standby数据库的归档SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

2.10 激活到物理Standby数据库的归档

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=Pstandby' SCOPE=BOTH;

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

2.11 启动远程归档

SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

3.安装完的的验证：

3.1在database,　查询V$ARCHIVED_LOG

(其实也可以直接到相关目录下查看Log是否创建):

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME

2 FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME

---------- ---------- ----------

38 23-7? -02 23-7? -02

39 23-7? -02 23-7? -02

40 23-7? -02 23-7? -02

41 23-7? -02 23-7? -02

42 23-7? -02 23-7? -02

3.2 在Primary数据库上，归档当前的Log

SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

3.3 验证是否收到：

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME

2> FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME NEXT_TIME

---------- ---------- ----------

38 23-7? -02 23-7? -02

39 23-7? -02 23-7? -02

40 23-7? -02 23-7? -02

41 23-7? -02 23-7? -02

42 23-7? -02 23-7? -02

43 23-7? -02 23-7? -02

3.4 验证是否新的归档Redo日志已经被应用：

SQL> select sequence#,applied from v$archived_log

2 order by sequence#;