Home » Server Options » Data Guard » ORA-00308: -- DR looking for older archive logfiles (oracle 12c Windows 2012)
ORA-00308: -- DR looking for older archive logfiles [message #672031] Fri, 28 September 2018 08:05 Go to next message
muthukrish104
Messages: 71
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

Cool 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

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

Kindly help me.

Regards
M.krish
Re: ORA-00308: -- DR looking for older archive logfiles [message #672033 is a reply to message #672031] Fri, 28 September 2018 09:30 Go to previous messageGo to next message
John Watson
Messages: 8077
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.
Re: ORA-00308: -- DR looking for older archive logfiles [message #672034 is a reply to message #672031] Fri, 28 September 2018 09:43 Go to previous messageGo to next message
Michel Cadot
Messages: 66719
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: ORA-00308: -- DR looking for older archive logfiles [message #672035 is a reply to message #672034] Fri, 28 September 2018 09:48 Go to previous messageGo to next message
Michel Cadot
Messages: 66719
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at this post.

Re: ORA-00308: -- DR looking for older archive logfiles [message #672066 is a reply to message #672035] Mon, 01 October 2018 00:49 Go to previous messageGo to next message
muthukrish104
Messages: 71
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
Re: ORA-00308: -- DR looking for older archive logfiles [message #672067 is a reply to message #672066] Mon, 01 October 2018 01:36 Go to previous messageGo to next message
John Watson
Messages: 8077
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.
Re: ORA-00308: -- DR looking for older archive logfiles [message #672074 is a reply to message #672067] Mon, 01 October 2018 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 26642
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?
Re: ORA-00308: -- DR looking for older archive logfiles [message #672095 is a reply to message #672066] Tue, 02 October 2018 14:59 Go to previous messageGo to next message
JPBoileau
Messages: 80
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
Re: ORA-00308: -- DR looking for older archive logfiles [message #672096 is a reply to message #672095] Tue, 02 October 2018 23:42 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi All,

Thanks for the suggestions.

Well understood.

By any chance, do we have any alternative solution?

Regards
M.krish
Re: ORA-00308: -- DR looking for older archive logfiles [message #672205 is a reply to message #672096] Sun, 07 October 2018 23:42 Go to previous messageGo to next message
muthukrish104
Messages: 71
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
Re: ORA-00308: -- DR looking for older archive logfiles [message #672206 is a reply to message #672205] Mon, 08 October 2018 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66719
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback.
Any doc number or link?

Re: ORA-00308: -- DR looking for older archive logfiles [message #672706 is a reply to message #672206] Thu, 25 October 2018 06:03 Go to previous message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi Michel,

This was given by Oracle Support Team

Regards
M.krish
Previous Topic: Error: ORA-12154 when add standby
Next Topic: database_properties
Goto Forum:
  


Current Time: Mon Dec 09 18:07:08 CST 2019