0

As I'm new in using RMAN and archivelog, I've a few doubts regarding to this. My database is Oracle 11g(windows platform). It was previously in noarchivelog mode and recently I've changed it to archivelog mode to backup my data and it started generating archived redo logs in the ARCHIVELOG directory. Each day almost 7 or 9 GB archived redo logs are generating.

Also, I have set my recovery destination and size as 50G and recovery window parameter as 4 days. I know that archive redo log files help me for the point on recovery.

But I am not getting a clear idea about below.

  1. Do I need to delete archivelog mode or will it automatically get cleared?
  2. If I move these archivelog files to other location or disk as backup, should it help me to recover data till that date?
  3. If I need to restore a test database using the production database, is it possible with these archive files? Does it need any other processing?

Thanks in advance.

1
  1. Do I need to delete archivelog mode or will it automatically get cleared?

Configure archivelog deletetion policy as-

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK;

Then you can-

RMAN> DELETE ARCHIVELOG ALL BACKED UP 1 TIMES TO DISK;

Archived redo logs can be deleted automatically by the database or as a result of user-initiated RMAN commands. Only logs in the flash recovery area can be deleted automatically by the database. For archived redo log files in the flash recovery area, the database retains them as long as possible and automatically deletes eligible logs when additional disk space is required.

Configuring an Archived Redo Log Deletion Policy

  1. If I move these archivelog files to other location or disk as backup, should it help me to recover data till that date?

Yes, As long as RMAN can access these files.

  1. If I need to restore a test database using the production database, is it possible with these archive files? Does it need any other processing?

Archived Redo Logs are not sufficient to restore and recover a test database, you need to have full RMAN backup as well. Howerver, if you have physically identical database like Physical Standby database then these archived logs can be used to refresh such databases.

  • I've one more doubt. If I change 'ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DISK', does it automatically get backed up in my server? If so, to which location? How can I utilise it to restore my database at the point of recovery? – SHS Feb 22 '17 at 12:26
  • No, this is archive log deletion policy. It defines when archive logs are eligible for deletion when there is storage space pressure. – JSapkota Feb 22 '17 at 12:35
  • Also it prevents accidental deletion of archive logs when we use delete archive log explicitly. – JSapkota Feb 22 '17 at 12:44
  • So, do I need to set a backup location explicitly? Using any other commands? or does it go to a location by default? – SHS Feb 23 '17 at 7:09
  • I have a doubt related to this command "As long as RMAN can access these files" . If i use "delete archivelog all;" command and remove all archive logs, Even after that does the archive logs that I backed up in other location will help me to recover my db? – SHS Feb 25 '17 at 10:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.