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: 363
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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

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: 363
Registered: March 2010
Senior Member
FULL backup means backup with RMAN right ?

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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.

Report message to a moderator

Previous Topic: Duplicate Database Unable to Read Backupset
Next Topic: RMAN takes time to complete the backup but previously it was fine
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Mar 22 01:30:08 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.