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-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...