You could make an incremental backup of primary database and apply it to the dataguard. 0 Message Author Comment by:Omega0022010-03-22 Comment Utility Permalink(# a28232747) I just completed a incremental backup. Posted on 2010-03-22 Oracle Database 12 1 solution 2,877 Views Last Modified: 2013-12-18 Greetings, I am getting the following error due to a missing archive log file that was deleted. When the recovery process suggests the non-existent archive log, you need to provide the path to the current online redo log. Reddy,Sam Reply With Quote 08-08-2002,06:26 PM #5 ashley75 View Profile View Forum Posts Senior Member Join Date Jan 2002 Posts 474 my database went down around 4:00 pm and I issue weblink
You should always run a production database in archivelog mode:http://www.dba-oracle.com/oracle_tips_arch...de_recovery.htm****************************>> ORA-00600: internal error code, arguments: [kewrsp_split_partition_2], , , , , , , , , , , ALL ORA-0600 ERRORS MUST BE Your scenario is covered in this specific topic (Using RMAN Incremental Backups to Roll Forward a Physical Standby Database): http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIAADC Following these steps it's the best way to solve your problem. Then why error is occurring at node1, primary database? Re: ORA-00308: cannot open archived log '+DATA' ElMasry Mar 6, 2015 1:08 PM (in response to 12cdb) But now when I run show parameter LOG_ARCHIVE_DEST_STATE_2; from any node I find it
Report message to a moderator Re: ORA-00308: cannot open archived log [message #626083 is a reply to message #626081] Mon, 20 October 2014 08:23 John Watson Messages: 6513Registered: Use the RMAN command CATALOG RECOVERY AREA to re-catalog any such files. Re: ORA-00308: cannot open archived log '+DATA' 12cdb Mar 6, 2015 12:30 PM (in response to ElMasry) did you run this command ; ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SID='*' ; Like Show
That is my major concern. Join our community for more solutions or to ask questions. No trackbacks yet. Ora-00308 Ora-17503 when i check by this command select INST_ID,STATUS,ERROR,GAP_STATUS from gv$archive_dest_Status where dest_id = 2; i found : INST_ID,STATUS,ERROR,GAP_STATUS 3,ERROR,ORA-01033: ORACLE initialization or shutdown in progress,RESOLVABLE GAP 2,ERROR,ORA-01033: ORACLE initialization or shutdown
Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? Ora-00308 Cannot Open Archived Log Standby Database You have made a mistake in describing the environment, you need to try again. Your error has to be coming from the instance genconf2. [Updated on: Mon, 20 October 2014 08:24]Report message to a moderator Re: ORA-00308: cannot open archived log [message If you cannot recover the archived log, you have a cool way to recover the dataguard without it.
Stecal, I am a little confused here, I do have the backup but how can I apply the archive log files up to just before the loss on online redo logs. Dblogreader Mode: (308) Ora-00308: Cannot Open Archived Log Some components may not be visible. But log shipping is successfully applying. Covered by US Patent.
Alert log of genconf1 is also attached for your reference. http://dbaforums.org/oracle/index.php?showtopic=21759 It can … Oracle Database Zero Data Reporting Database Article by: MikeOM_DBA Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from Ora-00308 Cannot Open Archived Log Ora-27037 Unable To Obtain File Status 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 Ora-00308 Ora-27037 From MetaLink: You accept the suggested archive log (by pressing Enter) and then receive the following errors: ORA-00308: cannot open archived log '%s' ORA-07260: sfifi: stat error, unable to obtain information
If you find an error or have a suggestion for improving our content, we would appreciate your feedback. have a peek at these guys The time now is 06:23 AM. newsgator Bloglines iNezha Recent Posts DBCA, running on oracle zone, pops up "Out ofMemory"ORA-00392: log 1 of thread 1 is being cleared, operation notallowedvnet: [ID 214931 kern.info] vnet0: vnet_addmac: programming macaddr(2:8:20:ad:ea:21) Re: ORA-00308: cannot open archived log '+DATA' 12cdb Mar 6, 2015 9:51 AM (in response to ElMasry) Yes, if it is RAC DB set it like ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SID='*' Ora-00308 In Noarchivelog Mode
BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference rokyj055 View Member Profile May 17 2012, 07:55 AM Post #3 Advanced Member Group: Members Posts: 75 Joined: 23-January 12 Member Ora-00308 Solution Re: ORA-00308: cannot open archived log '+DATA' 12cdb Mar 6, 2015 1:23 PM (in response to ElMasry) Standby:Use this and check on Standby whether everything coming get applied; select process, client_process, Once you have stopped the dataguard, the FAL process from the Dataguard (FAL Client) will stop requesting any missing log.
Donald K. Please help me understand your advise Thanks Reply With Quote 08-08-2002,04:24 PM #4 sreddy View Profile View Forum Posts Senior Advisor Join Date Feb 2000 Location Washington DC Posts 1,843 To That is my major concern. Ora-15045 Join Now For immediate help use Live now!
This is most likely the result of a crash during file creation. Results 1 to 8 of 8 Thread: RECOVER THE LOSS THE AN UNARCHIVED LOG Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch You can not post a blank message. this content Regards, Ashish Kumar Mahanta Report message to a moderator Re: ORA-00308: cannot open archived log [message #626078 is a reply to message #626077] Mon, 20 October 2014 07:56
Once I start recovering the standby database, the message below reported. Errata? [email protected][genconf2]:/oltp2_arch2$ ls -ld drwxrwxr-x 4 oracle oinstall 96 Sep 14 2013 . Login.
You should then be able to open the database: SVRMGR> ALTER DATABASE OPEN RESETLOGS The resetlogs option must be used to synchronize the controlfile. ORA-01450: maximum key length (3118)exceeded ORA-00054: resource busy and acquire with NOWAIT specified or timeoutexpired RSS feed Google Youdao Xian Guo Zhua Xia My Yahoo! Archiver continuing. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.
Senior MemberAccount Moderator And post the result of: id (for the account that started the instance) ls -l /oltp2_arch2/genconf/arch/log_7628d0a0_2_24792_765657634.arc ls -ld /oltp2_arch2/genconf/arch/ ls -ld /oltp2_arch2/genconf/ ls -ld /oltp2_arch2/ Report message to SQL> alter system set standby_file_management=auto; System altered. You could start the dataguard again, but once you start it to apply changes from primary, the error will come out again. How do I know which archive log is before the system crashed???