Home » RDBMS Server » Backup & Recovery » apply archive logs to old incarnation (Oracle 11gR2 RHEL)
apply archive logs to old incarnation [message #638063] Tue, 02 June 2015 01:43 Go to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
Hi,

I have a database running and backup full, incr, archive
I have restore this database backup to a new server with open resetlogs.
Now I want to apply archive log backup to this database. What are the steps.
Re: apply archive logs to old incarnation [message #638067 is a reply to message #638063] Tue, 02 June 2015 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

After an open RESETLOGS you can no more apply the archive logs: you have open a new incarnation if the database and what were for the previous one no more apply to this one.

Re: apply archive logs to old incarnation [message #638069 is a reply to message #638067] Tue, 02 June 2015 02:14 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
My old database is running as it is.

This new database is recovered from old database and open reset logs. After reset log there is new incarnation in this database.
But I google and found the information that we can apply old database backups even we have reset log the database.
Re: apply archive logs to old incarnation [message #638071 is a reply to message #638069] Tue, 02 June 2015 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You misunderstood what Google told you or you found a wrong article.

Re: apply archive logs to old incarnation [message #638077 is a reply to message #638071] Tue, 02 June 2015 02:34 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
So I cannot apply backup to even after reset incarnation to old
Re: apply archive logs to old incarnation [message #638082 is a reply to message #638077] Tue, 02 June 2015 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You cannot apply something from a previous incarnation to the current one.

Re: apply archive logs to old incarnation [message #638084 is a reply to message #638069] Tue, 02 June 2015 02:53 Go to previous messageGo to next message
John Watson
Messages: 7620
Registered: January 2010
Location: Global Village
Senior Member
You can use database flashback to go back to before the resetlogs. If you enabled flashback.
Re: apply archive logs to old incarnation [message #638090 is a reply to message #638077] Tue, 02 June 2015 03:17 Go to previous messageGo to next message
gazzag
Messages: 993
Registered: November 2010
Location: Bristol, UK
Senior Member
If you restore an older copy of the database then you can apply those logs. But after a RESETLOGS, you can't.
Re: apply archive logs to old incarnation [message #638447 is a reply to message #638069] Thu, 11 June 2015 14:40 Go to previous messageGo to next message
varunvir
Messages: 363
Registered: November 2007
Senior Member
If you set the database to old incarnation,then you could restore it
and then you could apply archive logs to it.
Something like that would work:-
RMAN> list incarnation of database;
RMAN> startup mount;
RMAN> reset database to incarnation "to old incarnation"
Then try restoring and recovering.

Thanks,

Varun
Re: apply archive logs to old incarnation [message #638450 is a reply to message #638447] Thu, 11 June 2015 14:57 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes this is what has already been said and is anyway not the question.

Previous Topic: lost sysaux datafile (merged)
Next Topic: OEM Backup settings - ORA-27040, ORA-12505.
Goto Forum:
  


Current Time: Sun Oct 21 03:15:25 CDT 2018