Re: Standby database question

On Fri, 25 Jan 2002, Rick_Cale_at_teamhealth.com wrote:

> One of the co-workers has a hot standby database. Logs are applied
> at some interval. He has to add a tablespace. What is necessay to
> make standby database aware of this?

This is clearly documented in the Oracle8i Standby Database Concepts and Administration Manual.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76995/standbys.htm#27363

In short, you just add the tablespace to the primary, wait for the standby to fail with ORA-01157, then issue the following command on the standby:

SQL> alter database create datafile '<foo>' as '<bar>';

Where foo is the location of the datafile on the primary, and bar is the location on the standby (usually the same).

If you create a tablespace with several datafiles, you will have to issue this command a few times after recovering the standby and waiting for the ORA-01157 each time.

Don't fall into the trap some people do where they think they have to copy the new file over to the standby every time they create a datafile.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).