RE: physical standby and temp datafiles
- From: "Lange, Kevin G" <kevin.lange@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Jun 2011 13:32:28 -0500
Yea, sorry. Ours are not using Rman. Clone the standby, rebuilt its
control file. Add the temp file using the ALTER TABLESPACE TEMP ADD
TEMPFILE '/u03/ora_data/fred/fred/temp01.dbf'; command. (the command
you get from the Backup Controlfile to Trace command.
-----Original Message-----
From: Ray Stell [mailto:stellr@xxxxxxxxxx]
Sent: Wednesday, June 15, 2011 1:28 PM
To: Lange, Kevin G
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: physical standby and temp datafiles
On Wed, Jun 15, 2011 at 01:19:02PM -0500, Lange, Kevin G wrote:
> 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.
the question is how to go about "building" them. It sounds
like some here are buidling the standby in some way such that standby is
not "temp aware." Using rman, everything is in place except the OS
file. Someone made a private hint that this last step is completed by
data guard, it creates the file as needed.
I'm at the point of testing it. I'll be back.
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ray Stell
> Sent: Wednesday, June 15, 2011 12:30 PM
> To: fmhabash
> Cc: oracle-l@xxxxxxxxxxxxx
> 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.
> --
> //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.
>
> --
> //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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
