10-13-2019 07:26 AM
Hi,
Good day. My archive logs are only backup when I run a full backup. This makes the backup time longer, which is affecting some batch jobs.
I'm planning to schedule in between job using OIP to backup archive logs. When creating the policy, there is an option for FRA (Fast Recovery Area). However, my archive logs are not in the FRA.
Is it mandatory to have my logs to be in FRA?
Regards,
J
Solved! Go to Solution.
10-13-2019 07:37 AM
No it is not mandatory to have the logs in FRA.
You can keep the backup selection as Whole Database, and create a single schedule of type Archive Redo logs to backup the archive logs.
10-13-2019 07:37 AM
No it is not mandatory to have the logs in FRA.
You can keep the backup selection as Whole Database, and create a single schedule of type Archive Redo logs to backup the archive logs.
10-14-2019 07:16 AM
Thank you Amol_Nair.
Using OIP, could it be possible to delete archivelogs which are already backed up one time and 7days old?
Below is the command, but I'm not sure how to call using OIP. Any suggestion?
delete noprompt archivelog all backed up 1 times to device type sbt completed before 'sysdate-7';