oracle数据库怎么使用_分享oracle数据库应用指南)

oracle数据库怎么使用_分享oracle数据库应用指南) oracle数据库切换DG步骤备注：应用服务要先停止对外服务1.先将主库切换成备库，然后将原主库启动到物理库的状态SQL> Alter database commit to switchover to physical standby with session shutdown;2.关闭主库SQL> shutdown immediate;3.打开数据库nomountSQL> startup nomount;4.更改主库为备库SQL> alter database mount standby database;SQL> alter database recover managed standby database disconnect from session;如果配置了 standby redo log 并需要启用实时同步则执行以下代码SQL>alter database recover managed standby database using current logfile disconnect from session;5.将备库切换成主库SQL> select switchover_status from v$database;SQL> select * from v$version where rownum<2;SQL> alter database commit to switchover to primary with session shutdown;如果备库还有未应用的日志则执行SQL>alter database recover managed standby database disconnect from session;SQL> shutdown immediate;SQL> startup;切换日志进行检查SQL> select max(sequence#) from v$log;SQL>select sequence#,applied from v$archived_log;SQL> alter system switch logfile;