cancel
Showing results for 
Search instead for 
Did you mean: 

Restore Oracle archive logs

AndresV
Level 6
Partner

Hi,

I take a full oracle database backup every day and archived logs backups every hour.

I need to restore database and archived logs until 11 am. 

Is there a way to restore/recover database and all archived logs from 00:00 to 11:00 am in one job I mean using one script?

 

5 REPLIES 5

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Work with your dba. He/she should know how to use 'recover until ...' in rman restore script.

Mike_Gavrilov
Moderator
Moderator
Partner    VIP    Accredited Certified

Best practice is not to do things you're not familiar with (especially if they are Oracle restore :) ) but if really need it:
https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta065.htm

Nicolai
Moderator
Moderator
Partner    VIP   

RMAN will take care of it using "recover until" - but you will see multiple jobs in Netbackup.

Please team-up with the DBA. 

Hi,

But everytime I take a backup a new control file is generated so, for example if I need to restore a bounch of archived logs I need to restore several control files as well and that is not useful.

That's a feature of Oracle.