Home » RDBMS Server » Backup & Recovery » Restore with archive log only (9.2.8.0)
Restore with archive log only [message #592607] Fri, 09 August 2013 17:18 Go to next message
Amine
Messages: 264
Registered: March 2010
Senior Member

Hi all,
We have a 9.2.8.0 database in archive log mode. We want to restore that db to a specified point in time.
What is the fastest way to do it ?

Thanks in advance,

Amine
Re: Restore with archive log only [message #592610 is a reply to message #592607] Fri, 09 August 2013 17:29 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
Restore the DB from a FULL backup that was taken before the specified point in time & then apply all REDO log files from the Full backup until point in time.
Re: Restore with archive log only [message #592615 is a reply to message #592610] Fri, 09 August 2013 19:53 Go to previous messageGo to next message
Amine
Messages: 264
Registered: March 2010
Senior Member

FULL backup means backup with RMAN right ?
Re: Restore with archive log only [message #592617 is a reply to message #592615] Fri, 09 August 2013 20:00 Go to previous message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>FULL backup means backup with RMAN right ?
only if you use RMAN to initiate your backups.

For V9 I was still doing User Managed backups.
Previous Topic: Duplicate Database Unable to Read Backupset
Next Topic: RMAN takes time to complete the backup but previously it was fine
Goto Forum:
  


Current Time: Sun Sep 21 11:50:00 CDT 2014

Total time taken to generate the page: 0.13032 seconds