| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Need a lesson in RMAN for RAC
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)
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-lReceived on Fri Sep 07 2007 - 13:42:55 CDT
 |
 |