open_mode from v$PDBS;PDB状态GDSCTL> config shardSharding状态1.2会话信息1.2会话信息SELECTSESSIONS_...
SQL> alter pluggable database orclpdb open; Pluggable database altered. SQL> startup pluggable database hrpdb open read only; Pluggable Database opened. SQL> alter pluggable database all close immediate; Pluggable database altered. SQL> alter pluggable database all open; Pluggable database altere...
alter database commit to switchover to physical standbywithsession shutdown;startup force mount;--在备库操作 select name,LOG_MODE,OPEN_MODE,database_role,SWITCHOVER_STATUS,db_unique_name,flashback_on from v$database;alter database commit to switchover to primarywithsession shutdown;alter databa...
select instance_name,status from V$INSTANCE; select db_unique_name,open_mode from V$DATABASE; 1. 2. 4、直接启动数据库 执行startup open命令直接启动数据库,相当于以上三个步骤,open可以省略不写。 startup open; 1. 二、数据库状态切换 1、从open切换到mounted状态 alter database close; 1. 2、从m...
select open_mode from v$database; 默认的open方式为read write 想改read only为read write必须重新启动数据库 我们现在回想一下数据库启动的三个台阶,我们先读的是参数文件,参数文件可以由我们来编写。读完参数文件后又读了控制文件,控制文件中描述了数据文件和日志文件的信息,如果控制文件丢失了我们可以重新建立,最...
2、数据库的OPEN_MODE 正确情况下主库应该是read write模式,备库应该是READ ONLY WITH APPLY模式。只有在DG切换前能够实现实时同步的前提下才能保证主备库切换后无数据丢失。备库的READ ONLY WITH APPLY状态说明当前standby db正处于实时同步的状态 3、数据库的角色 ...
--1、配置归档archive log list;selectname,log_mode,open_modefromv$database;show parameter cluster; //RACaltersystemsetcluster_database=falsescope=spfile; //RACshutdown immediate;startup mount;alterdatabasearchivelog;altersystemsetcluster_database=truescope=spfile; //RACshutdown immediate;startup;--...
sqlplus /assysdbaarchive log listselectopen_mode,log_mode,flashback_on,force_loggingfromv$database; 1. 2. 3. 7、 检查在线日志和切换频率 「查看在线日志大小:」 复制 setline222col memberfora100selectf.group#,f.member,l.sequence#,l.bytes/1024/1024,l.archived,l.status,l.first_timefromv$logfil...
SYS@ora19c>alter pluggable database pdb1 open; Pluggable database altered. SYS@ora19c>show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED --- --- --- --- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO SYS@ora19c>select con_id,name from v$datafile ...