Advices

How do I clean up archive logs?

How do I clean up archive logs?

How to delete old archive logs using RMAN Safely

  1. Delete one day old archive logs RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-1’;
  2. Delete 30 day old archive logs RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘sysdate-30’;

How do I remove applied archive logs from standby?

Testing

  1. RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY ;
  2. old RMAN configuration parameters:
  3. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
  4. new RMAN configuration parameters:
  5. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
  6. new RMAN configuration parameters are successfully stored.

How do I delete an expired backup in RMAN?

To delete expired backups:

  1. Connect RMAN to the target database as described in “Connecting to the Target Database Using RMAN.”
  2. Optionally, cross-check backup sets by using the following command: CROSSCHECK BACKUPSET;
  3. Delete expired backups using the following command: DELETE EXPIRED BACKUP;

How do I delete old archive logs in Oracle 11g?

Please guide me.

  1. Go to the Oracle server. Launch the command prompt.
  2. Type: RMAN.
  3. Type: connect target sys@SIDname.
  4. Once connected to RMAN prompt, run the following command: RMAN> crosscheck archivelog all;
  5. Then have RMAN run this:
  6. Exit the command prompt.
  7. Now run the backup job and verify that it is successful.

What is delete obsolete in RMAN?

A backup is obsolete when REPORT OBSOLETE or DELETE OBSOLETE determines, based on the user-defined retention policy, that it is not needed for recovery. A backup is considered expired only when RMAN performs a crosscheck and cannot find the file. In short, obsolete means “not needed,” whereas expired means “not found.”

How do I delete all RMAN backups?

To delete all backups for the target database use: RMAN> DELETE BACKUP;

  1. Delete Backupset. To delete a backup set specify the set number e.g. 23: RMAN> DELETE BACKUPSET 23;
  2. NOPROMPT keyword.
  3. Image Copies.
  4. Expired Backups.
  5. Obsolete Backups.

How do I delete old Backupset in RMAN?

RMAN Delete Command

  1. Delete Backupset. To delete a backup set specify the set number e.g. 23: RMAN> DELETE BACKUPSET 23;
  2. NOPROMPT keyword. By default the DELETE command will prompt for confirmation before deleting any backup files.
  3. Image Copies.
  4. Expired Backups.
  5. Obsolete Backups.

How do I fix data guard gap?

How to Resolve Gaps in Data Guard Apply Using Incremental RMAN Backup

  1. Step-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries.
  2. Step-2: Stop the Dataguard MRP ( Apply ) Process and shutdown Standby database.

How do I get rid of Recover auto standby database?

The AUTOMATIC option automatically generates the name of the next archived redo log file needed to continue the recovery operation. Cancel recovery after the Oracle database server has applied the available logs, by executing the following statement (or typing CTRL+C): SQL> CANCEL Media recovery cancelled.

What to do if FRA is full in Oracle?

The solution is to remove data from the FRA (see removing FRA logs )and/or increase the parameter DB_RECOVERY_FILE_DEST_SIZE. The best on site “Oracle training classes” are just a phone call away!

  • August 15, 2022

You may also like...