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