How do I delete my archive log standby?
Dataguard command for delete archive log
- Configure _log_deletion_policy=’ALL’ init parameter and restart the instance for take effect. ALTER SYSTEM SET “_log_deletion_policy”=’ALL’ SCOPE=SPFILE;
- Configure RMAN deletion policy using RMAN command.
- You can also configure this command on Primary Server.
How do I view stand logs in standby database?
Another check to verify that primary and standby are in sync: Run the following query on both standby and primary after all logs in v$archived_log show APPLIED=YES: SQL> select max(sequence#) from v$log_history. Output should be same on both databases.
How do I clean up archive logs?
Delete Archive Log Files from Oracle Database
- Go to the Oracle server. Launch the command prompt.
- Type: RMAN.
- Type: connect target sys@SIDname.
- Once connected to RMAN prompt, run the following command:
- Then have RMAN run this:
- Exit the command prompt.
- Now run the backup job and verify that it is successful.
How to check your archivelog deletion policy for standby database?
Check your deletion policy. This is the result on primary where the last archivelog backup has run around 21:00 This is good for my policy APPLIED ON ALL STANDBY – except that because of the bug mentioned above, redo applied since 06:00 are not yet reclaimable.
What’s the deletion policy on Data Guard configuration?
The deletion policy on a dataguard configuration should be: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; for the site where you don’t backup. It can be the standby or the primary. and: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; for the site where you do the backups.
Do you need archived logs for standby backup?
The archived logs that you don’t need are reclaimable by the FRA when space is needed. And the archived logs that are required for availability (standby or backup) are not deleted.
Is the archivelog deletion policy set correctly in Oracle?
And you will see that until 12c the APPLIED ON ALL STANDBY does not work as expected. You’ve probably seen a FRA full at standby site and solved it by deleting archived logs. But this is not the right solution because the FRA is supposed to do that. Let’s look at an example I encountered recently. The archivelog deletion policy is set correctly: