OraFAQ Forum: Data Guard » ORA-00308: -- DR looking for older archive logfiles

Home » Server Options » Data Guard » ORA-00308: -- DR looking for older archive logfiles (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00308: -- DR looking for older archive logfiles [message #672031]

Fri, 28 September 2018 08:05

muthukrish104
Messages: 82
Registered: November 2017

Member

Hello All,

We are trying to make a Physical Standby DR (with manual mode - transferring and applying archive log manually).

But it looks for older archive log, which is not there in primary and the query also not showing it.

Here is the steps we did:

1) Make the primary down. and copy the physical files into DR location.
2) Enabled Archive log in primary.
3) Created standby controlfile and copied to DR location.
4) Made pfile from spfile.
5) changed the parameters accordingly in DR db and made it in mount mode.
6) Copying archive logs manually in to DR.
7) Trying to apply archive logs, but below are the error message.


SQL> recover standby database;

ORA-00279: change 57652339202 generated at 09/23/2018 00:39:16 needed for
thread 1
ORA-00289: suggestion :
J:\ORACLE\ORA12C\DPMHIST\ARCHS\DPMHIST49191_0873978123.0001.ARC
ORA-00280: change 57652339202 for thread 1 is in sequence #49191

But when we are trying to fetch that particular Archive log file in primary it is not showing result.


select * from v$archived_log
order by next_time desc

987842436	J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHIST49203_0873978123.0001.ARC	1	1	49203	2233668	3/10/2015 11:42:03 AM
987842235	J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHIST49202_0873978123.0001.ARC	1	1	49202	2233668	3/10/2015 11:42:03 AM
978375803	J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHISTARCH43142_0873978123_0001.ARC	1	1	43142	2233668	3/10/2015 11:42:03 AM
978374414	J:\ORACLE\ORA12C\DPMHIST\ARCHP\DPMHISTARCH43141_0873978123_0001.ARC	1	1	43141	2233668	3/10/2015 11:42:03 AM

In short, the archive log to be applied to DR is missing. what could be the solution.

Kindly help me.

Regards
M.krish

Attachment: Archive issue HIST DR.jpg
(Size: 99.04KB, Downloaded 4739 times)

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672033 is a reply to message #672031]

Fri, 28 September 2018 09:30

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

That is the oddest way of creating a physical standby that I have ever heard of. Why not follow the method in the docs? Enable archive log mode, create your standby logfiles, use RMAN to create the standby databgase.

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672034 is a reply to message #672031]

Fri, 28 September 2018 09:43

Michel Cadot
Messages: 68715
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you don't want to follow John's advice, swap 1) and 2) and make sure you cleanly shut down (use immediate or normal option) the primary. If it asks for old logs, it is most likely because the database was not cleanly closed and the files in a correct state.

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672035 is a reply to message #672034]

Fri, 28 September 2018 09:48

Michel Cadot
Messages: 68715
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at this post.

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672066 is a reply to message #672035]

Mon, 01 October 2018 00:49

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi All,

Thanks for the reply.

What we did is:

1) Because of the primary DB is very huge size (5TB), the server team has copied the entire drives through SAN storage copying.

2) We had enabled archive log after copying the hard disk files, that we thought it wont be a problem.

3) We want to avoid taking RMAN backup as the size is huge and transportation also will be the trouble.

When I inform the server team about this type of copying, they reply after the copying the "DB COULD BE READ ONLY Mode" then their way is corret,

Kindly suggest, is there any alternate way from this situation like.

1) backup from the point of last applied SCN.
2) Reset the logs
etc..

Regards
Muthu.k

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672067 is a reply to message #672066]

Mon, 01 October 2018 01:36

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

If you don't want to use an RMAN DUPLICATE, you don't have to. To quote from chapter 3 of the Data Guard Concepts and Administration Guide,Quote:

You can use any backup copy of the primary database to create the physical standby database, as long as you have the necessary archived redo log files to completely recover the database. Oracle recommends that you use the Recovery Manager utility (RMAN).

You just have to do everything in the correct order.

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672074 is a reply to message #672067]

Mon, 01 October 2018 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

John Watson wrote on Sun, 30 September 2018 23:36

If you don't want to use an RMAN DUPLICATE, you don't have to. To quote from chapter 3 of the Data Guard Concepts and Administration Guide,Quote:
You can use any backup copy of the primary database to create the physical standby database, as long as you have the necessary archived redo log files to completely recover the database. Oracle recommends that you use the Recovery Manager utility (RMAN).
You just have to do everything in the correct order.

Do you mean that Ready, Fire, AIM is not a viable solution?

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672095 is a reply to message #672066]

Tue, 02 October 2018 14:59

JPBoileau
Messages: 88
Registered: September 2017

Member

muthukrish104 wrote on Mon, 01 October 2018 00:49

1) Because of the primary DB is very huge size (5TB), the server team has copied the entire drives through SAN storage copying.

2) We had enabled archive log after copying the hard disk files, that we thought it wont be a problem.

This is out of order. The DB MUST be in archive log mode BEFORE you can take a SAN copy (and preferably, a few archived redo logs should be generated). Additionally, the entire database must be in backup mode for a SAN copy to be usable - and even then, that's not a 100% guarantee in my book. I'd shut down the primary BEFORE taking a SAN copy.

JP

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672096 is a reply to message #672095]

Tue, 02 October 2018 23:42

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi All,

Thanks for the suggestions.

Well understood.

By any chance, do we have any alternative solution?

Regards
M.krish

Report message to a moderator

Re: ORA-00308: -- DR looking for older archive logfiles [message #672205 is a reply to message #672096]

Sun, 07 October 2018 23:42

muthukrish104
Messages: 82
Registered: November 2017

Member

Hey All,

I could successfully done it by the method of ROLLING FORWARD PHYSICAL STANDBY.
Docs given by Oracle Support.

Thanks for the support.

Regards
M.krish

Report message to a moderator