WEB开发网
开发学院数据库Oracle Linux环境下oracle9i的Data guard配置 阅读

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主机上观察日志应用情况

上一页  5 6 7 8 9 10 

Tags:Linux 环境 oraclei

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接