Forum Discussion

technimdaxviii's avatar
6 years ago

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

  • 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.

  • 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.

    • technimdaxviii's avatar
      technimdaxviii
      Level 5

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