数据库启动scn cnt

最新推荐文章于 2024-10-25 19:36:52 发布

Rhys-Oracle

最新推荐文章于 2024-10-25 19:36:52 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： ORACLE 之启动过程

本文链接：https://blog.youkuaiyun.com/rhys_oracle/article/details/8982067

ORACLE 之启动过程专栏收录该内容

8 篇文章

订阅专栏

数据库启动scn cnt

1)nomal
DATA FILE #1: 
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:631 scn: 0x0000.00470a57(4655703) 05/27/2013 21:24:01
 Stop scn: 0xffff.ffffffff 05/26/2013 21:23:48
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)
2)begin_backup
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:632 scn: 0x0000.00470b09(4655881) 05/27/2013 21:29:29
 Stop scn: 0xffff.ffffffff 05/26/2013 21:23:48
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)
3)backup_checkpoint
DATA FILE #1: 
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:633 scn: 0x0000.00470b09(4655881) 05/27/2013 21:29:29
 Stop scn: 0xffff.ffffffff 05/26/2013 21:23:48
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)

4)end_backup_trace
DATA FILE #1: 
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:634 scn: 0x0000.00470b3f(4655935) 05/27/2013 21:30:52
 Stop scn: 0xffff.ffffffff 05/26/2013 21:23:48
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$mount$$$$$$$$$$$$$$$$$$$$$$$$
1)controlfile
 DB Name "ORCL"
 Database flags = 0x00404001 0x00001200
 Controlfile Creation Timestamp  03/30/2012 02:42:30
 Incmplt recovery scn: 0x0000.00000000
 Resetlogs scn: 0x0000.002b740c Resetlogs Timestamp  03/21/2013 20:42:46
 Prior resetlogs scn: 0x0000.002b6c75 Prior resetlogs Timestamp  03/21/2013 12:19:32
 Redo Version: compatible=0xb100000
 #Data files = 12, #Online files = 12
 Database checkpoint: Thread=1 scn: 0x0000.00470ed2
 Threads: #Enabled=1, #Open=0, Head=0, Tail=0
DATA FILE #1: 
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:635 scn: 0x0000.00470ed2 05/27/2013 21:47:41
 Stop scn: 0x0000.00470ed2 05/27/2013 21:47:41
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)
2)file_heard
DATA FILE #1: 
  (name #10) /opt/oracle/oradata/ORCL/datafile/o1_mf_system_8no75lqw_.dbf
creation size=0 block size=8192 status=0xe head=10 tail=10 dup=1
 tablespace 0, index=1 krfil=1 prev_file=0
 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00
 Checkpoint cnt:635 scn: 0x0000.00470ed2 05/27/2013 21:47:41
 Stop scn: 0x0000.00470ed2 05/27/2013 21:47:41
 Creation Checkpointed at scn:  0x0000.00000007 10/14/2007 15:02:55
 thread:0 rba:(0x0.0.0)