RE: Need a lesson in RMAN for RAC

Yes that is an incarnation number.

One thing we have had fun with is RMAN having difficulty with reading files back from a certain piece of tape management software that causes RMAN to decide that it cant get that file, so therefore goes back to another good backup it knows about. Only problem is because of tape management software issues, it just keeps going back and back and then takes forever to get reliable files as well as then having to do the same with archive logs to roll forward with I got really painful for us duplicating databases for the project so we now do a quick backup to some available space and the duplicate from it.

I suspect that you have experienced the same and RMAN was intending to restore forward to the other files. It just didn't see the reset logs in the middle.

I guess with the ability to recatalog you might have to invalidate old backups prior to the reset logs and then it wont know about those. You can recatalog them at a later date to allow restores from the older incarnations.

Cheers

Peter

-----Original Message-----
From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg] Sent: Monday, 10 September 2007 12:56 PM To: sacrophyte_at_gmail.com; oracle-l
Subject: Re: Need a lesson in RMAN for RAC

1. Could there have been an ALTER TABLESPACE BEGIN BACKUP command in the past ?, the file never having been taken out of backup mode ?
2. Check the alert log to confirm that it doesn't see any "fuzzy" datafiles when doing the recovery.
3. What are the timestamps and SCNs of the Archivelogs between 2_2 and 2_33 ?
4. I haven't used ASM and OMF but what is the "629052819" in "system.314.629052819". Is that an incarnation id ? different from "629052887" ? meaning that the system file has been restored from an older, pre-reset log image ?

Hemant

At 02:42 AM Saturday, Charles Schultz wrote:
>While trying to restore a RAC database, I had a perplexing problem.
>OSEE <http://10.2.0.3>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'
>

Hemant K Chitale
http://hemantoracledba.blogspot.com

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

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


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