ORA-16140: standby online logs have not been recovered



ORA-16140: standby online logs have not been recovered..

Answer / guest

Cause: The standby database has online logs containing redo
that has not been recovered. Activating the standby would
lose redo contained in the online logs.

Action: To recover the standby online logs issue the
following command: ALTER DATABASE RECOVER MANAGED STANDBY
DATABASE FINISH. Then re-issue the ALTER DATABASE ACTIVATE
STANDBY DATABASE command. To activate the standby without
recovering the online logs, issue the following command:
ALTER DATABASE ACTIVATE STANDBY DATABASE SKIP STANDBY LOGFILE.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06315: IPA: Invalid connect string

1 Answers  


ORA-16222: automatic Logical Standby retry of last action

1 Answers  


ORA-06923: CMX: illegal break condition

1 Answers  


ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

1 Answers  


ORA-36968: (XSRELTBL11) workspace object must be a relation.

1 Answers  






KUP-04057: internal error: OCI error while fetching record.

1 Answers  


PLS-00523: ORDER methods must return an INTEGER.

1 Answers  


CLSS-00101: Oracle Cluster Repository mismatch with node string. (string != string)

1 Answers  


ORA-38436: attribute set used for an Expression set may not be modified.

1 Answers  


NZE-28804: Data source cannot close.

1 Answers  


ORA-01243: system tablespace file suffered media failure

1 Answers  


ORA-24003: Queue table index string inconsistent with queue table string

1 Answers  


Categories