几个有用的做DG的SQL命令
1.startup nomount;
2.alter database mount standby database;
3.select name, database_role from v$database;
4.alter database recover managed standby database disconnect from session;
5.alter system archive log current;
6.alter database recover managed standby database cancel;
7.alter database open read only;
8.select sequence#,first_time, next_time from v$archived_log order by sequence#;
1.startup nomount;
2.alter database mount standby database;
3.select name, database_role from v$database;
4.alter database recover managed standby database disconnect from session;
5.alter system archive log current;
6.alter database recover managed standby database cancel;
7.alter database open read only;
8.select sequence#,first_time, next_time from v$archived_log order by sequence#;
9.select sequence#, applied from v$archived_log order by sequence#;
其中 4和6可以切换做查询等操作