Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I read transactions directly from an archived log file..

julio.010101Jun 20 2007 — edited Jun 20 2007
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2007
Added on Jun 20 2007
7 comments
3,075 views