restore arch for logminer
Hi!
I need to mine the log's from a period of time.
So I queried V$ARCHIVED_LOG...
select distinct sequence# from v$archived_log where FIRST_TIME BETWEEN TO_DATE('03/11/2010 15:30:32', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('03/11/2010 17:35:08', 'MM/DD/YYYY HH24:MI:SS') order by 1
With the output I crated a RMAN restore script
run {
set archivelog destination to '/tmp';
restore archivelog sequence 150860 ;
restore archivelog sequence 150861 ;
...
restore archivelog sequence 176699 ;
restore archivelog sequence 176700 ;
restore archivelog sequence 176701 ;
}
It is an RAC cluster, I think thats the reason for the gap in the sequence#.
I could restore the 150* logs but not the 176*!
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 16-03-2010
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=2014 instance=RACF2 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.3.3.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2022 instance=RACF2 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/16/2010 16:18:27
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specification does not match any archive log in the recovery catalog
Then I quried v$archived_log again and saw that e.g 150864 has dest_id 1 and 10 and 177765 has only dest_id 10.
Dest_id 10 = db_recovery_file_dest = FRA on ASM.
Why are these files only archived to FRA and not via RMAN to tape?
Any Idea how to get this files.
thanks
Daniel
Edited by: user641444 on Mar 16, 2010 9:14 AM