Re: anyone have a decent purge script for 11g diag directories
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 14 Nov 2008 18:32:26 -0800
Message-ID: <1226716329.130899@bubbleator.drizzle.com>
>
> You mean something like this?
> SQL>
> SQL> alter database backup controlfile to trace as '/tmp/dan.sql';
>
> Database altered.
Date: Fri, 14 Nov 2008 18:32:26 -0800
Message-ID: <1226716329.130899@bubbleator.drizzle.com>
Mladen Gogala wrote:
> DA Morgan wrote:
>
>> What I'd like to see is an easy way to do backup controlfile to >> trace and not have the file named like every other trace file (I >> mean the text version not just the binary). That would be a >> decent enhancement.
>
> You mean something like this?
> SQL>
> SQL> alter database backup controlfile to trace as '/tmp/dan.sql';
>
> Database altered.
That makes a binary copy not a text copy. Please note that I addressed that above.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 14 2008 - 20:32:26 CST