How do I remove applied archive logs from standby?

After changing the RMAN configuration…

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;

How do I move archive logs from primary to standby?

Copy the archive logs from primary to standby (Dbvisit ARCHDEST location), rename the files and then run dbvisit to apply logs. Copy the archive logs from primary to standby (Dbvisit ARCHDEST location), use RMAN to catalog the files and then apply them using RMAN.

How do I delete expired archive logs in RMAN?

Delete expired archivelogs and create new backup

1. rman target /
2. crosscheck archivelog all;
3. delete noprompt expired archivelog all;
4. backup database plus archivelog;

How do I fix RMAN 08137?

This error is related with the obsolete Extract , To solve this error, you need to unregister the obsolete extract as follows. As seen below obsolete EXTRACT1_NAME is showing REQ_SCN = 0. Unregister the Extract as follows, then try to delete the old archive logs. then run the unregister command as follows.

How do I manually log in archive standby?

At standby site, Do the log file registration at the standby site until all the missing log files are registered, Use this below command. SQL> alter database register logfile ‘/log/file/location/log_file_name_n. arc’; Now apply would take place and your standby will become sync with the primary.

How do I rebuild my standby?

Rebuild Physical Standby using RMAN full backup

1. run { allocate channel c1 device type disk format ‘/backup/nsmdb/NSMDB_%U’;
2. rman target / backup current controlfile for standby format ‘/backup/nsmdb/NSMDB_stby_ctl’;
3. rman target / startup nomount.
4. SQL> alter database mount standby database;
5. run {
6. set lines 150.

How do I delete old archive logs in Oracle?

Delete Archive Log Files from Oracle Database

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:
5. Then have RMAN run this:
6. Exit the command prompt.
7. Now run the backup job and verify that it is successful.

How do I delete obsolete?

To delete obsolete backups:

1. Connect RMAN to the target database as described in “Connecting to the Target Database Using RMAN.”
2. Delete all obsolete backups, including backup sets and image copies, using the following command: DELETE OBSOLETE;

How do I delete Archivelog forcefully?

You can delete all archivelog without prompt ( yes or no question ) and with force option. RMAN> delete noprompt force archivelog all; You can delete archivelog which is backed up 1 times to Tape. you can change 1 times with 2 or 3.

How do I remove my primary standby database?

A) To remove from Broker:

1. — On Primary Database testdb2.
2. — On testdb2 Remove Standby database testdb3 Destination from log_archive_dest_n.
3. — Remove Standby database testdb3 from log_archive_config parameter.
4. — TESTDB3 Standby.
5. — On testdb2 Remove Standby database testdb3 Destination from log_archive_dest_n.