Friday, March 16, 2018

ORA-01156: recovery or flashback in progress may need access to files

Trying to create the standby log file on DR database and getting the error:

ORA-01156: recovery or flashback in progress may need access to files

As the message suggest that recovery is in progress so shutdown the database and start up in mount mode

srvctl stop database -d dev1alsd 

srvctl start database -d dev1alsd -o mount

Now issue the command

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SIZE 100M; 

Database altered.

SQL>

It worked. Stop and start the database again.

srvctl stop database -d dev1alsd 

srvctl start database -d dev1alsd




No comments: