Re: Advise on a statement

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 28 Apr 2005 20:05:14 +0200
Message-ID: <d4r8dd$o3s$1@news1.zwoll1.ov.home.nl>

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 Bortel

Received on Thu Apr 28 2005 - 13:05:14 CDT