RE: Standby database question

There is one last, but important step.

You need to recreate standby control file...

on primary:

alter database create standby controlfile as '<file_name>';

ftp this new file to standby

on standby:

shutdown immediate

copy new control file to appropriate locations with correct file name.

startup nomount

alter database mount standby database

HTH,
Gerardo

-----Original Message-----
Sent: Friday, January 25, 2002 12:01 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Molina, Gerardo
  INET: Gerardo.Molina_at_schwab.com

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).