OCP考题解析_043：Oracle RECID和SEQUENCE#的区别及RESETLOGS操作_记录创业路上的一些想法

[email protected]> select recid,sequence# from v$log_history;

     RECID  SEQUENCE#
---------- ----------
         1          1
         2          2
         3          3
         4          4
         5          5
         6          6
         7          7
         8          8
         9          9
        10         10
        11         11
        12         12
        13          1
        14          2
        15          3
        16          4
        17          1
        18          2
        19          3
        20          4
        21          5
        22          6
        23          7
        24          8
        25          9
        26         10
        27         11
        28         12
        29         13
        30         14
        31         15
        32         16
        33         17

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1316499950       PARENT  1          2005-06-30:19:09:40
2       2       ORCL     1316499950       PARENT  446075     2012-07-15:16:40:15
3       3       ORCL     1316499950       PARENT  604802     2012-08-08:10:35:10
4       4       ORCL     1316499950       CURRENT 607329     2012-08-08:11:28:40> select recid,sequence# from