?
Solved

How to start rac database as read only?

Posted on 2009-02-23
4
Medium Priority
?
4,478 Views
Last Modified: 2016-09-21
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.
0
Comment
Question by:geodin
4 Comments
 
LVL 18

Expert Comment

by:sventhan
ID: 23717214

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 
0
 
LVL 14

Expert Comment

by:sathyagiri
ID: 23717237
ALTER DATABASE RECOVER MANAGED
RAC Grid CANCEL;

Open database as read only:

ALTER DATABASE OPEN READ ONLY;

0
 

Accepted Solution

by:
geodin earned 0 total points
ID: 23738647
Got error running alter database open read only, telling me that it needs "standby" but this is not a standby database.

What I ended up doing is simply logging into each node and doing startup mount and alter to open read only.

I was thinking there should be a srvctl command like srvctl start database -d <name> -o "read only" but I haven't been able to find an example like this.

But thanks for the attempts.

Thanks,
Geodin
0
 

Expert Comment

by:Ivan Zotov
ID: 41808158
You have to use quotes
ex
srvctl start database -d dwh -o 'read only'
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question