On Fri, 25 Jan 2002, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to