Re: physical standby and temp datafiles
Date: Wed, 15 Jun 2011 14:27:33 -0400
Message-ID: <20110615182733.GC19111_at_cns.vt.edu>
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_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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 15 2011 - 13:27:33 CDT