ORA-38757: Database must be mounted and not open to FLASHBACK.

Cause:

While trying to flashback the database after a failure in open mode , below error got triggered

SQL> flashback database to scn 999545;
flashback database to scn 999545
*
ERROR at line 1:
ORA-38757: Database must be mounted and not open to FLASHBACK.

Workaround:

Bounce the database to mount mode and issue the command again

SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1553305600 bytes
Fixed Size                  2253544 bytes
Variable Size             956304664 bytes
Database Buffers          587202560 bytes
Redo Buffers                7544832 bytes
Database mounted.

It should work now

SQL> flashback database to scn 999545;



SQL> alter database open resetlogs;

Database altered.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s