Highlighted

Backup Archivelog using OIP

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

Tags (2)
1 Solution

Accepted Solutions
Accepted Solution!

Re: Backup Archivelog using OIP

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.

View solution in original post

2 Replies
Accepted Solution!

Re: Backup Archivelog using OIP

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.

View solution in original post

Re: Backup Archivelog using OIP

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';