OCP考题解析_043：Oracle RECID和SEQUENCE#的区别及RESETLOGS操作

sys@ORCL> 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