RE: Script tp parse control file backup ??

From: Mitchell Baldwin <Mitchell.Baldwin_at_cogent-dsn.com>
Date: Thu, 1 Jul 2004 16:27:16 +0100
Message-ID: <A5E49A0595FB4A489ED566217349B1472DBABC@zaphod1.cogent-dsn.local>

I see you've read the books on Perl, obviously didn't read the books on = OFA !...
=20

-----Original Message-----
From: Mladen Gogala [mailto:mladen_at_wangtrading.com] Sent: 01 July 2004 16:15
To: oracle-l_at_freelists.org
Subject: Re: Script tp parse control file backup ??

On 07/01/2004 10:31:11 AM, Mitchell Baldwin wrote:
> I thought I ought to post the code !....

I don't think so.

>=20
> ------- Start of Code

sqlplus:
alter database backup controlfile to trace as '/tmp/tracefile.trc';

perl -ne 'print unless ((/^#/) or (/^--/)); exit if = (/^;/);'</tmp/tracefile.trc

End of Code=20

Demonstration:
-bash-2.05b$ perl -ne ' print unless ((/^#/) or (/^--/)); exit if = (/^;/);'<tracefile.trc
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "CMPL" NORESETLOGS ARCHIVELOG     MAXLOGFILES 5
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE

  GROUP 1 '/data/CMPL/redo/redo01.rdo'  SIZE 128M,
  GROUP 2 '/data/CMPL/redo/redo02.rdo'  SIZE 128M,
  GROUP 3 '/data/CMPL/redo/redo03.rdo'  SIZE 128M

=20
DATAFILE

  '/data/CMPL/system/system01.dbf',
  '/data/CMPL/system/undotbs01.dbf',
  '/data/CMPL/supplied/indx01.dbf',
  '/data/CMPL/supplied/tools01.dbf',
  '/data/CMPL/supplied/users01.dbf',
  '/data/CMPL/supplied/xdb01.dbf',
  '/data/CMPL/data/COMPLIANCE1.dbf',
  '/data/CMPL/data/IMSEOK01.dbf',
  '/data2/CMPL/data/UNIV01.dbf',
  '/data/CMPL/data/UNIV_INDX01.dbf',
  '/data/CMPL/data/VIEW.dbf',
  '/data2/CMPL/data/WIZARD01.dbf',
  '/data2/CMPL/data/WIZARD_NDX01.dbf',
  '/data2/CMPL/data/TRD01.dbf',
  '/data2/CMPL/transport/BLOOMBERG01.dbf',
  '/data/CMPL/transport/BLOOMBERG02.dbf',
  '/data/CMPL/transport/BLOOMBERG01.dbf',
  '/data2/CMPL/transport/BLOOMBERG_NDX01.dbf',
  '/data2/CMPL/data/BLOOMBERG_NDX02.dbf',
  '/data2/CMPL/transport/BLOOMBERG02.dbf',
  '/data2/CMPL/data/BLOOMBERG_NDX03.dbf'

CHARACTER SET WE8ISO8859P1
;

--=20
Mladen Gogala
Oracle DBA

Note:
This message is for the named person's use only. It may contain = confidential, proprietary or legally privileged information. No = confidentiality or privilege is waived or lost by any mistransmission. = If you receive this message in error, please immediately delete it and = all copies of it from your system, destroy any hard copies of it and = notify the sender. You must not, directly or indirectly, use, disclose, = distribute, print, or copy any part of this message if you are not the = intended recipient. Wang Trading LLC and any of its subsidiaries each = reserve the right to monitor all e-mail communications through its = networks.
Any views expressed in this message are those of the individual sender, = except where the message states otherwise and the sender is authorized = to state them to be the views of any such entity.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 01 2004 - 10:23:29 CDT