下配置四计划

6.在主备节点用tnsping测试络连通性

在primary机上

-bash-2.05b$tnspingprimary

-bash-2.05b$tnspingstandby

在standby机上

-bash-2.05b$tnspingprimary

-bash-2.05b$tnspingstandby

7. 启动副数据库

sql startup nomount;

SQL alter database mount standby database;

Database altered.

SQL alter database recover managed standby database disconnect from session;

Database altered.

8. 在主节点设置归档路径

SQL alter system set log_archive_dest_2=\'service=standby mandatory reopen=60\';

System altered.

定义了主库向副库传输日志

# 定义归档到备用库，强制归档，重试时间60秒。

# 如果定义为可选状态(optional)，那么在归档失败后不会再次尝试归档的。定义

# 为madatory状态后，如果本次归档失败，则在归档下一个日志时会再次尝试

SQL alter system switch logfile;

System altered.

SQL /

System altered.

SQL

在备用节点观察日志

[oracle@eygle bdump]$ tail -f alert_g

MRP0: Background Managed Standby Recovery process started

Starting datafile 1 recovery in thread 1 sequence 90

Datafile 1: \'/opt/oracle/oradata/primary/f\'

Starting datafile 2 recovery in thread 1 sequence 90

Datafile 2: \'/opt/oracle/oradata/primary/f\'

…………………………

-bash-2.05b$ mkdir /home/oracle/oradata/oracle/stdarch

9.主辅数据库的切换（停止主数据库,启用备用数据库）

修改primary的参数文件a(先做好备份)

增加

*.standby_archive_dest=\'/home/oracle/oradata/standbyarch\'

*.fal_server=\'standby\'

*.fal_client=\'primary\'

*.DB_FILE_NAME_CONVERT=(\"/home/oracle/oradata/primary\",\"/home/oracle/oradata/oracle\")

*.LOG_FILE_NAME_CONVERT=(\"/home/oracle/oradata/archivelog\",\"/home/oracle/oradata/archivelog\")

*.STANDBY_FILE_MANAGEMENT=\'AUTO\'

删除log_archive_dest_2参数

修改standby的参数文件a(先做好备份)

增加

*.log_archive_dest_2=\'service=primary mandatory reopen=60\'

*.log_archive_dest_state_2=\'ENABLE\'

删除

*.STANDBY_ARCHIVE_DEST=/home/oracle/oradata/archivelog

*.fal_server=\'standby\'

*.fal_client=\'primary\'

*.DB_FILE_NAME_CONVERT=(\"/home/oracle/oradata/primary\",\"/home/oracle/oradata/oracle\")

*.LOG_FILE_NAME_CONVERT=(\"/home/oracle/oradata/archivelog\",\"/home/oracle/oradata/archivelog\")

*.STANDBY_FILE_MANAGEMENT=AUTO

在primary主机上执行

SQL alter database commit to switchover to physical standby with session shutdown ;

Database altered.

察看primary主机上的后台日志

…………………………….

SQL shutdown immediate

ORA-01507: database not mounted

ORACLE instance shut down.

以备用模式（standby）启用主数据

SQL create spfile from pfile;

SQL startup nomount;

SQLshow 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

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

[oracle@primary bdump]$ tail -f alert_g

Starting datafile 2 recovery in thread 1 sequence 93

Datafile 2: \'/opt/oracle/oradata/primary/f\'

Starting datafile 3 recovery in thread 1 sequence 93

Datafile 3: \'/opt/oracle/oradata/primary/f\'

……………………………………………….

Media recover

查看本文来源

咸宁治疗白癜风的医院
哪些降压药为单片复方制剂
沧州白癜风好的医院