Jeremiah, According to the "Oracle8i Standby Database Concepts and Administration Guide" on the online Generic Doc CD (I'm looking at the 8.1.6 Doc CD).
Page 4-15 Refreshing the Standby Database Control File The following steps describe how to refresh, or create a copy, of changes you have made to the primary database control file. Refresh the standby database control file after making major structural changes to the primary database, such as adding or dropping files. (Then the steps for refreshing the control file are given). Let me know if this is not the case. One thing we've noticed is that the status (from v$datafile) of the added data file shows "RECOVER" unless standby control file is not refreshed. Thanks, Gerardo -----Original Message----- Sent: Friday, January 25, 2002 2:00 PM To: Multiple recipients of list ORACLE-L On Fri, 25 Jan 2002, Molina, Gerardo wrote: > There is one last, but important step. > > You need to recreate standby control file... Why do you have to do that? It doesn't say to do that in the documentation. The new datafiles are reflected in the standby controlfile through normal recovery and by issuing the 'alter database create datafile' command. There is no need to re-dump and copy a new standby controlfile, and definitely no need to shut any database down. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jan 2002, Molina, Gerardo wrote: > 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 > > -----Original Message----- > Sent: Friday, January 25, 2002 12:01 PM > To: Multiple recipients of list ORACLE-L > > > 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. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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).
