梦想有多远

–启动到恢复模式
startup mount;
alter database recover managed standby database disconnect from session;
–从恢复管理模式切换到只读模式
alter database recover managed standby database cancel;
alter database open;
–从只读模式切换到恢复管理模式
alter database recover managed standby database disconnect from session;
–关闭standby数据库
alter database recover managed standby database cancel;
shutdown immediate;
–直接启动到只读模式
startup;
–通过MRP0进程是否存在确认当前数据库所处的模式
select process, status from v$managed_standby;
–把备用数据库激活成主数据库
–alter database activate standby database;

This entry was posted on 星期三, 十一月 21st, 2007 at 12:04 and is filed under oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.