Obtain different scn information from control file and datafile header, datafilescn

Obtain different scn information from control file and datafile header, datafilescn

Database checkpoint scn -- The following dump from control file:

Database checkpoint: Thread=1 scn: 0x0000.0006b6fe

Datafile checkpoint scn -- The following is the dump of control file:

Data file #4: (name #4) /u01/app/oracle/oradata/orcl/users01.dbfcreation size = 0 block size = 8192 status = 0xe head = 4 tail = 4 dup = 1 tablespace 4, index = 4 krfil = 4 prev_file = 0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt: 57 scn: 0x0000. 0006b6fe 05/14/2015 05:39:06 ---> datafile checkpoint scn: 0x0000. 0006b6fe Stop scn: 0xffff. ffffffff 05/13/2015 12:23:12 Creation Checkpointed At scn: 0x0000. 201722b3 04/20/2010 08:24:34 thread: 0 rba :( 0x0. 0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000 000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000. 0005eca8 prev_range: 0 Online Checkpointed at scn: 0x0000. 0005eca9 05/13/2015 08:13:06 thread: 1 rba :( 0x1. 2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000 000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x0000.00000000 aux_file is not defined data file #5: ---> This is another datafile.

 

Start scn -- The following dump from the datafile header:

Data file #4: (name #4) /u01/app/oracle/oradata/orcl/users01.dbfcreation size = 0 block size = 8192 status = 0xe head = 4 tail = 4 dup = 1 tablespace 4, index = 4 krfil = 4 prev_file = 0 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00 Checkpoint cnt: 57 scn: 0x0000. 0006b6fe 05/14/2015 05:39:06 ---> scn: 0x0000. 0006b6fe Stop scn: 0xffff. ffffffff 05/13/2015 12:23:12 Creation Checkpointed at scn: 0x0000.0000 22b3 04/20/2010 08:24:34 thread: 0 rba :( 0x0. 0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00 000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000000 00 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 00000000 00000000 00000000 00000000 00000000 Offline scn: 0x0000. 0005eca8 prev_range: 0 Online Checkpointed at scn: 0x0000. 0005eca9 05/13/2015 08:13:06 thread: 1 rba :( 0x1. 2.0) enabled threads: 01000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00 000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000000 00 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 Hot Backup end marker scn: 0x00000000 aux_file is not defined V10 style file header: --------------> starting from this point and going down to the second to the last line, the dump of the datafile header contains more information than the dump of the control file. Compatibility Vsn = 169870592 = 0xa200500 Db ID = 1407362313 = 0x53e2a509, Db Name = 'orcl 'Activation ID = 0 = 0x0 Control Seq = 430 = 0x1ae, file size = 640 = 0x280 File Number = 4, Blksiz = 8192, File Type = 3 ableablespace #4-USERS rel_fn: 4 Creation at scn: 0x0000. 201722b3 04/20/2010 08: 24: 34 Backup taken at scn: 0x0000.00000000 01/01/1988 00:00:00 thread: 0 reset logs count: 0x0000d5992 scn: 0x0000. 0005eca9 reset logs Terminal rcv data: 0x0 scn: 0x0000.00000000 prev reset logs count: 0x2ab99238 scn: 0x0000.00000001 prev reset logs terminal rcv data: 0x0 scn: 0x0000.00000000 recovered at 05/14/2015 05:39:03 status: 0x4 root dba: 0x00000000 chkpt cnt: 57 ctl cnt: 56begin-hot-backup file size: 0 Checkpointed at scn: 0x0000. 0006b6fe 05/14/2015 05:39:06 thread: 1 rba :( 0x9. 2.10) enabled threads: 01000000 00000000 00000000 00 000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000000 00 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0 0000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 backup Checkpointed at scn: zero x 0000.0000000 0 thread: 0 rba :( 0x0. 0.0) enabled threads: 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 0000000 0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00 000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 000000 00 00000000 00000000 00000000 External cache id: 0x0 0x0x0 0x0Absolute fuzzy scn: 0x0000. 00000000 Recovery fuzzy scn: 0x0000.00000000 01/01/1988 00: 00: 00 Terminal Recovery Stamp 01/01/1988 00: 00: 00 Platform Information: Creation Platform ID: 13 Current Platform ID: 13 Last Platform ID: 13 data file #5: ---> This is another datafile.