RE: Standby database question

Please pardon my poor grammar.

I should have said...

The status of the data file (on the standby database) shows "RECOVER" unless the standby control file is refreshed.

Thanks,
Gerardo

-----Original Message-----
Sent: Monday, January 28, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L

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


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