1) From bug 6216036: In 10g, the archive log deletion policy configured using CONFIGURE command applies only to automatic deletion of archived logs by Flash Recovery Area.

Many times as a DBA , we may have to delete old archive logs using RMAN. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process . how to apply primary database redo information to standby database while standby database is in read only mode Active Data guard feature Active Data Guard Part-IV; How to open physical standby database in read only mode Active Data Guard Part -III; Oracle 11g Data Guard Switchover and Switchback Active Data Guard Part-II

and then backing up archived logs with option NOT BACKED UP TIMES DELETE INPUT is executed from Primary, archived logs which have been backed up and not yet APPLIED on Standby are incorrectly deleted. log_archive_dest_1 LOCATION=USE_DB_RECOVERY_FILE_ DEST VALID_FOR=(ALL_LOGFILES,A LL_ROLES) DB_UNIQUE_NAME=standby ----Where the archive logs created from the standby are sent to. Home / DATAGUARD, SHELL SCRIPT / Script to delete applied archivelogs on a STANDBY database Script to delete applied archivelogs on a STANDBY database This script is designed to run against STANDBY databases to deleted applied archives older than specific number of hours defined by the user. The database requires a minimum of two files to guarantee that one is always available for writing while the other is being archived (if the database is in ARCHIVELOG mode).

I configured an Oracle 10.2.0.4 DataGuard Configuration that simply has a Primary and 1 Physical Standby Database.

STAMP.

rman target / DELETE ARCHIVELOG ALL COMPLETED BEFORE sysdate-2; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL; For standby database: rman target / CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; DELETE ARCHIVELOG ALL COMPLETED BEFORE sysdate

On the standby database: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; 2.

# Please read the following instructions on how to use this script: # - You can set MAIL_LIST variable to your E-mail to receive an email alert if archives # are not applied. Also, AWS DMS doesn't delete the entries it has created in the AWS DMS needs information about what destination to get archive redo logs from to read changes. Get File Or Folders Metadata.

Get Folder Details.

Here are few steps we can follow.

At the end, we're faced with lots of files filling the log destination either on the filesystem or ASM disk group.

Note: The value of this initialization parameter NLS_DATE_FORMAT is used to initialize the session value of this parameter, which is the actual value referenced by the SQL query processing. Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later Information in this document applies to any platform. How to Truncate, Delete, or Purge Rows from the Audit Trail Table AUD$ (Doc ID 73408 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 statement: alter database mount standby database RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names As we have removed the new archives from primary, the standby database cant proceed with the recovery without these

[[email protected] ~] cat DeleteArchive.rman run{ delete noprompt archivelog until time 'sysdate -1'; crosscheck archivelog all; } [[email protected] ~] Now Archivelogs older than 1 day in Standby database will be deleted automatically in Oracle dataguard.

Step 4:.

Delete old archive logs using RMAN. C) Remove the broker dr.dat configuration files (i.e.

RMAN> exit.

All such connections are strictly read-only; not even temporary tables may be written. From RMAN output we see the archives are deleted after backup: Archived log record stamp. Step 4.

Create new redo logs in ASM and delete the old ones.

Applies to: Oracle Database - Enterprise Edition - Version 11.1.0.7 and later Oracle Database Cloud Schema Service - The different processes involved and their functions during log mining and apply processing are as follows: During log mining: The READER process reads redo records from the archived redo log files or standby redo log files.. connect with RMAN and start recovery, using the following command. To upgrade the switch through the command-line interface (CLI), use the tar file and the archive download-sw privileged EXEC command. D data definition language.

log_archive_dest_2 SERVICE=PRODCDCS LGWR ASYNC VA LID_FOR=(ONLINE_LOGFILES,PRIMA RY_ROLE) DB_UNIQUE_NAME=primary -----Used when in

RMAN> configure archivelog deletion policy to applied on standby; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored. 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. RMAN> delete archivelog all backed up 1 times to SBT_TAPE; Apply Patching 32904851 Oracle 19c Database Release Update 19.12.0.0.0 Oracle Database Critical Patch Update Advisory July 2021 Oracle Database Security SQL> exec dbms_logstdby.apply_set (LOG_AUTO_DELETE,TRUE); PL/SQL procedure successfully completed. See "Managing Archived Redo Logs" for more information.. LGWR writes to redo log files in a 12c 19C archive archivelog ASM Audit AWR backup cloning cloud cluster database dataguard dgmgrl DISKGROUP EDB EXPDP failover flashback goldengate grid impdp multitenant OPATCH ORA-oracle oracle 12.2. oracle 12c partition patch patching PDB postgres RAC replication rman SCRIPT security SHELL script standby streaming tablespace temp undo upgrade

This feature can be used for calling pg_archivecleanup like: Refresh Standby Database using RMAN Incremental SCN Backup Table of Contents _____ Action Plan

If the primary database is up and running, defer the destination on the primary database and perform a log switch before Create Required Folders 6.

And just like that, our data is back on the primary database.

One database does not automatically delete the archive logs.

Control is not returned to the session that initiates a database shutdown until shutdown is complete. Copy and paste this code into your website.

7 rows selected.

RMAN backups of files can reside on either a local or network mounted file system. 2.

Use below rman script to delete archive logs older than 2 days. Actualy I have an Oracle 10G database deployment that contemplate two boxes: A Primary and a Standby database.

Step 2:. RECID.

At standby site, Do the log file registration at the standby site until all the missing log files are registered, Use this below command. With this command we list all the archive logs current known in the control file.

7 rows selected.

When I do archive backup, I use delete input clause, then archives are deleted. RMAN > list archivelog all; With this command we backup the all archive logs currently known in the control file.

Query deleted logs.

8.1.2 S hutting Down a Physical Standby Database. Here is an windows batch script to delete the applied archive logs from primary and standby servers. In the Database Registration section, select Register the cloned database as an Enterprise Manager target monitored by using DBSNMP.

delete noprompt archivelog until time 'sysdate-2'; If you configure archivelog deletion policy as in the following it couldn't delete archivelog and shows warning as RMAN-08120: warning: archived log not deleted, not yet applied by standby. To create a gap simulation, you need to delete the archive logs manually from the primary site. Specifies that the duplicate database is a standby database for the primary database. Again, a built-in feature in PostgreSQL helps us for calling a cleanup shell script. FAL[client]: Failed to request gap sequence GAP - thread 1 sequence .

The order of precedence in managing the archive log files are: If there are archive log files older than days to keep the archive log files, then delete these..

Multiple PREPARER processes can be active for a Indicates whether an RMAN DELETE command has physically deleted the archived log file from disk (YES) or not (NO) RMAN EXPIRED Removes only files whose status in the repository is EXPIRED.

( and the control file is updated ) RMAN> backup archivelog all;

On 10g, this can be done by using the following command at an RMAN prompt: backup database plus archive log delete all input;

The "shipped" option can be used in situations where we do not apply the redo on the standby database immediately.

Primary and standby configuration .Archive logs backups are configured on primary db .

Application Settings for the Database When querying the v$archived_log view for log_archive_dest_2 we can check what files are applied on the standby: select dest_id , sequence # , applied from v$archived_log where dest_id = 2

you can change 1 times with 2 or 3. It includes the redo entries and the unique log sequence number of the identical member of the redo log group.

Check if the logs are deleted.

Symptoms.

10.

RMAN> delete archivelog until time 'sysdate -1'; You can delete all archivelog without prompt ( yes or no question ) and with force option.

Create Sample RMAN deletion script: vi delete_archlogs.rman run { delete archivelog until sequence &1; } Step 2: Create Sample Shell script to determine Standby Recovery Sequence PL/SQL is pretty easy to do that, declare.

An illustration of a magnifying glass.

Thanks in advance. Cloud Monitoring supports the metric types from Google Cloud services listed on this page. Step 3:.

[Primary] Enable shipping again: PRIMARY_SQL > Alter system set log_archive_dest_state_2=enable scope=both; System altered. DEST_ID

The pgBackRest commands will be the same on any Unix system though the location of the See Also: Oracle Database Backup and Recovery Basics. Articles on oracle 12c, goldengate, oracle RAC, database script, OEM 12C/13C , dataguard, Oracle security, Performance tuning,Backup & Recover ,Troubleshoot d

Re: "ORA-00270: error creating archive log" on Standby Database, oracle-l at FreeLists Note: To chart or monitor metric types with values of type STRING, you must use Monitoring Query Language (MQL), and you must convert the value

The configured ARCHIVELOG DELETION POLICY is ignored.

Although the examples in this guide are targeted at Debian/Ubuntu and PostgreSQL 12, it should be fairly easy to apply the examples to any Unix distribution and PostgreSQL version.

Delete Archive logs Automatically on Standby Step 1:. If FORCE is not specified on the delete command then it follows the archived log deletion policy which determines when archived redo log files are eligible for deletion.

Actualy I have an Oracle 10G database deployment that contemplate two boxes: A Primary and a Standby database. SQL> insert into APPDATA (select * from APPDATA@HELPME ); 512 rows created.

In a RAC environment, there are two types of recovery. An important part of RMAN maintenance is deleting backups that are no longer needed. But minimal WAL does not contain enough information to reconstruct the data from a base backup and the WAL logs, so replica or higher must be used to enable WAL archiving (archive_mode) and streaming replication.Note that changing wal_level to minimal makes any base backups taken before unavailable for archive recovery and standby server, which may

To remove archive redo logs (and backup pieces) based on the database retention policy, run the following: RMAN> delete obsolete; As of Oracle 11g, you can specify an archive redo log deletion policy that is separate from that of the database backups.

STANDBY>alter database drop standby logfile group 4; Database altered.

Download File.

SQL> ALTER DATABASE MOUNT; Step-6. Environment On Source Server 1.

I can delete the archive logs by force using the The timing begins only when the user logs into the database. RMAN> configure archivelog deletion policy to applied on standby; new RMAN configuration parameters: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; new RMAN configuration parameters are successfully stored. Archivelog backups taken on the Primary database when connected to Recovery Catalog have to be restored.

Here are some useful RMAN commands for archive log management.

PostgreSQL, or Postgres, offers various ways to archive and replicate the primary database for backup, high- availability, and load balancing scenarios. Eventual Consistency in ThingWorx HA. orcl:/u02/DBA/scripts ->./delete_arch.sh The Oracle base remains unchanged with value /u01/app/orac

3.

rman target / DELETE ARCHIVELOG ALL COMPLETED BEFORE sysdate-2; CROSSCHECK ARCHIVELOG ALL; DELETE EXPIRED ARCHIVELOG ALL; For standby database: rman target / CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; DELETE ARCHIVELOG ALL COMPLETED To avoid conflicting entries in the RC_ARCHIVED_LOG for archivelogs restored on the Standby database use the Recovery Manager complete. RMAN Database Restore from 2 Node RAC+ASM TO 2 Node RAC+ASM 0.

At standby site, Do the log file registration at the standby site until all the missing log files are registered, Use this below command.

RMAN> CONFIGURE ARCHIVE DELETION POLICY TO SHIPPED TO ALL STANDBY; Delete archive log Script: Following script delete the archive log after 5 days. 3.

Archive Log Deletion Policy Not Applied Deleting Archivelogs In RMAN If Standby Is Down (Doc ID 1335326.1) Last updated on JANUARY 30, 2022.

There is no flash recovery configured on the production database and I also checked LOG_AUTO_DELETE is set to TRUE in logical standby database. # ##### # This Script deletes Applied Archives older than Specified N hours on STANDBY DATABASE # This script will run by default against ALL running STANDBY DATABASES. The deletion policy does not apply to foreign archived redo log files, which are logs received by a logical standby database for a LogMiner session. Archived log file name.

Using ThingWorx Logs to Monitor Database Performance. Standby site: If you now re-enable LOG_ARCHIVE_DEST_STATE_2, the standby automatically catches up.

Database link created.

# e.g. Delete one day old archive logs. Action ON STANDBY.

Some parameters, like loop_wait, ttl, postgresql.parameters.max_connections, postgresql.parameters.max_worker_processes and so on could be set only in the dynamic configuration.

Configure RMAN with the following policy: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE DISK; Delete until it has been backed up n times.

I'm having some troubles to manage when I need (could) delete the logfiles generated by the process.

Step-4. Thank you.

I'm having some troubles to manage when I need (could) delete the logfiles generated by the process.

4.

Its different for the database where you do the backup, because you want to be sure that the backup is done before an archivelog is deleted: CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK; This is a good way to prevent anyone from changing the configuration and keep it close to the backup scripts.

Categories DATAGUARD, ORACLE Tags alter system set fal_server, How do I delete old archive logs?

SQL> alter database open read only; (6) Check for the required data availability.

Dynamic configuration is stored in the DCS (Distributed Configuration Store) and applied on all cluster nodes.

Leonardo.

But you should not go for that option right away. I have RMAN backup on primary database, full and archive.

Standby redo log files must be of the same size as primary database redo log files Remove below parameters from spfile of primary database: FAL_SERVER FAL_CLIENT LOG_ARCHIVE_CONFIG DB_FILE_NAME_CONVERT LOG_FILE_NAME_CONVERT LOG_ARCHIVE_DEST_n pointing to standby database like _2 or _3 LOG_ARCHIVE_DEST_STATE_n STANDBY_ARCHIVE_DEST STANDBY>alter database drop standby logfile group 5; Database altered.

In a 11.2.0.4 One Primary-Physical Standby environment setup, already applied archive logs in Standby FRA are not deleted automatically until it runs out of space. I had to manually delete applied archive logs from standby to resolve space pressure. Is there a way to automatically delete the applied logs other than manual?

ASMCMD will work only in the case of the ASM environment.

Table 3 Cisco IOS Software Image Files localLocal user database, as defined on the Cisco router or access server, is used.

Use below rman script to delete archive logs older than 2 days. Startup Nomount 8.

With the name, you can clearly understand it fetched the archive logs for the standby database from the primary Read more.

Archive log apply delay saved the day! 00 P&P + 3 Last released Oct 11, 2017 MicroPython SPI driver for ILI934X based displays This is not needed when using a standalone AK8963 sensor An IMU (Inertial Measurement Unit) sensor is used to determine the motion, orientation, and heading of the robot Data is latched on the rising edge of SCLK Data is latched on the rising

SQL> alter database drop standby logfile group 1; alter database drop standby logfile group 1 * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files NOTE: Now to solve this issue we have cancel the managed recovery session and set "standby_file_management" to manual and drop the standby redolog file as Environment

Some other parameters like Oracle Database - Enterprise Edition - Version 11.2.0.3 and later Information in this document applies to any platform.

STANDBY>alter database drop standby logfile group 3; Database altered.

Control is not returned to the session that initiates a database shutdown until shutdown is complete.

STANDBY_ARCHIVE_DEST; Startup and Shutdown of ASM Instances.

Oracle RAC also supports Oracle Data Guard, thus you can have a primary database configured as a RAC and a standby database also configured as a RAC.

Click here for more details on add drop redolog files in Oracle database. to the Standby database.

ASMCMD will work only in the case of the ASM environment. we want the same archive log deletion to be set on standby also.

I have a Oracle Dataguard, 10g (10.2.0.5.0).

A light archive-log-deleting job which can be easily scheduled as database job or OS crontab job. Correct way to delete applied archived log file on standby database 1. But since you have the 15 minute archivelog in backups you can restore it from there when needed. Dbvisit Standby AMM processing overview. To use log archiving with Db2 high availability disaster recovery (HADR), configure both the primary database and the standby database for automatic log retrieval capability from all log archive locations.

If there are more archive log files than Number of archive log files to keep, then delete these (oldest ones first).. I have a Oracle Dataguard, 10g (10.2.0.5.0).

In general, you should not have to manually delete anything. The data dictionary views, also known as catalog views, let you monitor the state of the database in real time: The USER, ALL, and DBA, views show information about schema objects that are accessible to you, at different levels of privilege.

Overview of Required/Mandatory Parameters to set up PRIMARY & STANDBY DATABASE: DB_FILE_NAME_CONVERT, LOG_FILE_NAME_CONVERT: The purpose of the db_file_name_convert & log_file_name_convert parameters are for recovery purposes.

Set default_transaction_isolation into read committed. Restore controlfile 9.

I can delete the archive logs by force using the below command.

We need RMAN to automatically purge archivelogs from the FRA once they are applied to the standby database.

Dynamic configuration settings.

AWS DMS needs this because after the switchover the previous primary is a standby instance. Upload.

8.1.2 S hutting Down a Physical Standby Database.

For multiple standby systems, configure archiving on primary and all standby databases. SQL> alter database add standby logfile group 12 '+DG_TST_FRA' size 2048M; Database altered Drop the Online Redo Logfile Group: SQL>ALTER DATABASE DROP LOGFILE GROUP 2; If you have skipped Step 4 then you will get ORA-01624 while droping the Online Redolog Group with Status CLEARING alter database add logfile thread 1 group 5

Hi, in this article we are going to learn how to delete old archives using asmcmd.

Enter the target database name.

# Please read the following instructions on how to use this script: # You can set MAIL_LIST variable to your E-mail to receive an email alert if archives # are not Now replace all existing controlfiles with the backup of controlfile be careful then start standby up to mount status. This is after 5 minutes of no deleting even though I have 3 days worth of foriegn archived logs on the standbys ASM disk. Set STANDBY_FILE_MANAGEMENT to AUTO RMAN can back up archived redo log files, then delete them from the flash recovery area Now, all my files are known of my controlfile, lets try to open the standby database again: RMAN> alter database open read only; RMAN-00571: ===== RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ===== RMAN-00571: ===== Now we can re-enable the daemon on standby, and resume the log apply process as normal. In general, if you configure the archive cleanup measurement in the standby database environment or the main database environment, the DG environment will not allow you to delete the archive without using the archive.

I have RMAN backup on primary database, full and archive. For the InnoDB data dictionary, metadata is physically located in The PREPARER process converts block changes contained in redo records into logical change records (LCRs).

1- One of the obsolete integrated extract was causing Rman not to delete expired archive logs.

An archived redo log file is a copy of one of the filled members of a redo log group.

Instance Recovery.

Put the standby database back to managed recovery mode. Criteria No.

[oracle@pcguy ~]$ sqlplus / as sysdba. Mount database Continue reading RMAN Database In this case, DMS needs information about what destination to get archive redo logs from to read changes.

Delete File or Folder.

Customers who want to manually script maintenance of a standby database can create a second copy of their archive logs outside of Oracle ASM on a local file system only, designated by the LOG_ARCHIVE_DEST_ n parameter.

The job will not delete archive log files while other RMAN backup job is running, because it could delete files which are being backed up by RMAN job and fail the RMAN job. SQL> STARTUP NOMOUNT; Step-5. RUN {ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK; DELETE ARCHIVELOG UNTIL TIME 'SYSDATE -5';} Note: RMAN backup archivelog all delete all input will not delete archivelog files that are

If CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY and then backing up archived logs with option NOT BACKED UP TIMES DELETE INPUTis executed from Primary, archived logs which have been backed up and not yet APPLIED on Standby are incorrectly deleted. The configured ARCHIVELOG DELETION POLICY is ignored.

Backup database 2. Archivelog Delete Commands: delete archivelog all; delete archivelog until time 'SYSDATE-1'; delete archivelog from time 'SYSDATE-1'; delete archivelog from time 'SYSDATE-1' until time 'SYSDATE-2'; delete archivelog from sequence 1000; delete archivelog until sequence 1500; delete archivelog from sequence 1000 until sequence 1500; Oracle will automatically delete obsolete files. Goal. An archive log record is also inserted when an archive log is restored from a backup set or a copy and whenever a copy of a log is made with the RMAN COPY command.

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY; Or. On the Clone Database: Storage Locations page, in Database Files Location section, specify the location where datafiles, tempfiles, redo log files, and control files are to be created.

If the primary database is up and running, defer the destination on the primary database and perform a log switch before

"Bad event" entries in the migration logs usually indicate that an unsupported data definition language (DDL) operation was attempted on the source database endpoint. This is not a full database instance, just the memory structures and as such is very small and lightweight.

sqlplus "/ as sysdba" SQL>recover managed standby database disconnect; Media recovery complete. problem is that logs are getting deleted from primary even before shipping/applied to standby side .

RMAN> delete archivelog all backed up 1 times to SBT_TAPE;

How do I delete old archive logs? See my alert log. This setting is useful in a switchover when you use an Oracle Data Guard database as a source.

The following restrictions apply to opening a database:

Goal.

5.delete archivelog generated during backup which in most cases these logs couldn't send or applied to standby database. The redo log of a database consists of two or more redo log files.

1. redo logs, and RMAN backups.

Goal. Two types of logs are available: Security Logs - Generated by a Security Gateway, Harmony Endpoint, or Harmony Mobile.

Indicates whether the online redo log was archived (YES) or whether RMAN only inspected the log and created a record for future application of redo logs during recovery (NO). Optionally, use the -dbUniqueName parameter to set the unique database name for the standby database.

Start standby database up to nomount status.

The continuously transferred redo transaction is archived at the standby database before or after being applied, depending on the configuration. The files should only be removed after we are sure all transaction had been successfully applied to the standby database.

Thanks in advance. #VER 1.4] # This Script deletes Applied Archives older than Specified N hours on STANDBY DATABASE # This script will run by default against ALL running STANDBY DATABASES. Specify this parameter to delete the database archive logs.-deRegisterEMCloudControl.

This setting is the default when you are opening a physical standby database, so that the physical standby database is available for queries even while archive logs are being copied from the primary database site. or use rman to remove archivelogs if you have no FRA on standby. I perform nightly whole backups on the Primary using third-party software, Veritas, which basically runs an RMAN script by calling the RMAN API. How can I purge archivelogs on STANDBY Database?

This initial value is overridden by a client-side value if the client uses the Oracle JDBC driver or if the client is OCI-based and the NLS_LANG client setting (environment variable) is defined.

Action: Check the standby database and apply the logs manually and the start the deletion process.

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

2 situations when the redo is shipped to the standby, but not applied are : - DELAY=minutes attribute of the LOG_ARCHIVE_DEST_n initialization parameter. Enable change tracking if it was being used. In Hot Standby mode, the system employs two or more servers: A primary server runs the active database.

If you really want to delete the archivelogs older than 30 minutes the command is: RMAN> delete force archivelog until time 'sysdate -1/48'; Edit pfile 5.

This database accepts connections from clients and permits read-write operations.

Query whether logs are deleted by the operating system.

-- TESTDB3 Standby. The only OS-specific commands are those to create, start, stop, and drop PostgreSQL clusters.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Hi, in this article we are going to learn how to delete old archives using asmcmd.

This deletion policy applies to archive redo logs both outside and in the FRA.

f_count number ; Could not load library plpgsql.so. Hi expert, We are facing archive exhaust problem every alternate day on standby.

(7) Take an export of the required table or transfer that data to primary using db_link (8) Import the table on the primary database.

Action: Check the standby database and apply the logs manually and the start the deletion process. RMAN> exit. RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO

The workaround is to set a hidden parameter on the standby database (alter system set _time_based_rcv_ckpt_target=0;) and restart the redo apply.

And just like that, our data is back on the primary database.

To shut down a physical standby database and stop Redo Apply, use the SQL*Plus SHUTDOWN statement.