Database Administration (MOSC)

MOSC Banner

flashback issue

edited Oct 31, 2019 2:41AM in Database Administration (MOSC) 26 commentsAnswered

Hi,


Its a snapshot standby database . We dont maintain any flashback logs or archivelogs of this database. Suddenly I noticed this database is down .While starting it is showing below error. Can someone please guide how to open this database ... Found one document from oracle website . It is suggesing to drop the restore point. But while dropping it is showing
ORA-00933: SQL command not properly ended . Please help on this


SQL>  alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.

SQL> select open_mode from v$database;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center