数据库:Oracle11.2.0.4
系统:CentOS7.9
实验目标:模拟控制文件全部损坏,并提供解决方案.
1、控制文件损坏前数据
SQL>show parameter control
NAME TYPE VALUE
----------------------------------------------- ------------------------------
control_file_record_keep_time integer 7
control_files string /data/orcl/control01.ctl, /u01
/app/oracle/fast_recovery_area
/orcl/control02.ctl
control_management_pack_access string DIAGNOSTIC+TUNING
SQL>select b.thread#,a.group#,a.member,bytes/1024/1024,b.members from v$logfilea,v$log b where a.group#=b.group#
THREAD# GROUP# MEMBER BYTES/1024/1024 MEMBERS
-------------------- ------------------------------ --------------- ----------
1 2 /data/orcl/redo02.log 50 2
1 2 /data/orcl/redo02b.log 50 2
1 1 /data/orcl/redo01.log 50 2
1 1 /data/orcl/redo01b.log 50 2
2 3 /data/orcl/redo03.log 50 2
2 3 /data/