How can I read transactions directly from an archived log file..
Hi all,
I'm facing a pretty difficulty and curious point in time recovery, were there is one Archived log file with "header error"
###########################################
SQL> recover database until time '2007-06-12:14:40:00' using backup controlfile;
ORA-00279: change 2373149047 generated at 06/12/2007 01:16:02 needed for thread
1
ORA-00289: suggestion : /u02/oracle/oradata/ppp1/arch/arch_1_5669.arc
ORA-00280: change 2373149047 for thread 1 is in sequence #5669
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-16067: activation identifier mismatch in archive log
/u02/oracle/oradata/ppp1/arch/arch_1_5669.arc
ORA-01112: media recovery not started
###########################################
This Archived log file worked fine in other two tries to recovery.
I would like to know if there is way to read transactions directly from an archived log file, or another light please.
I also tried :
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 5654 68157440 1 YES INACTIVE
2371791604 11-JUN-07
2 1 5655 68157440 1 YES INACTIVE
2371888845 11-JUN-07
3 1 5656 68157440 1 NO CURRENT
2372710894 11-JUN-07
SQL> alter database clear logfile group 3;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 5654 68157440 1 YES INACTIVE
2371791604 11-JUN-07
2 1 5655 68157440 1 YES INACTIVE
2371888845 11-JUN-07
3 1 0 68157440 1 NO CURRENT
2372710894 11-JUN-07
##############################
It also may be a problem with the redo log file..
This is a 9.0.1 DB
I don't have flashback configured.
Thanks,
JĂșlio