Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Advise on a statement
Dutch_alien wrote:
> Hi,
>
> When you backup your controlfile to trace, you'll have a script to
> recreate the controlfile when you lose it. When you use the script in
> the trace-file, you'll lose the current status of the database.
> So when you have put one or more datafiles off-line, then recover using
> the script in the trace-file, the recovery will not know that the
> datafiles were offline.
>
> Regards,
>
> Arian
>
It does contain a hint, though:
# Files in normal offline tablespaces are now named. ALTER DATABASE RENAME FILE 'MISSING00005' TO '/o/oracle9/oradata/o920/example01.dbf'; # No tempfile entries found to add.
-- Regards, Frank van BortelReceived on Thu Apr 28 2005 - 13:05:14 CDT
![]() |
![]() |