Home » RDBMS Server » Backup & Recovery » Oracle Database recover using reset archivelogs (10.2.0.1)
Oracle Database recover using reset archivelogs [message #490332] Mon, 24 January 2011 01:54 Go to next message
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
Re: Oracle Database recover using reset archivelogs [message #490334 is a reply to message #490332] Mon, 24 January 2011 01:59 Go to previous messageGo to next message
John Watson
Messages: 8499
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.
Re: Oracle Database recover using reset archivelogs [message #490335 is a reply to message #490332] Mon, 24 January 2011 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Oracle Database recover using reset archivelogs [message #490355 is a reply to message #490335] Mon, 24 January 2011 04:54 Go to previous messageGo to next message
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
Re: Oracle Database recover using reset archivelogs [message #490356 is a reply to message #490355] Mon, 24 January 2011 04:55 Go to previous messageGo to next message
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
Re: Oracle Database recover using reset archivelogs [message #490366 is a reply to message #490356] Mon, 24 January 2011 05:17 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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?
Re: Oracle Database recover using reset archivelogs [message #490389 is a reply to message #490382] Mon, 24 January 2011 06:08 Go to previous message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: RMAN Backup
Next Topic: rman backup script suggestion
Goto Forum:
  


Current Time: Sat Feb 27 01:45:45 CST 2021