Home » RDBMS Server » Backup & Recovery » Archive log file missed (oracle version 10g Windows XP)
Archive log file missed [message #541240] Mon, 30 January 2012 03:36 Go to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hello All,

It is very urgent please.....

Today we have taken a backup of the Live database, due to some issue, it got deleted before applying into the Disaster Recovery Location.


Kindly tell me how to come out of this issue?


Its very urgent.

Regards:
Muktha
Re: Archive log file missed [message #541251 is a reply to message #541240] Mon, 30 January 2012 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Rerun your backup script.

Regards
Michel
Re: Archive log file missed [message #541257 is a reply to message #541251] Mon, 30 January 2012 03:54 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi Michel,

Thanks for your prompt reply.
But after the backup was taken all the ARCHIVE LOG FILES was deleted (We have made the script like this).
Now we have lost the backup files and the Archive log files also.

What to do?

Regards:
Muktha
Re: Archive log file missed [message #541261 is a reply to message #541257] Mon, 30 January 2012 04:05 Go to previous messageGo to next message
John Watson
Messages: 7259
Registered: January 2010
Location: Global Village
Senior Member
Quote:
What to do?

Make a backup, with archivelogs, RIGHT NOW!

And I mean NOW. Do not finish reading this.
Re: Archive log file missed [message #541262 is a reply to message #541257] Mon, 30 January 2012 04:05 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

In case you take full fresh backup, you'll not need deleted archived redo log files
Re: Archive log file missed [message #541264 is a reply to message #541262] Mon, 30 January 2012 04:08 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi John/Kamran,

Yes its is a good idea. But what is the solution for the non sinking of the DR Location's Archive log files?

Once i start to applying archive log into the DR, it will ask for the missing files, right?

Regards:
Muktha
Re: Archive log file missed [message #541268 is a reply to message #541264] Mon, 30 January 2012 04:12 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

If you're talking about the standby database, there's a solution. You can take level 1 backup "starting with the SCN value which is the latest SCN at the latest archived redo log file that's available in the Standby" side and perform incomplete recovery to take the standby to the specified SCN value
Check Arup Nanda's document :

Resolving Gaps in Data Guard Apply Using Incremental RMAN BAckup
http://arup.blogspot.com/2009/12/resolving-gaps-in-data-guard-apply.html
Re: Archive log file missed [message #541270 is a reply to message #541264] Mon, 30 January 2012 04:19 Go to previous messageGo to next message
John Watson
Messages: 7259
Registered: January 2010
Location: Global Village
Senior Member
Muktha, I hope you have started that backup. If not, all I can say isd that you are a dangerous lunatic who should never be allowed near a database.
Re: Archive log file missed [message #541546 is a reply to message #541270] Wed, 01 February 2012 01:42 Go to previous messageGo to next message
muktha_22
Messages: 526
Registered: December 2009
Senior Member
Hi John,

Thanks for your help.

1) That issue was not created by me.
2) It is now resolved.
3) And don't discourage the people by your words. (Think about your struggling days).

Thanks and Regards
Muktha
Re: Archive log file missed [message #545721 is a reply to message #541546] Thu, 01 March 2012 23:08 Go to previous messageGo to next message
Edwardjohn
Messages: 2
Registered: March 2012
Location: USA
Junior Member

This parameter is similar to the ADJUST_SCN event to advance the database SCN to higher value (ahead value). The database should be rebuilt after using this parameter and you should get support from Oracle to decide the value. This parameter is useful in some recovery situations where the current SCN needs to be incremented by a large value to ensure it is ahead of the highest SCN in the database software supplies. Typically it needed for ORA-600 [2662] errors to be recoverd.
Re: Archive log file missed [message #545722 is a reply to message #545721] Thu, 01 March 2012 23:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How adjusting the SCN to a higher value will solve the problem of missing archived logs in DR site?
Cab you explain?

Regards
Michel
Re: Archive log file missed [message #545728 is a reply to message #545722] Thu, 01 March 2012 23:37 Go to previous messageGo to next message
Edwardjohn
Messages: 2
Registered: March 2012
Location: USA
Junior Member

One of the more glaring examples is his overly simplistic treatment of the source for ORA-01555 errors, reducing it to inadequately sized undo segments. Yes, I know, that's ONE cause of the dreaded ORA-01555, but it is not the sole cause. Let's examine this error, its causes and what you can do about them.
Re: Archive log file missed [message #545737 is a reply to message #545728] Fri, 02 March 2012 01:07 Go to previous message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah! you're a spammer, I didn't understand the first time, waiting for your 5th post and the link you will post to ban you...

Regards
Michel
Previous Topic: 10g Recovery on a different Server
Next Topic: Rman cloning with catalog
Goto Forum:
  


Current Time: Tue Feb 20 02:16:28 CST 2018

Total time taken to generate the page: 0.02337 seconds