DG dataguard启动关闭顺序
启动 (1)启动监听
先启从库再起主库
#lsnrctl start
2)启动数据库
先启从库:
sql>startup nomount
sql>alter database mount standby database;
sql>alter database recover managed standby database using current logfile disconnect from session;
在启主库
sql>startup
如果是ACTIVE STANDBY DATABASE 则
备库:#lsnrctl start
sql>startup nomount
sql>alter database mount standby database;
sql>alter database open;
sql>alter database recover managed standby database using current logfile disconnect from session;
在启主库
sql>startup
关闭:和开启正好相反
先关主库数据库:
sql>shutdown immediate
再关从库:
sql>alter database recover managed standby database cancel;
sql>shutdown immediate;
启动 (1)启动监听
先启从库再起主库
#lsnrctl start
2)启动数据库
先启从库:
sql>startup nomount
sql>alter database mount standby database;
sql>alter database recover managed standby database using current logfile disconnect from session;
在启主库
sql>startup
如果是ACTIVE STANDBY DATABASE 则
备库:#lsnrctl start
sql>startup nomount
sql>alter database mount standby database;
sql>alter database open;
sql>alter database recover managed standby database using current logfile disconnect from session;
在启主库
sql>startup
关闭:和开启正好相反
先关主库数据库:
sql>shutdown immediate
再关从库:
sql>alter database recover managed standby database cancel;
sql>shutdown immediate;