Re: physical standby and temp datafiles
Date: Wed, 15 Jun 2011 17:09:32 -0400
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.
> -----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'
> >>> 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