If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

Archival Error, no source redo log file

Dear all,

I just start to be an Oracle DBA. When I checked the alert log file this morning, I found the following error message in the alert log file. Could you please give me some clue to solve the issue? I do appreciate.

My understanding is: in my primary database, no redo log file /u05/arch/1_3907.dbf exists, so there is no way for standby database to archive the log file. Am I right? What should I do?

Re: Archival Error, no source redo log file

Originally posted by jwu1023 Dear all,

I just start to be an Oracle DBA. When I checked the alert log file this morning, I found the following error message in the alert log file. Could you please give me some clue to solve the issue? I do appreciate.

My understanding is: in my primary database, no redo log file /u05/arch/1_3907.dbf exists, so there is no way for standby database to archive the log file. Am I right? What should I do?

Another new "DBA" like me deleted all the files in dicrectory /u05/arch on the standby. So does that mean I have to create a log file with the same name? If so, could you tell me the steps of creating a log file? I do appreciate your help.

Another new "DBA" like me deleted all the files in dicrectory /u05/arch on the standby. So does that mean I have to create a log file with the same name? If so, could you tell me the steps of creating a log file? I do appreciate your help.

Jian

Well the thing is there was a gap detected in the sequence of archive logs to applied at the standby - namely among others /u05/arch/1_3904.dbf. The standby is not being kept current and will not be until you can retrieve the missing logs. If you cannot retrieve the missing logs you need to recerate the standby with a new backup from production.

Originally posted by davey23uk no downside to recreating the standby, apart from the hassle of doing it if you have no experience

You are going to need to have this "under your belt" anyway, since recreation is needed if ever you restore & partially recover the primary or when you test the activation of the standby. Whoever first created the standby should have left instruction on how to do it.

Could anybody tell me whether it is a good way? Is there any risk? After the above steps, should we create the log on both databases and how could we create the log file matched on both database? Thank you for your help in advance.