Re: physical standby and temp datafiles

From: 'stellr_at_cns.vt.edu' <stellr_at_cns.vt.edu>
Date: Wed, 15 Jun 2011 17:09:32 -0400
Message-ID: <20110615210932.GA20649_at_cns.vt.edu>

On Wed, Jun 15, 2011 at 01:13:10PM -0400, Jorgensen, Finn wrote:
> Yep. Start the database in read only mode and add the tempfile.

as I suspected:

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/database/db01/oradata/db/temp01.dbf' size 30416896; ALTER TABLESPACE TEMP ADD TEMPFILE '/usr/database/db01/oradata/db/temp01.dbf' size 30416896 *
ERROR at line 1:
ORA-01537: cannot add file '/usr/database/db01/oradata/db/temp01.dbf' - file already part of database

so, I'll try again and not do anything with the file and see what happens.

>
> Thanks,
> Finn
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fmhabash
> Sent: Wednesday, June 15, 2011 1:00 PM
> To: stellr_at_cns.vt.edu
> Cc: oracle-l_at_freelists.org
> Subject: Re: physical standby and temp datafiles
>
>
> - 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'
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> >>> This e-mail and any attachments are confidential, may contain legal,
> professional or other privileged information, and are intended solely for the
> addressee. If you are not the intended recipient, do not use the information
> in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

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

Received on Wed Jun 15 2011 - 16:09:32 CDT