Re: Regarding next_change#

From: joel garry <joel-garry_at_home.com>
Date: Wed, 30 Sep 2009 09:26:30 -0700 (PDT)
Message-ID: <5ff0442a-11a8-47a7-bf2a-25b8354ac047_at_x6g2000prc.googlegroups.com>

On Sep 30, 7:02 am, Ganesh <ganesh.tam..._at_gmail.com> wrote:
> 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

Could your backups be out of sync with your controlfile? Could your archiving be before the checkpoint? Could there be multiple threads? See http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmanreco.htm#445037 and not-a-bug 2311608

jg

--
_at_home.com is bogus.
http://news.slashdot.org/story/09/09/30/0152200/Amazons-Cloud-May-Provision-50000-VMs-a-Day

Received on Wed Sep 30 2009 - 11:26:30 CDT