Oracle-L: RE: RAC 9i - renamin files

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 20 Feb 2003 10:34:02 -0800
Message-ID: <F001.005532E8.20030220103402@fatcity.com>

I have not played with RAC yet but was wondering why we should shutdown down the database (except for the SYSTEM TS). Can't we put the Tablespace in the offline mode and then move/rename the file?

Can we still put the TS in the offline mode in RAC? Is it doable from any instance or should it be done from all instances?

Waleed

-----Original Message-----
Sent: Thursday, February 20, 2003 12:04 PM To: Multiple recipients of list ORACLE-L

And forget about gsd and srvctl - that stuff has nothing to do with RUNNING the database (but has to do with e.g. software install). Also, the parameter is cluster_database=false, parallel_server was for OPS back in Oracle8i, which (as everybody knows:-) is completely different from RAC.

In the end, all you need to do is to startup single instance (cluster_database=false) in mount mode while you do the rename.

/Bjørn.

Gogala, Mladen wrote:

Well, "rename file" actually updates the control file, so as long as

the control file is accessible to all nodes, all instances should know

about it. As for the procedure, you need to mount the database in

exclusive mode (only 1 instance, by specifying "PARALLEL_SERVER=FALSE" in

the init.ora), rename the file, bring the instance down and start it up

in shared mode.

-----Original Message-----

Sent: Wednesday, February 19, 2003 3:36 PM

To: Multiple recipients of list ORACLE-L

How do you rename files in RAC databases?

When dealing with single instance db

shutdown
startup mount
copy file to new location using OS util.
alter database rename file...

5 startup.

But now we have gsdctl, srvctl... So, what is the procedure

ti rename file?

We are using Tru64, so we have no raw devices.

Thanks,

Vladimir Barac

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>

Author: Vladimir Barac

INET: vladob_at_aster.si <mailto:vladob_at_aster.si>

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>

San Diego, California -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com <mailto:ListGuru_at_fatcity.com> (note EXACT spelling of 'ListGuru') and in

the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may

also send the HELP command for other information (like subscribing).

--

Bjørn Engsig, Miracle A/S
Member of Oak Table Network <http://www.oaktable.net> Bjorn.Engsig_at_MiracleAS.dk <mailto:Bjorn.Engsig_at_MiracleAS.dk> - http://MiracleAS.dk <http://MiracleAS.dk>

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 20 2003 - 12:34:02 CST