OraFAQ Forum: Backup & Recovery » apply archive logs to old incarnation

Home » RDBMS Server » Backup & Recovery » apply archive logs to old incarnation (Oracle 11gR2 RHEL)

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

apply archive logs to old incarnation [message #638063]

Tue, 02 June 2015 01:43

smunir362
Messages: 310
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.

Report message to a moderator

Re: apply archive logs to old incarnation [message #638067 is a reply to message #638063]

Tue, 02 June 2015 02:06

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

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.

Report message to a moderator

Re: apply archive logs to old incarnation [message #638069 is a reply to message #638067]

Tue, 02 June 2015 02:14

smunir362
Messages: 310
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.

Report message to a moderator

Re: apply archive logs to old incarnation [message #638071 is a reply to message #638069]

Tue, 02 June 2015 02:18

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: apply archive logs to old incarnation [message #638077 is a reply to message #638071]

Tue, 02 June 2015 02:34

smunir362
Messages: 310
Registered: September 2007

Senior Member

So I cannot apply backup to even after reset incarnation to old

Report message to a moderator

Re: apply archive logs to old incarnation [message #638082 is a reply to message #638077]

Tue, 02 June 2015 02:43

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: apply archive logs to old incarnation [message #638084 is a reply to message #638069]

Tue, 02 June 2015 02:53

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

Senior Member

You can use database flashback to go back to before the resetlogs. If you enabled flashback.

Report message to a moderator

Re: apply archive logs to old incarnation [message #638090 is a reply to message #638077]

Tue, 02 June 2015 03:17

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.

Report message to a moderator

Re: apply archive logs to old incarnation [message #638447 is a reply to message #638069]

Thu, 11 June 2015 14:40

varunvir
Messages: 389
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

Report message to a moderator

Re: apply archive logs to old incarnation [message #638450 is a reply to message #638447]

Thu, 11 June 2015 14:57

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

Senior Member
Account Moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 24 17:14:00 CST 2026