OraFAQ Forum: Backup & Recovery » Oracle Database recover using reset archivelogs

Home » RDBMS Server » Backup & Recovery » Oracle Database recover using reset archivelogs (10.2.0.1)

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

Oracle Database recover using reset archivelogs [message #490332]

Mon, 24 January 2011 01:54

paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan

Member

Hi,

We have faced database(10.2.0) issue cause incomplete recovery and have performed open resetlogs. This DB is of 12Tb. In 10g opening database with reset logs do not invalidate previous backups. we have another replica(no reset state)of this database which we sync using archives.
Please help me how we can apply those archives(reset database)to previous database?

Thanks,
Yasir Aftab

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490334 is a reply to message #490332]

Mon, 24 January 2011 01:59

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

Senior Member

If you have database flashback enabled, you can flashback to before the reset logs, and then apply the archives from the other database. If you do not have flashback enabled, I do not think it is possible.

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490335 is a reply to message #490332]

Mon, 24 January 2011 02:00

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

Senior Member
Account Moderator

Which one is "previous database"?
It should be better if you name the databases and instances.

If you want to apply your new logs to your standby database (which I assume to be what you call "another replica"), you can't.

Regards
Michel

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490355 is a reply to message #490335]

Mon, 24 January 2011 04:54

paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan

Member

Michel Let me clarify.

1) DB Name: trdb(site A)
We have performed incomplete recovery and open this database using resetlogs.
2) We restored trdb old backup to another Site B.

3) Now we want archives of trdb (after resetlogs Site A) to apply on trdb(Site B).

How should i sync Site B database using site A archives which are generated after resetlogs. Hope i have clarify .

Thanks
Yasir

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490356 is a reply to message #490355]

Mon, 24 January 2011 04:55

paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan

Member

Please check this URL http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#i1006820 and help me understand.

Thanks

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490366 is a reply to message #490356]

Mon, 24 January 2011 05:17

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

Senior Member
Account Moderator

Which kind of backup? RMAN or else?
Copy and paste what you do and have, it is hard to help you without knowing what you actually did.
Do you satify the prerequisites of the link you gave?

Regards
Michel

[Updated on: Mon, 24 January 2011 06:07]

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490382 is a reply to message #490366]

Mon, 24 January 2011 05:56

paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan

Member

cold backup(before resetlog). Now want to applu archives of after resetlogs database on that cold backup.
If you can make me understand above document,
1) we have to create backup controlfile of reset database and replace it with controlfiles of coldbackup.
2) register newly created archives of resetlog database with previous cold backup and then recover?

Report message to a moderator

Re: Oracle Database recover using reset archivelogs [message #490389 is a reply to message #490382]

Mon, 24 January 2011 06:08

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

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN Backup
Next Topic:	rman backup script suggestion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 22:02:19 CST 2024