geodin
asked on
How to start rac database as read only?
Doing a restore of a prod database to dev environment and need to know how to start the database in read only state. I know for a single instance it would be to start then alter to open read only but I'm not sure how to do this with srvctl, tried srvctl start database -d <nam> -o readonly but didn't work.
ALTER DATABASE RECOVER MANAGED
RAC Grid CANCEL;
Open database as read only:
ALTER DATABASE OPEN READ ONLY;
RAC Grid CANCEL;
Open database as read only:
ALTER DATABASE OPEN READ ONLY;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to use quotes
ex
srvctl start database -d dwh -o 'read only'
ex
srvctl start database -d dwh -o 'read only'
Stop the managed recovery process using:
ALTER DATABASE RECOVER MANAGED
RAC Grid CANCEL;
Open database as read only:
ALTER DATABASE OPEN READ ONLY;
http://www.dba-oracle.com/t_oracledataguard_138_read-only_mode_.htm