Re: physical standby and temp datafiles
- From: "'stellr@xxxxxxxxxx'" <stellr@xxxxxxxxxx>
- To: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
- 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.
>
> Thanks,
> Finn
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of fmhabash
> Sent: Wednesday, June 15, 2011 1:00 PM
> To: stellr@xxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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'
>
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
