RE: Standy Startup READ ONLY

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 20 Mar 2007 07:21:45 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B02BB2423@JAX-MBH-01.crowley.com>

Thank you,

You hit the nail on the head. I was starting to wonder, and appreciate the answer as the behavior was unexpected. Yes 10gR2.

I had a couple private responses which --- didn't lead me to believe they understood the question.

Best Regards,

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: Pabba, Chandra [mailto:Chandra.Pabba_at_fmr.com] Sent: Monday, March 19, 2007 5:33 PM
To: Patterson, Joel; Oracle-L_at_freelists.org Subject: RE: Standy Startup READ ONLY

Joel,

I am assuming this is Oracle10gR2. If yes, when you use STARTUP on a physical standby database it mounts it as standby and opens read only. If you just use STARTUP MOUNT, it mounts in standby mode. In other words, the two methods you have included are same, as far as it is Oracle10gR2.

Thanks
Chandra Pabba

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel.Patterson_at_crowley.com

	Sent: Monday, March 19, 2007 2:50 PM
	To: Oracle-L_at_freelists.org
	Subject: Standy Startup READ ONLY

	Are these two the same?  Why does startup appear to work the

same? In other words I could have a start 'all' script without making exceptions for the READ ONLY standby database? What is making it start this way automatically. (which is fine if it is correct).

Startup nomount

alter database mount standby database;

alter database open read onlyl;

select open mode from v$database;

READ ONLY shutdown immediate

startup

select open mode from v$database;

READ ONLY Joel Patterson

Database Administrator

joel.patterson_at_crowley.com

x72546

904 727-2546

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 20 2007 - 06:21:45 CDT