Re: Script tp parse control file backup ??

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Thu, 01 Jul 2004 10:06:56 -0600
Message-id: <40E436A0.FD9F400C@sun.com>

Mladen,

Excellent piece of code. I do have some questions (as a perl newbie...real newbie). In 9i, the trace file issues 2 sets of commands. One for noresetlogs and one for resetlogs. This call retrieves only the first one. And it also does not include the commands following the create controlfile command (recover db (which I always remove), opening the db and adding any tempfiles. I'm not sure how to code this and it really is not a big deal (the call gets 95% of what is needed). Any thoughts?

Regards,
Daniel Fink

Mladen Gogala wrote:

> 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
>
> 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
> ;

---

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 - 11:03:57 CDT