ORA-16009


ORA-16009: remote archive log destination must be a STANDBY database 

Cause: The database associated with the archive log destination service name is other than the required STANDBY type database. Remote archival of redo log files is not allowed to non-STANDBY database instances. 

Action: Take the necessary steps to create the required compatible STANDBY database before retrying the ARCHIVE LOG processing. 


To check the database, run this query:

SQL> select database_role, open_mode from v$database;

PHYSICAL STANDBY MOUNTED

No comments:

Oracle Database 23AI session-related scripts.

  Oracle Database 23AI session-related scripts. ##Columns Name Details### sid - session identifier serial# - session serial number osuser - ...