archive_dest_status:显示归档重做日志目标的运行时和配置信息。
DATABASE_MODE:归档目标数据库的当前模式 MOUNTED-STANDBY - 挂载待机
RECOVERY_MODE:归档目的地的当前应用模式 LOGICAL REAL TIME APPLY - 实时 SQL 应用
MANAGED - 托管恢复处于活动状态 IDLE - 托管恢复不活跃
PROTECTION_MODE:指示数据库是否受保护
select database_mode,recovery_mode,protection_mode from v$archive_dest_status;
alter database recover managed standby database cancel;
alter database recover managed standby database using archived logfile disconnect;
alter database recover managed standby database cancel;
alter database recover managed standby database disconnect;
alter database recover managed standby database cancel;
alter database open read only;
alter database recover managed standby database disconnect;
select name,open_mode,controlfile_type from v$database;
alter database recover managed standby database cancel;
SHUTDOWN IMMEDIATE
startup mount
select name,open_mode,controlfile_type from v$database;
edit database cdb1_stby set state='APPLY-OFF';
sql 'alter database open read only';
edit database cdb1_stby set state='APPLY-ON';
在次关闭
edit database cdb1_stby set state='APPLY-OFF';
edit database cdb1_stby set state='APPLY-ON';