Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NZE-29227: Certificate is expired.

1 Answers  


NZE-28798: Number of sub-keys application passes to bind does not match that in the key.

1 Answers  


ORA-14020: this physical attribute may not be specified for a table partition

1 Answers  


LPX-00243: element attribute value must be enclosed in quotes

1 Answers  


ORA-13501: Cannot drop SYSAUX tablespace

1 Answers  






ORA-12046: cannot use trusted constraints for refreshing remote MV

1 Answers  


RMAN-06592: must specify FROM PLATFORM

1 Answers  


ORA-07514: scgcan: $deq unexpected return while canceling lock

1 Answers  


ORA-02876: smpini: Unable to attach to shared memory for PGA

1 Answers  


ORA-02805: Unable to set handler for SIGTPA

1 Answers  


RMAN-06527: KEEP option is not supported for backup of backup sets

1 Answers  


ORA-27019: tape filename length exceeds limit (SBTOPMXF)

1 Answers  






Categories