Re: trace controlfile contains error

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 11 Nov 2004 20:01:35 +1100
Message-Id: <41932a45$0$24380$afc38c87@news.optusnet.com.au>

Don Seiler wrote:

> Using this command to get a trace controlfile:
>
> alter database backup controlfile to trace as '/home/me/control.trc';
>
> It produces a trace file but with one difference to the normal trace
> controlfile, it contains an extra blank link before the 'DATAFILE' clause
> of the CREATE CONTROLFILE section:
>
> -- STANDBY LOGFILE
>
> DATAFILE
>
> So running either of the scripts in that file treat DATAFILE as a new
> command. Manually removing the newline fixes the problem.
>
> Running just 'alter database backup controlfile to trace' does not suffer
> from this problem.
>
> Is anyone else seeing this? I've done a quick search on metalink and
> don't see it mentioned.

Confirmed to happen on Red Hat Advanced Server 3, using 10g. And yes, it 'breaks' the script when it's run. So it's a bug, and it's not fixed yet!

Regards
HJR Received on Thu Nov 11 2004 - 03:01:35 CST