FreeLists / oracle-l / RE: Script tp parse control file backup ??

["Mitchell Baldwin" <Mitchell.Baldwin@xxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx]
Sent: 01 July 2004 16:15
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------