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:

ORA-06512: at "SYS.DBMS_ISCHED"

Database -  Oracle Database 23AI Cause:   An attempt was made to perform a scheduler operation without the required privileges. Action:  Ask...