RE: physical standby and temp datafiles

From: Lange, Kevin G <kevin.lange_at_ppoone.com>
Date: Wed, 15 Jun 2011 13:19:02 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D107F48FC6_at_APSW0553EVS.ms.ds.uhc.com>

I have forgotten that step before when building a database from a standby. You get notified when they do not exist. Then, after building them , it all works fine.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ray Stell Sent: Wednesday, June 15, 2011 12:30 PM
To: fmhabash
Cc: oracle-l_at_freelists.org
Subject: Re: physical standby and temp datafiles

On Wed, Jun 15, 2011 at 01:00:10PM -0400, fmhabash wrote:
>
> - every file in v$tempfile must physically exist on disk
> - If they are not, add them ...
> ALTER TABLESPACE TEMP ADD TEMPFILE

'/u03/ora_data/fred/fred/temp01.dbf'

No, I doubt that command would work, like I said, the standby "ha record" of the temp datafile, but the OS file does not exist:

SQL> select name, bytes from v$tempfile;

NAME BYTES

------------------------ ----------
/usr/database/db01/orada	  0

ta/db/temp01.dbf

I suppose this makes sense since rman does not back these up and the standby was build from that backup:

SQL> host ls -l /usr/database/db01/oradata/db/temp01.dbf ls: /usr/database/db01/oradata/db/temp01.dbf: No such file or directory

It seems like data guard should/could make these files during the role change.

--
http://www.freelists.org/webpage/oracle-l



This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 15 2011 - 13:19:02 CDT