在知识库中专注阅读，并随时返回相关工具与课程
大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。 @TOC目录 前文讲了 Oracle 数据库启动过程之 nomount 详解https://mp.weixin.qq.com/s/9NSZQlzcODE5fqmgYECf4w，接着就说说 mount 这一步数据库到底做了什么？ mount 数据库的过程是读取参数文件中的控制文件，校验控制文件是否正确，读取控制文件的内容到内存中，
系统学习 Oracle DBA
开通会员 ¥128/月起
查看完整课程大家好，这里是 Lucifer三思而后行，专注于提升数据库运维效率。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
前文讲了 Oracle 数据库启动过程之 nomount 详解，接着就说说 mount 这一步数据库到底做了什么？
mount 数据库的过程是读取参数文件中的控制文件，校验控制文件是否正确，读取控制文件的内容到内存中，查询各种文件（数据文件、日志文件）的信息，一旦 mount 成功后，代表将空实例和数据库进行关联，实现数据库实例的挂载。
数据库实例在这一阶段会被挂载，主要是打开控制文件并读取控制文件信息。
首先以 mount 方式启动数据库实例：
1-- 延续上文先启动到 nomount 状态2SQL> startup nomount3ORACLE instance started.45Total System Global Area 5328027648 bytes6Fixed Size 2262608 bytes7Variable Size 1660946864 bytes8Database Buffers 3657433088 bytes9Redo Buffers 7385088 bytes1011-- 打开到 mount 状态12SQL> alter database mount;1314Database altered.1516-- 可以查看数据库实例的打开模式17SQL> select status from v$instance;1819STATUS20------------21MOUNTED2223-- 此时也可以用 v$database 查询，nomount 阶段无法查询，因为 nomount 阶段实例与数据库无关联24SQL> select open_mode from v$database;2526OPEN_MODE27--------------------28MOUNTEDalert 日志内容如下：
1Tue Aug 27 22:21:00 20242alter database mount3Tue Aug 27 22:21:04 20244## 在这一步骤中，数据库需要计算 mount id 并将其记录在控制文件中5## 通过 alter session set events 'immediate trace name CONTROLF level 8' ; 转储控制文件信息可以看到相关记录 heartbeat: 1178182719 mount id: 40340792906Successful mount of redo thread 1, with mount id 40340587007Database mounted in Exclusive Mode8Lost write protection disabled9Completed: alter database mount进程数量没有发生变化：
1SQL> ! ps -ef|grep -v grep|grep lucifer2oracle 32417 1 0 22:20 ? 00:00:00 ora_pmon_lucifer3oracle 32419 1 0 22:20 ? 00:00:00 ora_psp0_lucifer4oracle 32421 1 0 22:20 ? 00:00:00 ora_vktm_lucifer5oracle 32425 1 0 22:20 ? 00:00:00 ora_gen0_lucifer6oracle 32427 1 0 22:20 ? 00:00:00 ora_diag_lucifer7oracle 32429 1 0 22:20 ? 00:00:00 ora_dbrm_lucifer8oracle 32431 1 0 22:20 ? 00:00:00 ora_dia0_lucifer9oracle 32433 1 0 22:20 ? 00:00:00 ora_mman_lucifer10oracle 32435 1 0 22:20 ? 00:00:00 ora_dbw0_lucifer11oracle 32437 1 0 22:20 ? 00:00:00 ora_lgwr_lucifer12oracle 32439 1 0 22:20 ? 00:00:00 ora_ckpt_lucifer13oracle 32441 1 0 22:20 ? 00:00:00 ora_smon_lucifer14oracle 32443 1 0 22:20 ? 00:00:00 ora_reco_lucifer15oracle 32445 1 0 22:20 ? 00:00:00 ora_mmon_lucifer16oracle 32447 1 0 22:20 ? 00:00:00 ora_mmnl_lucifer17oracle 32449 1 0 22:20 ? 00:00:00 ora_d000_lucifer18oracle 32451 1 0 22:20 ? 00:00:00 ora_s000_lucifer19oracle 32452 32407 0 22:20 ? 00:00:00 oraclelucifer (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))2021SQL> ! ps -ef|grep -v grep|grep ora_|wc -l2217查看控制文件参数：
1-- alert 日志中可以看到在数据库实例启动到 nomount 时就已经从参数文件中读取到控制文件的路径，为了在挂载时使用2control_files = "/oradata/lucifer/control01.ctl"3control_files = "/u01/app/oracle/fast_recovery_area/lucifer/control02.ctl"45-- 数据库中查看控制文件参数，如果控制文件损坏或者丢失，是无法挂载数据库实例的6SQL> show parameter control_files78NAME TYPE VALUE9------------------------------------ ----------- ------------------------------10control_files string /oradata/lucifer/control01.ctl11 , /u01/app/oracle/fast_recover12 y_area/lucifer/control02.ctl1314-- 查看控制文件，在 nomount 阶段查询为空15SQL> select * from v$controlfile;1617STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS18------- ------------------------------------------------------------ --- ---------- --------------19 /oradata/lucifer/control01.ctl NO 16384 59420 /u01/app/oracle/fast_recovery_area/lucifer/control02.ctl NO 16384 5942122-- 同时也可以查看数据文件以及日志文件信息，nomount 阶段查询会报错，因为没有读取控制文件23SQL> select name from v$datafile;2425NAME26------------------------------------------------------------27/oradata/lucifer/system01.dbf28/oradata/lucifer/sysaux01.dbf29/oradata/lucifer/undotbs01.dbf30/oradata/lucifer/users01.dbf3132SQL> select member from v$logfile;3334MEMBER35------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------36/oradata/lucifer/redo03.log37/oradata/lucifer/redo02.log38/oradata/lucifer/redo01.log39/oradata/lucifer/redo04.log40/oradata/lucifer/redo05.log41/oradata/lucifer/redo06.log42/oradata/lucifer/redo07.log43/oradata/lucifer/redo08.log44458 rows selected.这里读取到的数据文件和日志文件信息只是控制文件中记录的信息，并不会检查这些文件是否存在于系统层面。
前文说了 ckpt（Checkpoint Process）进程会更新数据库的控制文件以指示最近的检查点，所以通过检查点进程可以看到控制文件被打开：
1## 挂载数据库前查看 ckpt 进程，没有控制文件相关文件描述符2[oracle@oracle11g:/home/oracle]$ ps -ef|grep ckpt|grep -v grep3oracle 32439 1 0 22:20 ? 00:00:00 ora_ckpt_lucifer4[oracle@oracle11g:/home/oracle]$ cd /proc/32439/fd5[oracle@oracle11g:/proc/32439/fd]$ ls -ltr | grep control67## 挂载数据库后可以明确看到文件描述符指向了数据库的两个控制文件8[oracle@oracle11g:/home/oracle]$ ps -ef|grep ckpt|grep -v grep9oracle 32439 1 0 22:20 ? 00:00:00 ora_ckpt_lucifer10[oracle@oracle11g:/home/oracle]$ cd /proc/32439/fd11[oracle@oracle11g:/proc/32439/fd]$ ls -ltr | grep control12lrwx------ 1 oracle oinstall 64 Aug 27 22:25 257 -> /u01/app/oracle/fast_recovery_area/lucifer/control02.ctl13lrwx------ 1 oracle oinstall 64 Aug 27 22:25 256 -> /oradata/lucifer/control01.ctl使用 strace 的方式查看 ckpt 进程读写控制文件：
1[oracle@oracle11g:/home/oracle]$ strace -fr -o /tmp/32439.log -p 324392strace: Process 32439 attached3^Cstrace: Process 32439 detached45## 查看 strace 日志内容6[oracle@oracle11g:/home/oracle]$ cat /tmp/32439.log7## 截取部分内容如下832439 0.000296 getrusage(RUSAGE_SELF, {ru_utime={tv_sec=0, tv_usec=62245}, ru_stime={tv_sec=0, tv_usec=91858}, ...}) = 0932439 0.000247 times({tms_utime=6 /* 0.06 s */, tms_stime=9 /* 0.09 s */, tms_cutime=0, tms_cstime=0}) = 4312995521032439 0.000140 times({tms_utime=6 /* 0.06 s */, tms_stime=9 /* 0.09 s */, tms_cutime=0, tms_cstime=0}) = 4312995521132439 0.000586 pwrite64(256, "\25\302\0\0\3\0\0\0\0\0\0\0\0\0\1\4NB\0\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 49152) = 163841232439 0.001237 pwrite64(257, "\25\302\0\0\3\0\0\0\0\0\0\0\0\0\1\4NB\0\0\1\0\0\0\0\0\0\0\0\0\0\0"..., 16384, 49152) = 163841332439 0.000814 times({tms_utime=6 /* 0.06 s */, tms_stime=9 /* 0.09 s */, tms_cutime=0, tms_cstime=0}) = 4312995521432439 0.000234 semtimedop(29, [{sem_num=16, sem_op=-1, sem_flg=0}], 1, {tv_sec=3, tv_nsec=0}) = -1 EAGAIN (Resource temporarily unavailable)1532439 3.004190 getrusage(RUSAGE_SELF, {ru_utime={tv_sec=0, tv_usec=62301}, ru_stime={tv_sec=0, tv_usec=92840}, ...}) = 0通过上面的进程跟踪，可以得到以下内容：
在检查点发生的时候，会产生 scn 值，也就是检查点 scn(checkpoint scn)，该值是相当重要的，在进行文件头修复等数据库恢复时，起着至关重要的作用，在 mount 阶段可以查询：
1-- v$datafile 的 checkpoint 信息是来自控制文件2SQL> select file#,STATUS,CHECKPOINT_CHANGE#,ONLINE_CHANGE# from v$datafile;34 FILE# STATUS CHECKPOINT_CHANGE# ONLINE_CHANGE#5---------- ------- ------------------ --------------6 1 SYSTEM 998288 9257027 2 ONLINE 998288 9257028 3 ONLINE 998288 9257029 4 ONLINE 998288 9257021011-- v$datafile_header 的 checkpoint 信息是来自数据库文件头12SQL> select file#,STATUS,CHECKPOINT_CHANGE#,CHECKPOINT_COUNT from v$datafile_header order by 1;1314 FILE# STATUS CHECKPOINT_CHANGE# CHECKPOINT_COUNT15---------- ------- ------------------ ----------------16 1 ONLINE 998288 9717 2 ONLINE 998288 9718 3 ONLINE 998288 1819 4 ONLINE 998288 962021-- 注意：这里是真的会去数据文件中查询，如果系统不存在这个文件，那么获取到的值都为 0，但是不会报错22SQL> select file#,STATUS,CHECKPOINT_CHANGE#,CHECKPOINT_COUNT from v$datafile_header order by 1;2324 FILE# STATUS CHECKPOINT_CHANGE# CHECKPOINT_COUNT25---------- ------- ------------------ ----------------26 1 ONLINE 0 027 2 ONLINE 0 028 3 ONLINE 0 029 4 ONLINE 0 0如果这两个值不一致，则说明数据库不是正常关闭，需要进行数据恢复。
当然，我们也可以使用 10046 trace 来看看有没有更多信息可以挖掘：
1-- 先启动到 nomount2SQL> startup nomount3ORACLE instance started.45Total System Global Area 5328027648 bytes6Fixed Size 2262608 bytes7Variable Size 1660946864 bytes8Database Buffers 3657433088 bytes9Redo Buffers 7385088 bytes1011-- 启用 oradebug12SQL> oradebug setmypid13Statement processed.1415-- 启用 10046 trace16SQL> oradebug event 10046 trace name context forever,level 12;17Statement processed.1819-- 挂载数据库实例20SQL> alter database mount;2122Database altered.2324-- 关闭 10046 trace25SQL> oradebug event 10046 trace name context off;26Statement processed.2728-- 查看 trace 文件路径29SQL> oradebug tracefile_name30/u01/app/oracle/diag/rdbms/lucifer/lucifer/trace/lucifer_ora_32881.trc查看 10046 trace 文件内容，只截取部分重要内容：
1PARSE #139684468473392:c=809,e=823,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=17247692241421282WAIT #139684468473392: nam='rdbms ipc reply' ela= 162 from_process=10 timeout=60 p3=0 obj#=-1 tim=17247692241428463WAIT #139684468473392: nam='reliable message' ela= 218 channel context=6801122424 channel handle=6800212608 broadcast message=6801700800 obj#=-1 tim=17247692241437224WAIT #139684468473392: nam='rdbms ipc reply' ela= 724 from_process=12 timeout=900 p3=0 obj#=-1 tim=17247692241445835WAIT #139684468473392: nam='Disk file operations I/O' ela= 45 FileOperation=2 fileno=0 filetype=1 obj#=-1 tim=17247692241448216WAIT #139684468473392: nam='Disk file operations I/O' ela= 18 FileOperation=2 fileno=1 filetype=1 obj#=-1 tim=17247692241448667WAIT #139684468473392: nam='control file sequential read' ela= 14 file#=0 block#=1 blocks=1 obj#=-1 tim=17247692241448938WAIT #139684468473392: nam='control file sequential read' ela= 11 file#=1 block#=1 blocks=1 obj#=-1 tim=17247692241449679WAIT #139684468473392: nam='control file sequential read' ela= 99 file#=0 block#=3 blocks=8 obj#=-1 tim=172476922414514310WAIT #139684468473392: nam='control file sequential read' ela= 23 file#=1 block#=3 blocks=8 obj#=-1 tim=17247692241451921112*** 2024-08-27 22:33:48.17213WAIT #139684468473392: nam='control file heartbeat' ela= 4027402 p1=0 p2=0 p3=0 obj#=-1 tim=172476922817261614WAIT #139684468473392: nam='control file sequential read' ela= 47 file#=0 block#=3 blocks=8 obj#=-1 tim=172476922817285915WAIT #139684468473392: nam='control file sequential read' ela= 20 file#=1 block#=3 blocks=8 obj#=-1 tim=172476922817291016WAIT #139684468473392: nam='control file sequential read' ela= 9 file#=0 block#=1 blocks=1 obj#=-1 tim=172476922817294017WAIT #139684468473392: nam='control file parallel write' ela= 1353 files=1 block#=1 requests=1 obj#=-1 tim=172476922817431318WAIT #139684468473392: nam='control file sequential read' ela= 24 file#=1 block#=1 blocks=1 obj#=-1 tim=172476922817441619WAIT #139684468473392: nam='control file parallel write' ela= 682 files=1 block#=1 requests=1 obj#=-1 tim=172476922817512220WAIT #139684468473392: nam='control file sequential read' ela= 12 file#=0 block#=16 blocks=1 obj#=-1 tim=172476922817516921WAIT #139684468473392: nam='control file sequential read' ela= 8 file#=0 block#=18 blocks=1 obj#=-1 tim=172476922817519922WAIT #139684468473392: nam='control file parallel write' ela= 1212 files=2 block#=17 requests=2 obj#=-1 tim=172476922817644923WAIT #139684468473392: nam='control file parallel write' ela= 1101 files=2 block#=15 requests=2 obj#=-1 tim=172476922817760224WAIT #139684468473392: nam='control file parallel write' ela= 1049 files=2 block#=1 requests=2 obj#=-1 tim=172476922817867525WAIT #139684468473392: nam='control file sequential read' ela= 40 file#=0 block#=3 blocks=8 obj#=-1 tim=172476922817876126WAIT #139684468473392: nam='control file parallel write' ela= 526 files=1 block#=3 requests=1 obj#=-1 tim=172476922817932227WAIT #139684468473392: nam='control file parallel write' ela= 547 files=1 block#=4 requests=1 obj#=-1 tim=172476922817989128WAIT #139684468473392: nam='control file parallel write' ela= 565 files=1 block#=5 requests=1 obj#=-1 tim=172476922818048129WAIT #139684468473392: nam='control file parallel write' ela= 520 files=1 block#=6 requests=1 obj#=-1 tim=172476922818102130WAIT #139684468473392: nam='control file parallel write' ela= 519 files=1 block#=7 requests=1 obj#=-1 tim=172476922818156431WAIT #139684468473392: nam='control file parallel write' ela= 492 files=1 block#=8 requests=1 obj#=-1 tim=172476922818208332WAIT #139684468473392: nam='control file parallel write' ela= 624 files=1 block#=9 requests=1 obj#=-1 tim=172476922818272733WAIT #139684468473392: nam='control file parallel write' ela= 588 files=1 block#=10 requests=1 obj#=-1 tim=172476922818334234WAIT #139684468473392: nam='control file parallel write' ela= 535 files=1 block#=11 requests=1 obj#=-1 tim=172476922818389935WAIT #139684468473392: nam='control file parallel write' ela= 505 files=1 block#=12 requests=1 obj#=-1 tim=172476922818442836WAIT #139684468473392: nam='control file parallel write' ela= 499 files=1 block#=13 requests=1 obj#=-1 tim=172476922818494637WAIT #139684468473392: nam='control file sequential read' ela= 29 file#=0 block#=282 blocks=1 obj#=-1 tim=172476922818500138WAIT #139684468473392: nam='control file parallel write' ela= 1114 files=2 block#=281 requests=2 obj#=-1 tim=172476922818613639WAIT #139684468473392: nam='control file parallel write' ela= 1011 files=2 block#=18 requests=2 obj#=-1 tim=172476922818717240WAIT #139684468473392: nam='control file parallel write' ela= 1005 files=2 block#=16 requests=2 obj#=-1 tim=172476922818820141WAIT #139684468473392: nam='control file parallel write' ela= 1086 files=2 block#=1 requests=2 obj#=-1 tim=172476922818931142WAIT #139684468473392: nam='control file sequential read' ela= 12 file#=0 block#=23 blocks=1 obj#=-1 tim=172476922818939843WAIT #139684468473392: nam='control file sequential read' ela= 7 file#=0 block#=181 blocks=1 obj#=-1 tim=172476922818942944WAIT #139684468473392: nam='control file sequential read' ela= 7 file#=0 block#=308 blocks=1 obj#=-1 tim=172476922818946945WAIT #139684468473392: nam='control file sequential read' ela= 7 file#=0 block#=310 blocks=1 obj#=-1 tim=172476922818949046WAIT #139684468473392: nam='control file sequential read' ela= 11 file#=0 block#=327 blocks=1 obj#=-1 tim=172476922818954647WAIT #139684468473392: nam='control file parallel write' ela= 1121 files=2 block#=309 requests=2 obj#=-1 tim=172476922819070548WAIT #139684468473392: nam='control file sequential read' ela= 8 file#=0 block#=281 blocks=1 obj#=-1 tim=172476922819073549WAIT #139684468473392: nam='control file parallel write' ela= 1004 files=2 block#=328 requests=2 obj#=-1 tim=172476922819175550WAIT #139684468473392: nam='control file sequential read' ela= 9 file#=0 block#=283 blocks=1 obj#=-1 tim=172476922819178651WAIT #139684468473392: nam='control file parallel write' ela= 982 files=2 block#=17 requests=2 obj#=-1 tim=172476922819279952WAIT #139684468473392: nam='control file parallel write' ela= 1035 files=2 block#=15 requests=2 obj#=-1 tim=172476922819385853WAIT #139684468473392: nam='control file parallel write' ela= 1011 files=2 block#=1 requests=2 obj#=-1 tim=172476922819489454WAIT #139684468473392: nam='control file sequential read' ela= 10 file#=0 block#=1 blocks=1 obj#=-1 tim=172476922819495555WAIT #139684468473392: nam='control file sequential read' ela= 7 file#=1 block#=1 blocks=1 obj#=-1 tim=172476922819498456WAIT #139684468473392: nam='control file sequential read' ela= 6 file#=0 block#=15 blocks=1 obj#=-1 tim=172476922819501157WAIT #139684468473392: nam='control file sequential read' ela= 4 file#=0 block#=17 blocks=1 obj#=-1 tim=172476922819502758WAIT #139684468473392: nam='control file sequential read' ela= 9 file#=0 block#=519 blocks=1 obj#=-1 tim=172476922819505559WAIT #139684468473392: nam='control file parallel write' ela= 1041 files=2 block#=520 requests=2 obj#=-1 tim=172476922819611460WAIT #139684468473392: nam='control file parallel write' ela= 988 files=2 block#=18 requests=2 obj#=-1 tim=172476922819712761WAIT #139684468473392: nam='control file parallel write' ela= 1022 files=2 block#=16 requests=2 obj#=-1 tim=172476922819817362WAIT #139684468473392: nam='control file parallel write' ela= 1026 files=2 block#=1 requests=2 obj#=-1 tim=172476922819922363WAIT #139684468473392: nam='rdbms ipc reply' ela= 809 from_process=10 timeout=910 p3=0 obj#=-1 tim=172476922820046164WAIT #139684468473392: nam='rdbms ipc reply' ela= 6026 from_process=11 timeout=1800 p3=0 obj#=-1 tim=172476922820653965WAIT #139684468473392: nam='control file sequential read' ela= 10 file#=0 block#=1 blocks=1 obj#=-1 tim=172476922820659066WAIT #139684468473392: nam='control file sequential read' ela= 5 file#=0 block#=15 blocks=1 obj#=-1 tim=172476922820661067WAIT #139684468473392: nam='control file sequential read' ela= 5 file#=0 block#=17 blocks=1 obj#=-1 tim=172476922820662668WAIT #139684468473392: nam='rdbms ipc reply' ela= 139 from_process=12 timeout=2147483647 p3=0 obj#=-1 tim=172476922820680769WAIT #139684468473392: nam='control file sequential read' ela= 7 file#=0 block#=1 blocks=1 obj#=-1 tim=172476922820703470WAIT #139684468473392: nam='control file sequential read' ela= 9 file#=1 block#=1 blocks=1 obj#=-1 tim=172476922820706371WAIT #139684468473392: nam='control file sequential read' ela= 5 file#=0 block#=15 blocks=1 obj#=-1 tim=172476922820708172WAIT #139684468473392: nam='control file sequential read' ela= 5 file#=0 block#=17 blocks=1 obj#=-1 tim=172476922820709773WAIT #139684468473392: nam='control file sequential read' ela= 6 file#=0 block#=281 blocks=1 obj#=-1 tim=1724769228207120针对上面的 10046 trace 中的:
file# 0：第一个控制文件 /oradata/lucifer/control01.ctl file # 1：第二个控制文件 /u01/app/oracle/fast_recovery_area/lucifer/control02.ctl block#：block 号 blocks：block 数量 files：文件数
从日志中可以看出，数据库在执行 ALTER DATABASE MOUNT 命令时，经历了多个等待状态，主要是对控制文件的读写操作。
很多朋友可能没有了解过控制文件中的内容，这里附带讲一下，介绍两种比较常用的方式：
转储控制文件信息：
1SQL> oradebug setmypid2Statement processed.3SQL> oradebug event immediate trace name CONTROLF level 8;4Statement processed.5SQL> oradebug event immediate trace name CONTROLF off;6Statement processed.7SQL> oradebug tracefile_name8/u01/app/oracle/diag/rdbms/lucifer/lucifer/trace/lucifer_ora_34673.trc查看控制文件转储信息：
1*** 2024-08-28 09:47:19.9352Processing Oradebug command 'event immediate trace name CONTROLF level 8'3DUMP OF CONTROL FILES, Seq # 1080 = 0x4384 V10 STYLE FILE HEADER:5 Compatibility Vsn = 186647552=0xb2004006 Db ID=4034009431=0xf0721957, Db Name='LUCIFER'7 Activation ID=0=0x08 Control Seq=1080=0x438, File size=594=0x2529 File Number=0, Blksiz=16384, File Type=1 CONTROL10 11 12 13 14***************************************************************************15DATABASE ENTRY16***************************************************************************17 (size = 316, compat size = 316, section max = 1, section in-use = 1,18 last-recid= 0, old-recno = 0, last-recno = 0)19 (extent = 1, blkno = 1, numrecs = 1)20 08/27/2024 17:16:0721 DB Name "LUCIFER"22 Database flags = 0x00404001 0x0000100023 Controlfile Creation Timestamp 08/27/2024 17:16:0724 Incmplt recovery scn: 0x0000.0000000025 Resetlogs scn: 0x0000.000e2006 Resetlogs Timestamp 08/27/2024 17:16:0926 Prior resetlogs scn: 0x0000.00000001 Prior resetlogs Timestamp 08/24/2013 11:37:3027 Redo Version: compatible=0xb20040028 #Data files = 4, #Online files = 429 Database checkpoint: Thread=1 scn: 0x0000.000f90bd30 Threads: #Enabled=1, #Open=0, Head=0, Tail=031 enabled threads: 01000000 00000000 00000000 00000000 00000000 0000000032 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000033 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000034 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000035 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000036 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000037 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000038 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000039 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000041 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000042 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000043 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000044 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000045 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000046 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000047 00000000 00000000 00000000 00000000 00000000 0000000048 Max log members = 3, Max data members = 149 Arch list: Head=4, Tail=4, Force scn: 0x0000.000e2006scn: 0x0000.0000000050 Activation ID: 403400431151 SCN compatibility 352 Auto-rollover enabled53 Controlfile Checkpointed at scn: 0x0000.000f906e 08/28/2024 09:35:1254 thread:0 rba:(0x0.0.0)55 enabled threads: 00000000 00000000 00000000 00000000 00000000 0000000056 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000057 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000058 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000059 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000060 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000061 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000062 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000063 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000064 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000065 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000066 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000067 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000068 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000069 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000070 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000071 00000000 00000000 00000000 00000000 00000000 0000000072 73 74 75 76***************************************************************************77CHECKPOINT PROGRESS RECORDS78***************************************************************************79 (size = 8180, compat size = 8180, section max = 11, section in-use = 0,80 last-recid= 0, old-recno = 0, last-recno = 0)81 (extent = 1, blkno = 2, numrecs = 11)82THREAD #1 - status:0x1 flags:0x0 dirty:083low cache rba:(0xffffffff.ffffffff.ffff) on disk rba:(0x4.286d9.0)84on disk scn: 0x0000.000f9094 08/28/2024 09:36:3285resetlogs scn: 0x0000.000e2006 08/27/2024 17:16:0986heartbeat: 1178182923 mount id: 403407929087THREAD #2 - status:0x0 flags:0x0 dirty:088low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)89on disk scn: 0x0000.00000000 01/01/1988 00:00:0090resetlogs scn: 0x0000.00000000 01/01/1988 00:00:0091heartbeat: 0 mount id: 092THREAD #3 - status:0x0 flags:0x0 dirty:093low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)94on disk scn: 0x0000.00000000 01/01/1988 00:00:0095resetlogs scn: 0x0000.00000000 01/01/1988 00:00:0096heartbeat: 0 mount id: 097THREAD #4 - status:0x0 flags:0x0 dirty:098low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)99on disk scn: 0x0000.00000000 01/01/1988 00:00:00100resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00101heartbeat: 0 mount id: 0102THREAD #5 - status:0x0 flags:0x0 dirty:0103low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)104on disk scn: 0x0000.00000000 01/01/1988 00:00:00105resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00106heartbeat: 0 mount id: 0107THREAD #6 - status:0x0 flags:0x0 dirty:0108low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)109on disk scn: 0x0000.00000000 01/01/1988 00:00:00110resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00111heartbeat: 0 mount id: 0112THREAD #7 - status:0x0 flags:0x0 dirty:0113low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)114on disk scn: 0x0000.00000000 01/01/1988 00:00:00115resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00116heartbeat: 0 mount id: 0117THREAD #8 - status:0x0 flags:0x0 dirty:0118low cache rba:(0x0.0.0) on disk rba:(0x0.0.0)119on disk scn: 0x0000.00000000 01/01/1988 00:00:00120resetlogs scn: 0x0000.00000000 01/01/1988 00:00:00121heartbeat: 0 mount id: 0122 123 124 125 126***************************************************************************127EXTENDED DATABASE ENTRY128***************************************************************************129 (size = 900, compat size = 900, section max = 1, section in-use = 1,130 last-recid= 0, old-recno = 0, last-recno = 0)131 (extent = 1, blkno = 140, numrecs = 1)132Control AutoBackup date(dd/mm/yyyy)=27/ 8/2024133Next AutoBackup sequence= 0134Database recovery target inc#:2, Last open inc#:2135flg:0x0, flag:0x0136Change tracking state=0, file index=0, checkpoint count=0scn: 0x0000.00000000137Flashback log count=0, block count=0138Desired flashback log size=0 blocks139Oldest guarantee restore point=0140Highest thread enable/disable scn: 0x0000.00000000141Number of Open thread with finite next SCN in last log: 0142Number of half-enabled redo threads: 0143Sum of absolute file numbers for files currently being moved online: 0144 145 146 147 148***************************************************************************149REDO THREAD RECORDS150***************************************************************************151 (size = 256, compat size = 256, section max = 8, section in-use = 1,152 last-recid= 0, old-recno = 0, last-recno = 0)153 (extent = 1, blkno = 9, numrecs = 8)154THREAD #1 - status:0xe thread links forward:0 back:0155 #logs:8 first:1 last:8 current:4 last used seq#:0x4156 enabled at scn: 0x0000.000e2006 08/27/2024 17:16:09157 disabled at scn: 0x0000.00000000 01/01/1988 00:00:00158 opened at 08/27/2024 22:57:27 by instance lucifer159Checkpointed at scn: 0x0000.000f90bd 08/28/2024 09:36:36160 thread:1 rba:(0x4.2870d.10)161 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000162 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000163 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000164 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000165 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000166 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000167 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000168 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000169 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000170 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000171 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000172 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000173 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000174 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000175 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000176 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000177 00000000 00000000 00000000 00000000 00000000 00000000178 log history: 3179 restore point keep sequence: 0180 181 182 183 184***************************************************************************185LOG FILE RECORDS186***************************************************************************187 (size = 72, compat size = 72, section max = 16, section in-use = 8,188 last-recid= 8, old-recno = 0, last-recno = 0)189 (extent = 1, blkno = 10, numrecs = 16)190LOG FILE #1: 191 name #3: /oradata/lucifer/redo01.log192 Thread 1 redo log links: forward: 2 backward: 0193 siz: 0x32000 seq: 0x00000001 hws: 0xa bsz: 512 nab: 0x2850f flg: 0x1 dup: 1194 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000195 Low scn: 0x0000.000e2006 08/27/2024 17:16:09196 Next scn: 0x0000.000e2dce 08/27/2024 17:16:37197LOG FILE #2: 198 name #2: /oradata/lucifer/redo02.log199 Thread 1 redo log links: forward: 3 backward: 1200 siz: 0x32000 seq: 0x00000002 hws: 0x8 bsz: 512 nab: 0x28cd4 flg: 0x1 dup: 1201 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000e2006202 Low scn: 0x0000.000e2dce 08/27/2024 17:16:37203 Next scn: 0x0000.000ea696 08/27/2024 17:17:19204LOG FILE #3: 205 name #1: /oradata/lucifer/redo03.log206 Thread 1 redo log links: forward: 4 backward: 2207 siz: 0x32000 seq: 0x00000003 hws: 0xd bsz: 512 nab: 0x4847 flg: 0x1 dup: 1208 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000e2dce209 Low scn: 0x0000.000ea696 08/27/2024 17:17:19210 Next scn: 0x0000.000f022b 08/27/2024 17:23:19211LOG FILE #4: 212 name #9: /oradata/lucifer/redo04.log213 Thread 1 redo log links: forward: 5 backward: 3214 siz: 0x32000 seq: 0x00000004 hws: 0xc bsz: 512 nab: 0x2870d flg: 0x8 dup: 1215 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.000ea696216 Low scn: 0x0000.000f022b 08/27/2024 17:23:19217 Next scn: 0xffff.ffffffff 01/01/1988 00:00:00218LOG FILE #5: 219 name #10: /oradata/lucifer/redo05.log220 Thread 1 redo log links: forward: 6 backward: 4221 siz: 0x32000 seq: 0x00000000 hws: 0x5 bsz: 512 nab: 0x2 flg: 0x1 dup: 1222 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000223 Low scn: 0x0000.00000000 01/01/1988 00:00:00224 Next scn: 0x0000.00000000 01/01/1988 00:00:00225LOG FILE #6: 226 name #11: /oradata/lucifer/redo06.log227 Thread 1 redo log links: forward: 7 backward: 5228 siz: 0x32000 seq: 0x00000000 hws: 0x5 bsz: 512 nab: 0x2 flg: 0x1 dup: 1229 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000230 Low scn: 0x0000.00000000 01/01/1988 00:00:00231 Next scn: 0x0000.00000000 01/01/1988 00:00:00232LOG FILE #7: 233 name #12: /oradata/lucifer/redo07.log234 Thread 1 redo log links: forward: 8 backward: 6235 siz: 0x32000 seq: 0x00000000 hws: 0x5 bsz: 512 nab: 0x2 flg: 0x1 dup: 1236 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000237 Low scn: 0x0000.00000000 01/01/1988 00:00:00238 Next scn: 0x0000.00000000 01/01/1988 00:00:00239LOG FILE #8: 240 name #13: /oradata/lucifer/redo08.log241 Thread 1 redo log links: forward: 0 backward: 7242 siz: 0x32000 seq: 0x00000000 hws: 0x5 bsz: 512 nab: 0x2 flg: 0x1 dup: 1243 Archive links: fwrd: 0 back: 0 Prev scn: 0x0000.00000000244 Low scn: 0x0000.00000000 01/01/1988 00:00:00245 Next scn: 0x0000.00000000 01/01/1988 00:00:00246 247 248 249 250***************************************************************************251DATA FILE RECORDS252***************************************************************************253 (size = 520, compat size = 520, section max = 100, section in-use = 4,254 last-recid= 18, old-recno = 0, last-recno = 0)255 (extent = 1, blkno = 11, numrecs = 100)256DATA FILE #1: 257 name #7: /oradata/lucifer/system01.dbf258creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1259 tablespace 0, index=1 krfil=1 prev_file=0260 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00261 Checkpoint cnt:101 scn: 0x0000.000f90bd 08/28/2024 09:36:36262 Stop scn: 0x0000.000f90bd 08/28/2024 09:36:36263 Creation Checkpointed at scn: 0x0000.00000007 08/24/2013 11:37:33264 thread:0 rba:(0x0.0.0)265 enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000266 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000267 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000268 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000269 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000270 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000271 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000272 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000273 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000274 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000275 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000276 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000277 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000278 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000279 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000280 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000281 00000000 00000000 00000000 00000000 00000000 00000000282 Offline scn: 0x0000.000e2005 prev_range: 0283 Online Checkpointed at scn: 0x0000.000e2006 08/27/2024 17:16:09284 thread:1 rba:(0x1.2.0)285 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000286 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000287 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000288 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000289 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000290 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000291 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000292 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000293 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000294 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000295 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000296 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000297 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000298 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000299 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000300 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000301 00000000 00000000 00000000 00000000 00000000 00000000302 Hot Backup end marker scn: 0x0000.00000000303 aux_file is NOT DEFINED 304 Plugged readony: NO305 Plugin scnscn: 0x0000.00000000306 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00307 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00308 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00309 Online move state: 0310DATA FILE #2: 311 name #6: /oradata/lucifer/sysaux01.dbf312creation size=0 block size=8192 status=0xe head=6 tail=6 dup=1313 tablespace 1, index=2 krfil=2 prev_file=0314 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00315 Checkpoint cnt:101 scn: 0x0000.000f90bd 08/28/2024 09:36:36316 Stop scn: 0x0000.000f90bd 08/28/2024 09:36:36317 Creation Checkpointed at scn: 0x0000.0000072a 08/24/2013 11:37:37318 thread:0 rba:(0x0.0.0)319 enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000320 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000321 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000322 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000323 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000324 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000325 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000326 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000327 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000328 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000329 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000330 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000331 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000332 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000333 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000334 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000335 00000000 00000000 00000000 00000000 00000000 00000000336 Offline scn: 0x0000.000e2005 prev_range: 0337 Online Checkpointed at scn: 0x0000.000e2006 08/27/2024 17:16:09338 thread:1 rba:(0x1.2.0)339 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000340 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000341 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000342 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000343 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000344 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000345 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000346 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000347 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000348 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000349 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000350 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000351 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000352 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000353 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000354 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000355 00000000 00000000 00000000 00000000 00000000 00000000356 Hot Backup end marker scn: 0x0000.00000000357 aux_file is NOT DEFINED 358 Plugged readony: NO359 Plugin scnscn: 0x0000.00000000360 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00361 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00362 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00363 Online move state: 0364DATA FILE #3: 365 name #5: /oradata/lucifer/undotbs01.dbf366creation size=0 block size=8192 status=0xe head=5 tail=5 dup=1367 tablespace 2, index=3 krfil=3 prev_file=0368 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00369 Checkpoint cnt:22 scn: 0x0000.000f90bd 08/28/2024 09:36:36370 Stop scn: 0x0000.000f90bd 08/28/2024 09:36:36371 Creation Checkpointed at scn: 0x0000.000e16c0 08/24/2013 12:07:19372 thread:0 rba:(0x0.0.0)373 enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000374 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000375 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000376 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000377 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000378 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000379 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000380 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000381 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000382 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000383 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000384 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000385 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000386 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000387 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000388 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000389 00000000 00000000 00000000 00000000 00000000 00000000390 Offline scn: 0x0000.000e2005 prev_range: 0391 Online Checkpointed at scn: 0x0000.000e2006 08/27/2024 17:16:09392 thread:1 rba:(0x1.2.0)393 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000394 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000395 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000396 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000397 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000398 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000399 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000400 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000401 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000402 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000403 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000404 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000405 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000406 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000407 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000408 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000409 00000000 00000000 00000000 00000000 00000000 00000000410 Hot Backup end marker scn: 0x0000.00000000411 aux_file is NOT DEFINED 412 Plugged readony: NO413 Plugin scnscn: 0x0000.00000000414 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00415 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00416 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00417 Online move state: 0418DATA FILE #4: 419 name #4: /oradata/lucifer/users01.dbf420creation size=0 block size=8192 status=0xe head=4 tail=4 dup=1421 tablespace 4, index=4 krfil=4 prev_file=0422 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00423 Checkpoint cnt:100 scn: 0x0000.000f90bd 08/28/2024 09:36:36424 Stop scn: 0x0000.000f90bd 08/28/2024 09:36:36425 Creation Checkpointed at scn: 0x0000.00003f0f 08/24/2013 11:37:49426 thread:0 rba:(0x0.0.0)427 enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000428 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000429 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000430 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000431 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000432 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000433 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000434 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000435 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000436 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000437 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000438 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000439 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000440 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000441 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000442 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000443 00000000 00000000 00000000 00000000 00000000 00000000444 Offline scn: 0x0000.000e2005 prev_range: 0445 Online Checkpointed at scn: 0x0000.000e2006 08/27/2024 17:16:09446 thread:1 rba:(0x1.2.0)447 enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000448 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000449 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000450 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000451 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000452 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000453 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000454 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000455 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000456 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000457 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000458 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000459 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000460 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000461 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000462 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000463 00000000 00000000 00000000 00000000 00000000 00000000464 Hot Backup end marker scn: 0x0000.00000000465 aux_file is NOT DEFINED 466 Plugged readony: NO467 Plugin scnscn: 0x0000.00000000468 Plugin resetlogs scn/timescn: 0x0000.00000000 01/01/1988 00:00:00469 Foreign creation scn/timescn: 0x0000.00000000 01/01/1988 00:00:00470 Foreign checkpoint scn/timescn: 0x0000.00000000 01/01/1988 00:00:00471 Online move state: 0472 473 474 475 476***************************************************************************477TEMP FILE RECORDS478***************************************************************************479 (size = 56, compat size = 56, section max = 100, section in-use = 1,480 last-recid= 10, old-recno = 0, last-recno = 0)481 (extent = 1, blkno = 90, numrecs = 100)482TEMP FILE #1: External File #5001 483 name #8: /oradata/lucifer/temp01.dbf484creation size=2560 block size=8192 status=0x1e head=8 tail=8 dup=1485 tablespace 3, index=5 krfil=1 prev_file=0486 unrecoverable scn: 0x0000.000e2051 08/27/2024 17:16:17487 488 489 490 491***************************************************************************492TABLESPACE RECORDS493***************************************************************************494 (size = 68, compat size = 68, section max = 100, section in-use = 5,495 last-recid= 1, old-recno = 0, last-recno = 0)496 (extent = 1, blkno = 89, numrecs = 100)497TABLESPACE #0 SYSTEM: recno=1498 First datafile link=1 Tablespace Flag=0499 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00500 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00501TABLESPACE #1 SYSAUX: recno=2502 First datafile link=2 Tablespace Flag=0503 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00504 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00505TABLESPACE #2 UNDOTBS1: recno=3506 First datafile link=3 Tablespace Flag=0507 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00508 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00509TABLESPACE #4 USERS: recno=4510 First datafile link=4 Tablespace Flag=0511 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00512 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00513TABLESPACE #3 TEMP: recno=5514 First datafile link=1 Tablespace Flag=1515 Tablespace PITR mode start scn: 0x0000.00000000 01/01/1988 00:00:00516 Tablespace PITR last completion scn: 0x0000.00000000 01/01/1988 00:00:00517 518 519 520 521***************************************************************************522RMAN CONFIGURATION RECORDS523***************************************************************************524 (size = 1108, compat size = 1108, section max = 50, section in-use = 0,525 last-recid= 0, old-recno = 0, last-recno = 0)526 (extent = 1, blkno = 91, numrecs = 50)527 528 529 530 531***************************************************************************532FLASHBACK LOGFILE RECORDS533***************************************************************************534 (size = 84, compat size = 84, section max = 2048, section in-use = 0,535 last-recid= 0, old-recno = 0, last-recno = 0)536 (extent = 1, blkno = 142, numrecs = 2048)537 538 539 540 541***************************************************************************542THREAD INSTANCE MAPPING RECORDS543***************************************************************************544 (size = 80, compat size = 80, section max = 8, section in-use = 8,545 last-recid= 0, old-recno = 0, last-recno = 0)546 (extent = 1, blkno = 159, numrecs = 8)547lucifer recno=1548UNNAMED_INSTANCE_2 recno=2549UNNAMED_INSTANCE_3 recno=3550UNNAMED_INSTANCE_4 recno=4551UNNAMED_INSTANCE_5 recno=5552UNNAMED_INSTANCE_6 recno=6553UNNAMED_INSTANCE_7 recno=7554UNNAMED_INSTANCE_8 recno=8555 556 557 558 559***************************************************************************560MTTR RECORDS561***************************************************************************562 (size = 100, compat size = 100, section max = 8, section in-use = 1,563 last-recid= 0, old-recno = 0, last-recno = 0)564 (extent = 1, blkno = 160, numrecs = 8)565MTTR record for thread 1566MTTR statistics status: 1567Init time: Avg: 8512344 us, Times measured: 4568File open time: Avg: 2690 us, Times measured: 11569Log block read time: Avg: 20 us, Times measured: 65536570Data block read/claim time: Avg: 170 us, Times measured: 1000571Data block write time: Avg: 390 us5721000 change vector apply time: Avg: 0 us, Times measured: 1573Ratio Information:574# of log blocks measured: 363085575# of data blocks measured: 19233576# of change vectors measured: 1132496577 578 579 580 581***************************************************************************582STANDBY DATABASE MAP RECORDS583***************************************************************************584 (size = 400, compat size = 400, section max = 31, section in-use = 31,585 last-recid= 0, old-recno = 0, last-recno = 0)586 (extent = 1, blkno = 163, numrecs = 31)587 588 589 590 591***************************************************************************592RESTORE POINT RECORDS593***************************************************************************594 (size = 212, compat size = 212, section max = 2048, section in-use = 0,595 last-recid= 0, old-recno = 0, last-recno = 0)596 (extent = 1, blkno = 164, numrecs = 2048)597 598 599 600 601***************************************************************************602ACM SERVICE RECORDS603***************************************************************************604 (size = 104, compat size = 104, section max = 64, section in-use = 6,605 last-recid= 0, old-recno = 0, last-recno = 0)606 (extent = 1, blkno = 259, numrecs = 64)607ACM record=1608 id=0609 descrip=ACM unit testing operation610 attr=1611 ver=0612 exptime=0613 cpid=0614 cinst=0615 phase=1616ACM record=2617 id=1618 descrip=LSB Database Guard619 attr=1620 ver=0621 exptime=0622 cpid=0623 cinst=0624 phase=1625ACM record=3626 id=2627 descrip=Supplemental Log Data DDL628 attr=1629 ver=0630 exptime=0631 cpid=0632 cinst=0633 phase=1634ACM record=4635 id=3636 descrip=LSB Role Change Support637 attr=1638 ver=0639 exptime=0640 cpid=0641 cinst=0642 phase=1643ACM record=5644 id=4645 descrip=RFS block and kill across RAC646 attr=1647 ver=0648 exptime=0649 cpid=0650 cinst=0651 phase=1652ACM record=6653 id=5654 descrip=RAC-wide SGA655 attr=1656 ver=0657 exptime=0658 cpid=0659 cinst=0660 phase=1661 662 663 664 665***************************************************************************666LOG FILE HISTORY RECORDS667***************************************************************************668 (size = 56, compat size = 56, section max = 292, section in-use = 3,669 last-recid= 3, old-recno = 1, last-recno = 3)670 (extent = 1, blkno = 95, numrecs = 292)671Earliest record:672 RECID #1 Recno 1 Record timestamp 08/27/24 17:16:37 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2673 Low scn: 0x0000.000e2006 08/27/24 17:16:09 Next scn: 0x0000.000e2dce674Latest record:675 RECID #3 Recno 3 Record timestamp 08/27/24 17:23:19 Thread=1 Seq#=3 Link-Recid=2 kccic-Recid=2676 Low scn: 0x0000.000ea696 08/27/24 17:17:19 Next scn: 0x0000.000f022b677 RECID #2 Recno 2 Record timestamp 08/27/24 17:17:19 Thread=1 Seq#=2 Link-Recid=1 kccic-Recid=2678 Low scn: 0x0000.000e2dce 08/27/24 17:16:37 Next scn: 0x0000.000ea696679 RECID #1 Recno 1 Record timestamp 08/27/24 17:16:37 Thread=1 Seq#=1 Link-Recid=0 kccic-Recid=2680 Low scn: 0x0000.000e2006 08/27/24 17:16:09 Next scn: 0x0000.000e2dce681 682 683 684 685***************************************************************************686OFFLINE RANGE RECORDS687***************************************************************************688 (size = 200, compat size = 200, section max = 163, section in-use = 0,689 last-recid= 0, old-recno = 0, last-recno = 0)690 (extent = 1, blkno = 96, numrecs = 163)691 692 693 694 695***************************************************************************696ARCHIVED LOG RECORDS697***************************************************************************698 (size = 584, compat size = 584, section max = 28, section in-use = 1,699 last-recid= 1, old-recno = 1, last-recno = 1)700 (extent = 1, blkno = 98, numrecs = 28)701Earliest record:702 RECID #1 Recno 1 Record timestamp 08/27/24 17:23:19 Thread=1 Seq#=3703 Flags: <produced by archive operation> <created by the ARCH process>704 Resetlogs scn and time scn: 0x0000.000e2006 08/27/24 17:16:09705 filename /oradata/archivelog/1_3_1178126169.dbf706 Low scn: 0x0000.000ea696 08/27/24 17:17:19 Next scn: 0x0000.000f022b 08/27/24 17:23:19707 Block count=18502 Blocksize=512708Latest record:709 RECID #1 Recno 1 Record timestamp 08/27/24 17:23:19 Thread=1 Seq#=3710 Flags: <produced by archive operation> <created by the ARCH process>711 Resetlogs scn and time scn: 0x0000.000e2006 08/27/24 17:16:09712 filename /oradata/archivelog/1_3_1178126169.dbf713 Low scn: 0x0000.000ea696 08/27/24 17:17:19 Next scn: 0x0000.000f022b 08/27/24 17:23:19714 Block count=18502 Blocksize=512715 716 717 718 719***************************************************************************720FOREIGN ARCHIVED LOG RECORDS721***************************************************************************722 (size = 604, compat size = 604, section max = 1002, section in-use = 0,723 last-recid= 0, old-recno = 0, last-recno = 0)724 (extent = 1, blkno = 260, numrecs = 1002)725 726 727 728 729***************************************************************************730BACKUP SET RECORDS731***************************************************************************732 (size = 40, compat size = 40, section max = 409, section in-use = 0,733 last-recid= 0, old-recno = 0, last-recno = 0)734 (extent = 1, blkno = 99, numrecs = 409)735 736 737 738 739***************************************************************************740BACKUP PIECE RECORDS741***************************************************************************742 (size = 736, compat size = 736, section max = 200, section in-use = 0,743 last-recid= 0, old-recno = 0, last-recno = 0)744 (extent = 1, blkno = 100, numrecs = 200)745 746 747 748 749***************************************************************************750BACKUP DATAFILE RECORDS751***************************************************************************752 (size = 200, compat size = 200, section max = 245, section in-use = 0,753 last-recid= 0, old-recno = 0, last-recno = 0)754 (extent = 1, blkno = 109, numrecs = 245)755 756 757 758 759***************************************************************************760BACKUP LOG RECORDS761***************************************************************************762 (size = 76, compat size = 76, section max = 215, section in-use = 0,763 last-recid= 0, old-recno = 0, last-recno = 0)764 (extent = 1, blkno = 112, numrecs = 215)765 766 767 768 769***************************************************************************770DATAFILE COPY RECORDS771***************************************************************************772 (size = 736, compat size = 736, section max = 200, section in-use = 0,773 last-recid= 0, old-recno = 0, last-recno = 0)774 (extent = 1, blkno = 113, numrecs = 200)775 776 777 778 779***************************************************************************780BACKUP DATAFILE CORRUPTION RECORDS781***************************************************************************782 (size = 44, compat size = 44, section max = 371, section in-use = 0,783 last-recid= 0, old-recno = 0, last-recno = 0)784 (extent = 1, blkno = 122, numrecs = 371)785 786 787 788 789***************************************************************************790DATAFILE COPY CORRUPTION RECORDS791***************************************************************************792 (size = 40, compat size = 40, section max = 409, section in-use = 0,793 last-recid= 0, old-recno = 0, last-recno = 0)794 (extent = 1, blkno = 123, numrecs = 409)795 796 797 798 799***************************************************************************800DELETION RECORDS801***************************************************************************802 (size = 20, compat size = 20, section max = 818, section in-use = 0,803 last-recid= 0, old-recno = 0, last-recno = 0)804 (extent = 1, blkno = 124, numrecs = 818)805 806 807 808 809***************************************************************************810PROXY COPY RECORDS811***************************************************************************812 (size = 928, compat size = 928, section max = 246, section in-use = 0,813 last-recid= 0, old-recno = 0, last-recno = 0)814 (extent = 1, blkno = 125, numrecs = 246)815 816 817 818 819***************************************************************************820INCARNATION RECORDS821***************************************************************************822 (size = 56, compat size = 56, section max = 292, section in-use = 2,823 last-recid= 2, old-recno = 1, last-recno = 2)824 (extent = 1, blkno = 141, numrecs = 292)825Earliest record:826 RECID #1 Recno 1 Record timestamp 827 Resetlogs scn and time scn: 0x0000.00000001 08/24/13 11:37:30828 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00829 Incarnation (parent inc#, flag)=(0, 0)830Latest record:831 RECID #2 Recno 2 Record timestamp 832 Resetlogs scn and time scn: 0x0000.000e2006 08/27/24 17:16:09833 Previous Resetlogs scn and time scn: 0x0000.00000001 08/24/13 11:37:30834 Incarnation (parent inc#, flag)=(1, 2)835 RECID #1 Recno 1 Record timestamp 836 Resetlogs scn and time scn: 0x0000.00000001 08/24/13 11:37:30837 Previous Resetlogs scn and time scn: 0x0000.00000000 01/01/88 00:00:00838 Incarnation (parent inc#, flag)=(0, 0)839 840 841 842 843***************************************************************************844RMAN STATUS RECORDS845***************************************************************************846 (size = 116, compat size = 116, section max = 141, section in-use = 3,847 last-recid= 3, old-recno = 1, last-recno = 3)848 (extent = 1, blkno = 158, numrecs = 141)849Earliest record:850 RECID #1 Recno 1 851 Internal Status: 34852 External Status: 2853 Command id: 2024-08-28T02:00:02854 Operation: RMAN855 Start and End time 08/28/24 02:00:03 08/28/24 02:00:04856Latest record:857 RECID #3 Recno 3 858 Internal Status: 34859 External Status: 2860 Command id: 2024-08-28T02:00:02861 Operation: delete862 Start and End time 08/28/24 02:00:03 08/28/24 02:00:03863 RECID #2 Recno 2 864 Internal Status: 34865 External Status: 2866 Command id: 2024-08-28T02:00:02867 Operation: delete868 Start and End time 08/28/24 02:00:03 08/28/24 02:00:03869 RECID #1 Recno 1 870 Internal Status: 34871 External Status: 2872 Command id: 2024-08-28T02:00:02873 Operation: RMAN874 Start and End time 08/28/24 02:00:03 08/28/24 02:00:04875 876 877 878 879***************************************************************************880DATAFILE HISTORY RECORDS881***************************************************************************882 (size = 568, compat size = 568, section max = 57, section in-use = 0,883 last-recid= 0, old-recno = 0, last-recno = 0)884 (extent = 1, blkno = 161, numrecs = 57)885 886 887 888 889***************************************************************************890NORMAL RESTORE POINT RECORDS891***************************************************************************892 (size = 212, compat size = 212, section max = 2083, section in-use = 0,893 last-recid= 0, old-recno = 0, last-recno = 0)894 (extent = 1, blkno = 191, numrecs = 2083)895 896 897 898 899***************************************************************************900DATABASE BLOCK CORRUPTION RECORDS901***************************************************************************902 (size = 80, compat size = 80, section max = 8384, section in-use = 0,903 last-recid= 0, old-recno = 0, last-recno = 0)904 (extent = 1, blkno = 218, numrecs = 8384)905*** END OF DUMP ***以上记录的信息可以使用视图 v$controlfile_record_section 查看 record 记录的组成部分：
1SQL> SELECT type, record_size, records_total, records_used FROM v$controlfile_record_section;23TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED4---------------------------- ----------- ------------- ------------5DATABASE 316 1 16CKPT PROGRESS 8180 11 07REDO THREAD 256 8 18REDO LOG 72 16 89DATAFILE 520 100 410FILENAME 524 2298 1311TABLESPACE 68 100 512TEMPORARY FILENAME 56 100 113RMAN CONFIGURATION 1108 50 014LOG HISTORY 56 292 315OFFLINE RANGE 200 163 016ARCHIVED LOG 584 28 117BACKUP SET 40 409 018BACKUP PIECE 736 200 019BACKUP DATAFILE 200 245 020BACKUP REDOLOG 76 215 021DATAFILE COPY 736 200 022BACKUP CORRUPTION 44 371 023COPY CORRUPTION 40 409 024DELETED OBJECT 20 818 025PROXY COPY 928 246 026BACKUP SPFILE 124 131 027DATABASE INCARNATION 56 292 228FLASHBACK LOG 84 2048 029RECOVERY DESTINATION 180 1 130INSTANCE SPACE RESERVATION 28 1055 131REMOVABLE RECOVERY FILES 32 1000 032RMAN STATUS 116 141 033THREAD INSTANCE NAME MAPPING 80 8 834MTTR 100 8 135DATAFILE HISTORY 568 57 036STANDBY DATABASE MATRIX 400 31 3137GUARANTEED RESTORE POINT 212 2048 038RESTORE POINT 212 2083 039DATABASE BLOCK CORRUPTION 80 8384 040ACM OPERATION 104 64 641FOREIGN ARCHIVED LOG 604 1002 0424337 rows selected.这种方式比较适合阅读，通常可用于重建控制文件恢复数据库，也可以看到控制文件中包含了以下内容：
将控制文件备份到 trace 文件（前提是需要打开数据库），查看控制文件内容：
1-- 前提是需要打开数据库才能使用这个命令，这里不是为了恢复，只要为了方便查看内容，所以开库后获取即可2SQL> alter database backup controlfile to trace as '/home/oracle/control.txt';34Database altered.56-- 查看控制文件内容7SQL> > ! cat /home/oracle/control.txt 8-- The following are current System-scope REDO Log Archival related9-- parameters and can be included in the database initialization file.10--11-- LOG_ARCHIVE_DEST=''12-- LOG_ARCHIVE_DUPLEX_DEST=''13--14-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf15--16-- DB_UNIQUE_NAME="lucifer"17--18-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE, NODG_CONFIG'19-- LOG_ARCHIVE_MAX_PROCESSES=420-- STANDBY_FILE_MANAGEMENT=MANUAL21-- STANDBY_ARCHIVE_DEST=?/dbs/arch22-- FAL_CLIENT=''23-- FAL_SERVER=''24--25-- LOG_ARCHIVE_DEST_1='LOCATION=/oradata/archivelog'26-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'27-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'28-- LOG_ARCHIVE_DEST_1='REGISTER NOALTERNATE NODEPENDENCY'29-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED NODB_UNIQUE_NAME'30-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'31-- LOG_ARCHIVE_DEST_STATE_1=ENABLE3233--34-- Below are two sets of SQL statements, each of which creates a new35-- control file and uses it to open the database. The first set opens36-- the database with the NORESETLOGS option and should be used only if37-- the current versions of all online logs are available. The second38-- set opens the database with the RESETLOGS option and should be used39-- if online logs are unavailable.40-- The appropriate set of statements can be copied from the trace into41-- a script file, edited as necessary, and executed when there is a42-- need to re-create the control file.43--44-- Set #1. NORESETLOGS case45--46-- The following commands will create a new control file and use it47-- to open the database.48-- Data used by Recovery Manager will be lost.49-- Additional logs may be required for media recovery of offline50-- Use this only if the current versions of all online logs are51-- available.5253-- After mounting the created controlfile, the following SQL54-- statement will place the database in the appropriate55-- protection mode:56-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE5758STARTUP NOMOUNT59CREATE CONTROLFILE REUSE DATABASE "LUCIFER" NORESETLOGS ARCHIVELOG60 MAXLOGFILES 1661 MAXLOGMEMBERS 362 MAXDATAFILES 10063 MAXINSTANCES 864 MAXLOGHISTORY 29265LOGFILE66 GROUP 1 '/oradata/lucifer/redo01.log' SIZE 100M BLOCKSIZE 512,67 GROUP 2 '/oradata/lucifer/redo02.log' SIZE 100M BLOCKSIZE 512,68 GROUP 3 '/oradata/lucifer/redo03.log' SIZE 100M BLOCKSIZE 512,69 GROUP 4 '/oradata/lucifer/redo04.log' SIZE 100M BLOCKSIZE 512,70 GROUP 5 '/oradata/lucifer/redo05.log' SIZE 100M BLOCKSIZE 512,71 GROUP 6 '/oradata/lucifer/redo06.log' SIZE 100M BLOCKSIZE 512,72 GROUP 7 '/oradata/lucifer/redo07.log' SIZE 100M BLOCKSIZE 512,73 GROUP 8 '/oradata/lucifer/redo08.log' SIZE 100M BLOCKSIZE 51274-- STANDBY LOGFILE75DATAFILE76 '/oradata/lucifer/system01.dbf',77 '/oradata/lucifer/sysaux01.dbf',78 '/oradata/lucifer/undotbs01.dbf',79 '/oradata/lucifer/users01.dbf'80CHARACTER SET AL32UTF881;8283-- Commands to re-create incarnation table84-- Below log names MUST be changed to existing filenames on85-- disk. Any one log file from each branch can be used to86-- re-create incarnation records.87-- ALTER DATABASE REGISTER LOGFILE '/oradata/archivelog/1_1_824297850.dbf';88-- ALTER DATABASE REGISTER LOGFILE '/oradata/archivelog/1_1_1178126169.dbf';89-- Recovery is required if any of the datafiles are restored backups,90-- or if the last shutdown was not normal or immediate.91RECOVER DATABASE9293-- All logs need archiving and a log switch is needed.94ALTER SYSTEM ARCHIVE LOG ALL;9596-- Database can now be opened normally.97ALTER DATABASE OPEN;9899-- Commands to add tempfiles to temporary tablespaces.100-- Online tempfiles have complete space information.101-- Other tempfiles may require adjustment.102ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/lucifer/temp01.dbf'103 SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;104-- End of tempfile additions.105--106-- Set #2. RESETLOGS case107--108-- The following commands will create a new control file and use it109-- to open the database.110-- Data used by Recovery Manager will be lost.111-- The contents of online logs will be lost and all backups will112-- be invalidated. Use this only if online logs are damaged.113114-- After mounting the created controlfile, the following SQL115-- statement will place the database in the appropriate116-- protection mode:117-- ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE118119STARTUP NOMOUNT120CREATE CONTROLFILE REUSE DATABASE "LUCIFER" RESETLOGS ARCHIVELOG121 MAXLOGFILES 16122 MAXLOGMEMBERS 3123 MAXDATAFILES 100124 MAXINSTANCES 8125 MAXLOGHISTORY 292126LOGFILE127 GROUP 1 '/oradata/lucifer/redo01.log' SIZE 100M BLOCKSIZE 512,128 GROUP 2 '/oradata/lucifer/redo02.log' SIZE 100M BLOCKSIZE 512,129 GROUP 3 '/oradata/lucifer/redo03.log' SIZE 100M BLOCKSIZE 512,130 GROUP 4 '/oradata/lucifer/redo04.log' SIZE 100M BLOCKSIZE 512,131 GROUP 5 '/oradata/lucifer/redo05.log' SIZE 100M BLOCKSIZE 512,132 GROUP 6 '/oradata/lucifer/redo06.log' SIZE 100M BLOCKSIZE 512,133 GROUP 7 '/oradata/lucifer/redo07.log' SIZE 100M BLOCKSIZE 512,134 GROUP 8 '/oradata/lucifer/redo08.log' SIZE 100M BLOCKSIZE 512135-- STANDBY LOGFILE136DATAFILE137 '/oradata/lucifer/system01.dbf',138 '/oradata/lucifer/sysaux01.dbf',139 '/oradata/lucifer/undotbs01.dbf',140 '/oradata/lucifer/users01.dbf'141CHARACTER SET AL32UTF8142;143144-- Commands to re-create incarnation table145-- Below log names MUST be changed to existing filenames on146-- disk. Any one log file from each branch can be used to147-- re-create incarnation records.148-- ALTER DATABASE REGISTER LOGFILE '/oradata/archivelog/1_1_824297850.dbf';149-- ALTER DATABASE REGISTER LOGFILE '/oradata/archivelog/1_1_1178126169.dbf';150-- Recovery is required if any of the datafiles are restored backups,151-- or if the last shutdown was not normal or immediate.152RECOVER DATABASE USING BACKUP CONTROLFILE153154-- Database can now be opened zeroing the online logs.155ALTER DATABASE OPEN RESETLOGS;156157-- Commands to add tempfiles to temporary tablespaces.158-- Online tempfiles have complete space information.159-- Other tempfiles may require adjustment.160ALTER TABLESPACE TEMP ADD TEMPFILE '/oradata/lucifer/temp01.dbf'161 SIZE 30408704 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;162-- End of tempfile additions.163--综上所述，在这个阶段只涉及到了控制文件的读写，通常可用于以下场景：
需要注意的是，相关后台进程在读取控制文件时，得知了数据文件和日志信息后，并不会去验证相关文件是否存在，这个阶段只是为了数据库打开做准备，只有在真正 open 的时候，才会去验证相关文件是否存在。
Oracle 数据库启动过程之 nomount 详解 Oracle RAC 修改系统时区避坑指南（深挖篇） Ubuntu 22.04 一键安装 Oracle 11G RAC 使用 dbops 快速部署 MySQL 数据库 Oracle RAC 启动顺序，你真的了解吗？ 达梦数据库一键安装脚本（免费）一篇文章让你彻底掌握 Python 🔥
一篇文章让你彻底掌握 Python 一篇文章让你彻底掌握 Shell 🔥
Oracle 监控 EMCC 13.5 安装部署超详细教程 🔥
Oracle 一键巡检自动生成 Word 报告 🔥
Oracle一键安装脚本的 21 个疑问与解答 🔥
Oracle一键巡检脚本的 21 个疑问与解答 🔥
全网首发：Oracle 23ai 一键安装脚本 🔥
Oracle 19C 最新 RU 补丁 19.24 ，一键安装！ 🔥
Oracle Linux 6 一键安装 Oracle 11GR2 RAC
Oracle Linux 7.9 一键安装 Oracle 19C
Oracle Linux 8.9 一键安装 Oracle 19C RAC
Oracle Linux 9.4(aarch64) 一键安装 Oracle 19C 🔥
openEuler 20.03 LTS SP4 一键安装 Oracle 19C 🔥
openEuler 22.03 LTS SP4 一键安装 Oracle 19C RAC
RHEL 7.9 一键安装 Oracle 19C 19.23 RAC
Redhat 8.4 一键安装 Oracle 11GR2
RedHat 9.4(aarch64) 一键安装 Oracle 19C
龙蜥 Anolis 7.9 一键安装 Oracle 19C 19.23
龙蜥 Anolis OS 8.8 一键安装 Oracle 19C
SUSE 15 SP5 一键安装 Oracle 19C
统信 UOS V20 1070(a) 一键安装 Oracle 11GR2
Ubuntu 22.04 一键安装 Oracle 19C
Ubuntu 14.04 一键安装 Oracle 19C
银河麒麟 Kylin V10 SP3 一键安装 Oracle 19C 🔥
银河麒麟 Kylin V10 SP3 一键安装 Oracle 11GR2 RAC
Oracle DataGuard GAP 修复手册 🔥
优化 Oracle：最佳实践与开发规范
DBA 必备：Linux 软件源配置全攻略 🔥
Linux 一键配置时钟同步全攻略 🔥
Starwind 配置 ISCSI 共享存储
SUSE 15 SP3 安装 Oracle 19C RAC 数据库
达梦 8 数据库安装手册 🔥
Oracle 12CR2 RAC 安装避坑宝典
Linux7 安装 Oracle 19C RAC 详细图文教程 🔥
Oracle ADG 搭建 RAC to Single 详细教程
Oracle DataGuard GAP 修复手册 🔥
Oracle 分区表之在线重定义
AutoUpgrade 快速升级 Oracle 数据库
Oracle 数据库巡检命令手册 🔥
Oracle 数据坏块的 N 种修复方式 🔥
数据库 SQL 开发入门教程
超全 Linux 基础命令总结 🔥
VMware 虚拟机安装 Linux 系统
Linux 安装 MySQL 详细教程
教你玩转 SQLPLUS，工作效率提升 200%
感谢您的阅读，这里是 Lucifer三思而后行，欢迎 点赞+关注，我会持续分享数据库知识、运维技巧。