摘要:
1. 确保源数据库在归档模式,并且是强制logging模式。shutdown immediate ;startup mount ;alter database archivelog ;alter database force logging ;alter database open ;2. 确保已经建立的密码文件。(确保能够远程登录(@xxx as sysdba)cd $ORACLE_HOME/dbs/查看是否已经建立了passwordfile .若没有,执行下列命令。这里要注意,oracle的密码文件都是存放在$ORACLE_HOME/dbs目录下面的。而且默认查找的时候会在目录下查找格式为 阅读全文
摘要:
Step 1 Verify that the primary database can be switched to the standby role.验证主库能够切换到备用角色。SELECT SWITCHOVER_STATUS FROM V$DATABASE;idle>:wqSWITCHOVER_STATUS--------------------TO STANDBYStep 2 Initiate the switchover on the primary database.在主库上面开始切换alter database commit to switchover to physical 阅读全文