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
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:
Post a Comment