Linux环境下oracle9i的Data guard配置
2007-05-10 12:18:33 来源:WEB开发网核心提示: SQL>show parameter standby_file_management;SQL> alter database mount standby database;Database altered.打开备用数据库(在standby主机上执行)[oracle@standb
SQL>show parameter standby_file_management;
SQL> alter database mount standby database;
Database altered.
打开备用数据库(在standby主机上执行)
[oracle@standby oracle]$ sqlplus "/ as sysdba"
SQL> alter database commit to switchover to primary with session shutdown ;
Database altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down
SQL>create spfile from pfile;
SQL> startup;
……
Database mounted.
Database opened.
SQL> select SEQUENCE#,GROUP#,STATUS from v$log;
SQL> select sequence#,group#,status from v$log;
SEQUENCE# GROUP# STATUS
---------- ---------- --------------------------------
72 1 INACTIVE
73 2 INACTIVE
74 3 CURRENT
SQL> alter system switch logfile;
System altered.
SQL> select sequence#,group#,status from v$log;
SEQUENCE# GROUP# STATUS
---------- ---------- --------------------------------
75 1 CURRENT
73 2 INACTIVE
74 3 ACTIVE
在primary主机上执行:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
在primary主机上观察日志应用情况
赞助商链接