Regarding next_change#

From: Ganesh <ganesh.tambat_at_gmail.com>
Date: Wed, 30 Sep 2009 07:02:38 -0700 (PDT)
Message-ID: <a4eae5c3-a9fc-492f-9234-7c1ee1c4826e_at_y28g2000prd.googlegroups.com>

I am using 8i. I would like to know how exactly the next_change# is updated. On my Oracle server the "list backup" command returns following:

---

RMAN> list backup;

RMAN-03022: compiling command: list

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time ------- ---------- ---------- -- ---------- ----------

---

1 1 698720723 0 698720644 1 28-SEP-09     List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name

• --- --- ----------- ----------------------

  ---

  1 1 1 AVAILABLE 28-SEP-09 BE_01kqb8c4_1_1

    List of Datafiles Included

    File Name                                  LV Type Ckp SCN    Ckp

Time

• ------------------------------------- -- ---- ----------

  ---

  1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362797 28- SEP-09 2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362797 28- SEP-09 3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362797 28- SEP-09 4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362797 28- SEP-09 5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362797 28- SEP-09 6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362797 28- SEP-09 7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362797 28- SEP-09 8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362797 28- SEP-09

List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time ------- ---------- ---------- -- ---------- ----------

---

4 4 698939872 0 698939794 5 30-SEP-09     List of Backup Pieces
    Key Pc# Cp# Status Completion Time Piece Name

• --- --- ----------- ----------------------

  ---

  4 1 1 AVAILABLE 30-SEP-09 BE_05kqhuci_1_1

    List of Datafiles Included

    File Name                                  LV Type Ckp SCN    Ckp

Time

• ------------------------------------- -- ---- ----------

  ---

  1 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF 0 Full 362846 30- SEP-09 2 C:\ORACLE\ORADATA\ORCL\RBS01.DBF 0 Full 362846 30- SEP-09 3 C:\ORACLE\ORADATA\ORCL\USERS01.DBF 0 Full 362846 30- SEP-09 4 C:\ORACLE\ORADATA\ORCL\TEMP01.DBF 0 Full 362846 30- SEP-09 5 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF 0 Full 362846 30- SEP-09 6 C:\ORACLE\ORADATA\ORCL\INDX01.DBF 0 Full 362846 30- SEP-09 7 C:\ORACLE\ORADATA\ORCL\DR01.DBF 0 Full 362846 30- SEP-09 8 C:\ORACLE\ORADATA\ORCL\TEST01.DBF 0 Full 362846 30- SEP-09

  ---

But I get following output for query to get max(next_change#)

SQL> select max(next_change#) from v$archived_log;

MAX(NEXT_CHANGE#)

---

           362799

I am expecting a value near to 362846 to get displayed as output to this query. (But the value displayed is nearer to SCN for earlier backup) I am not able to understand why the next_change# is not getting updated. Please let me know whether I am missing something here.

Thanks in advance,
Ganesh Tambat Received on Wed Sep 30 2009 - 09:02:38 CDT