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:

How to set the schema session limit in Oracle 23 AI Database.

  In Oracle, to set a session limit per schema (user)—i.e., control how many concurrent sessions a specific user can have. You use profiles ...