2. SQL>alter database commit to switchover to physical standby;3. SQL>shutdowm immediate; 4. SQL>startup mount; 在standby上 1. SQL> select switchover_status from v$database switchover_status的值入股是To primary,可以直接switchover,如果是sessions active, 则需要在switchover的命令后面加上with session shutdown 2. SQL>alter database commit to switchover to primary; 3. SQL>shutdown immediate; 4. SQL>startup; 要想顺利的实现switchover,最好在每台server上都同时设置好primary和standby的一些初始化参数,虽然其中一些参数只有在primary或者standby其中之一上起作用 Failover 在standby上 1. SQL>alter database recover managed standby database finish; or SQL>alter database recover managed standby database finish skip standby logfile; 2. SQL>alter database commit to switchover to primary; 3. SQL>shutdown immediate; 4. SQL>startup; 相关视图 v$archive_dest v$archive_dest_status v$log_history v$archvied_log v$managed_standby v$archive_gap
常见问题 1. 日志无法传送 SQL>select dest_name,status,error from v$archive_dest; 察看相应的归档路径的状态是否valid,否则根据error信息进行处理 2. 无法使用alter database重命名data file 在standby上,当设置standby_file_management为auto时,不允许下列操作 alter database rename alter database add/drop logfile alter database add/drop standby logfile member alter database create datafile as 3. switchover失败 SQL>alter database commit to switchover to physical standby ORA-01093:alter database close only permitted with no session connected 察看引起该错误的活动session SQL> select sid,process,program from v$session where type=''''USER'''' and sid<>(select distinct sid from v$mystat); 断开该session,或者使用如下命令来做switchover SQL>lter database commit to switchover to physical standby with session shutdown;
上一页 [1] [2] [ORACLE]在单机上创建物理的Oracle9i standby数据库 [ORACLE]Oracle10g + Solaris9 for x86 + vmware安装步骤 [ORACLE]RHEL AS 3 安装及启动 Oracle10g 指南
|