Need a lesson in RMAN for RAC
- From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Sep 2007 13:42:55 -0500
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
Other related posts:
