08-05-2016 04:35 PM
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?
08-05-2016 07:33 PM
08-06-2016 02:24 AM
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
08-08-2016 01:12 AM
RMAN will take care of it using "recover until" - but you will see multiple jobs in Netbackup.
Please team-up with the DBA.
08-11-2016 09:43 AM
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.
08-11-2016 01:01 PM
That's a feature of Oracle.