Home > Cannot Open > Recover Datafile Ora-00308 Cannot Open Archived Log

Recover Datafile Ora-00308 Cannot Open Archived Log


I set it again. This is most likely the result of a crash during file creation. Abdul Jamil February 09, 2012 at 18:27 PM 0 Likes Correct Answer Deepak Kori replied February 13, 2012 at 06:47 AM Hi Majamil,Can you try with this solutionlog_archive_format = "PRDARCHARC%s_%R.%T"Note the If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Source

Total System Global Area 57939996 bytes Fixed Size 75804 bytes Variable Size 55693312 bytes Database Buffers 1638400 bytes Redo Buffers 532480 bytes Database mounted. Would like to make this message go away. Like Show 0 Likes(0) Actions 24. can we lose both log 3 and log 1, or say as long as they are archived? https://scn.sap.com/thread/2134811

Ora-00308 Cannot Open Archived Log Ora-27037 Unable To Obtain File Status

This tool uses JavaScript and much of it will not work correctly without it enabled. I cannot find the missing archive log file. Use the RMAN command CATALOG RECOVERY AREA to re-catalog any such files. If files cannot be cataloged, then manually delete them using OS command.

Reply With Quote 08-08-2002,06:32 PM #6 marist89 View Profile View Forum Posts Visit Homepage Super-Genius Join Date Nov 2000 Location greenwich.ct.us Posts 9,092 Originally posted by ashley75 my database went down Email Subscription Join 632 other followers Search avdeo.com Search for: June 2008 M T W T F S S « May Jul » 1 2345678 9101112131415 16171819202122 23242526272829 30 Archiver continuing. Ora-00308 Ora-17503 Hope this helps !!

So it automatically search for archive log "/dy/oracle/product/db10g/archive/htmldb/ARCH_657248900_1_3.ARC". As you can see from the trace log, the FAL process (Fetch Archive Log) is requesting the missing log from the Dataguard. burleson View Member Profile May 16 2012, 12:42 PM Post #2 Advanced Member Group: Members Posts: 13,233 Joined: 26-January 04 Member No.: 13 >> ORA-00308


cannot open archived SQL> startup ORACLE instance started.

Once I start recovering the standby database, the message below reported. Ora-00308 Solution This happens when checkpoint has just started and DBWR is yet to perform its job.

But at the same time you can see that these active redo log files has been Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! SQL> recover database until cancel; ORA-00279: change 4380738 generated at 06/13/2008 02:12:35 needed for thread 1 ORA-00289: suggestion : /dy/oracle/product/db10g/archive/htmldb/ARCH_657248900_1_1.ARC ORA-00280: change 4380738 for thread 1 is in sequence #1 Specify

Ora-00308 Cannot Open Archived Log Standby Database

Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. To start viewing messages, select the forum that you want to visit from the selection below. Ora-00308 Cannot Open Archived Log Ora-27037 Unable To Obtain File Status Advanced Search Forum Oracle Forums Oracle Database Administration RECOVER THE LOSS THE AN UNARCHIVED LOG If this is your first visit, be sure to check out the FAQ by clicking the Ora-00308 Ora-27037 HTH, Pradeep Like Show 0 Likes(0) Actions 20.

To perform the duplicate with OMF and ASM, you must have the following parameters: db_file_name_convert - if appropriate db_unique_name - must be set to a name different from primary db_unique_name. this contact form Share this:Click to share on Reddit (Opens in new window)Click to email (Opens in new window)Click to print (Opens in new window)Click to share on Google+ (Opens in new window)Share on Also we are not using RMAN here, we are doing it manually. LEARN MORE Join & Write a Comment Already a member? Ora-00308 In Noarchivelog Mode

DBWR is yet to do that. Covered by US Patent. Show 24 replies 15. have a peek here Regards, Advait Deo Reply Jacky says: June 18, 2008 at 7:17 pm Thanks Advait.

Reply Leave a Reply Cancel reply Enter your comment here... Ora-15045 Brief about Workload Management in OracleRAC How many checkpoints in Oracle database? SQL>

We were able to recover here after loosing the active redo log file, because that active redo log file was archived by archiver process.

This was redo log 2.

The problem was fixed. Media recovery complete. i have raised SR for ORA 600 burleson View Member Profile May 21 2012, 10:39 AM Post #4 Advanced Member Group: Members Posts: 13,233 Joined: 26-January 04 Member No.: 13 Dblogreader Mode: (308) Ora-00308: Cannot Open Archived Log Dbhk's Blog Just another WordPress.com weblog Home About Home > Data Guard, ORA-XXX, Standby database > ORA-00308: cannot open archived log ‘+SG_DG' ORA-00308: cannot open archived log ‘+SG_DG' July 5, 2011

This archive log has not yet been created. Reply With Quote 08-08-2002,04:19 PM #3 ashley75 View Profile View Forum Posts Senior Member Join Date Jan 2002 Posts 474 Originally posted Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Then attempt to continue recovery or restart the recovery sessionPut the database in archivelog mode!>> noarchive log mode which was working fine but since from last 2 to 3 days That's Check This Out SQL> / System altered.

You need to enable it again ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;HTH, Pradeep Like Show 1 Likes(1) Actions 16. By default sequence 3 (If archived) will be in archive log file ARCH_657248900_1_3.ARC. Database opened.

2) Archive log status SQL> archive log list Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /dy/oracle/product/db10g/archive/htmldb Oldest online log sequence     0 Next log sequence to archive   Is there a way to fix this without recovery?

bash-2.05$ rm /dy/oracle/product/db10g/dbf/redo03.log 5) Shut abort bash-2.05$ sqlplus "/as sysdba" SQL*Plus: Release - Production on Fri Jun 13 02:16:22 2008 Copyright (c) 1982, 2005, Oracle.  All rights reserved. standby_file_management - must set to AUTO db_create_file_dest - must be set Finally I found that the parameter standby_file_management was not set.