关闭数据库:
1.关闭主备库监听
lsnrctl stop
2.备库执行,关闭apply应用
alter database stop logical standby apply;
alter database abort logical standby apply; 强制终止
3.主库执行
shutdown immediate
4.备库执行
shutdown immediate
开启数据库
1.启动备库到mount
startup mount
2.备库开库
alter database open;
3.开启主库
startup
4.启动apply应用
alter database start logical standby apply immediate;
5.开启主备库监听
lsnrctl start
1.关闭主备库监听
lsnrctl stop
2.备库执行,关闭apply应用
alter database stop logical standby apply;
alter database abort logical standby apply; 强制终止
3.主库执行
shutdown immediate
4.备库执行
shutdown immediate
开启数据库
1.启动备库到mount
startup mount
2.备库开库
alter database open;
3.开启主库
startup
4.启动apply应用
alter database start logical standby apply immediate;
5.开启主备库监听
lsnrctl start
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30135314/viewspace-1975093/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30135314/viewspace-1975093/