Re: Need a lesson in RMAN for RAC

Do you have another Incarnation on 29th of 30th of Augost? You log sequence is reset.

If so run LIST INCARNATION OF DATABASE and see if you are using the current otherwise try use reset database to incarnation to current incarnation...

Thanks

--
LSC






On 9/7/07, Charles Schultz <sacrophyte_at_gmail.com> wrote:


>

> While trying to restore a RAC database, I had a perplexing problem. OSEE

> 10.2.0.3 all around

> rman> run {

> set until time "to_date('29-AUG-2007 17:51:55','DD-MON-YYYY HH24:MI:SS')";

>

> restore database;

> recover database;

> }

>

> ...

> starting media recovery

>

> archive log thread 1 sequence 38 is already on disk as file

> +DATA/lumqa/1_38_629052887.dbf

> archive log thread 1 sequence 39 is already on disk as file

> +DATA/lumqa/1_39_629052887.dbf

> archive log thread 2 sequence 33 is already on disk as file

> +DATA/lumqa/2_33_629052887.dbf

> archive log filename=+DATA/lumqa/1_38_629052887.dbf thread=1 sequence=38

> archive log filename=+DATA/lumqa/2_2_629052887.dbf thread=2 sequence=2

> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error

> below

> ORA-01152: file 1 was not restored from a sufficiently old backup

> ORA-01110: data file 1: '+DATA/lumqa/datafile/system.314.629052819'

>

> RMAN-00571: ===========================================================

> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

> RMAN-00571: ===========================================================

> RMAN-03002: failure of recover command at 09/07/2007 13:21:23

> RMAN-11003: failure during parse/execution of SQL statement: alter

> database recover logfile '+DATA/lumqa/2_2_629052887.dbf'

> ORA-00328: archived log ends at change 679438, need later change 3331515

> ORA-00334: archived log: '+DATA/lumqa/2_2_629052887.dbf'

>

> The confusing part is that this log is really old, and I have no idea how

> it is relevant or needed for this recovery:

>   1  select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY

> HH24:MI:SS'),

>   2   NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY HH24:MI:SS')

>   3  from v$archived_log

>   4* where name like '%2_2_629052887%'

> LUMQA1_SQL > /

>

> NAME                                     FIRST_CHANGE#

> TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D

> ---------------------------------------- -------------

> -------------------- ------------ --------------------

> +DATA/lumqa/2_2_629052887.dbf                   589921 27-JUL-2007

> 17:38:36       679439 28-JUL-2007 16:59:26

>

> Here are the other logs:

> LUMQA1_SQL >  select * from

>   2   (select NAME,FIRST_CHANGE#,to_char(FIRST_TIME,'DD-MON-YYYY

> HH24:MI:SS'),

>   3                NEXT_CHANGE#,to_char(NEXT_TIME,'DD-MON-YYYY

> HH24:MI:SS')

>   4     from v$archived_log

>   5     where next_time is not null

>   6     and first_time < '01-SEP-2007'

>   7     order by NEXT_TIME desc)

>   8*  where rownum < 11

> LUMQA1_SQL > /

>

> NAME                                     FIRST_CHANGE#

> TO_CHAR(FIRST_TIME,' NEXT_CHANGE# TO_CHAR(NEXT_TIME,'D

> ---------------------------------------- -------------

> -------------------- ------------ --------------------

> +DATA/lumqa/2_3_631971295.dbf                  2997861 31-AUG-2007

> 22:00:10      3097750 02-SEP-2007 02:01:44

> +DATA/lumqa/1_4_631971295.dbf                  3004658 31-AUG-2007

> 22:11:27      3051322 01-SEP-2007 09:00:40

> +DATA/lumqa/1_3_631971295.dbf                  2876764 30-AUG-2007

> 12:09:54      3004658 31-AUG-2007 22:11:27

> +DATA/lumqa/2_2_631971295.dbf                  2877457 30-AUG-2007

> 12:09:56      2997861 31-AUG-2007 22:00:10

> +DATA/lumqa/2_34_629052887.dbf                 3331608 29-AUG-2007

> 17:51:55      3331784 29-AUG-2007 17:53:38

> +DATA/lumqa/1_39_629052887.dbf                 3331605 29-AUG-2007

> 17:51:53      3331781 29-AUG-2007 17:53:37

> +DATA/lumqa/2_33_629052887.dbf                 3245386 28-AUG-2007

> 18:07:51      3331608 29-AUG-2007 17:51:55

> +DATA/lumqa/1_38_629052887.dbf                 3258246 28-AUG-2007

> 21:08:10      3331605 29-AUG-2007 17:51:53

> +DATA/lumqa/1_37_629052887.dbf                 3168436 27-AUG-2007

> 22:00:35      3258246 28-AUG-2007 21:08:10

> +DATA/lumqa/2_32_629052887.dbf                 3146903 27-AUG-2007

> 17:55:54      3245386 28-AUG-2007 18:07:51

>

> --

> Charles Schultz


--
http://www.freelists.org/webpage/oracle-l