RE: rman duplicate

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 15 Dec 2004 08:46:52 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B4391AD@fiji.arraybp.com>

metalink note: 155656.1

---

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joan Hsieh Sent: Wednesday, December 15, 2004 8:29 AM To: oracle_l
Subject: rman duplicate

Hi Listers,

I'd like to automate rman to duplicate db on a remote server as refresh=20 purpose.
The target database is in archive mode, and I want duplicate testdb in=20 noarchive mode. we use cold rman backup. I had no problem to duplicate=20 the test remote database. However, I am not sure how to make it automate =

without manuly issue the command "alter database open resetlogs" on=20 testdb site.
Here is my script to run duplicate;
run {

    set until time 'SYSDATE -1';
    allocate channel d1 type disk;

    allocate auxiliary channel aux1 type disk;
    allocate auxiliary channel aux2 type disk;
    allocate auxiliary channel aux3 type disk;

    duplicate target database to $A_ORACLE_SID     logfile

         '/redo1/NGDDBA/log01.dbf' size 20k,
         '/redo1/NGDDBA/log02.dbf' size 20k,
         '/redo1/NGDDBA/log03.dbf' size 20k;
    release channel aux1;

    release channel aux2;
    release channel aux3;
}

At end of the log, I got the following error, I have to log on testdb=20 and open resetlogs, the testdb open without any problem. I tried to add=20 sql' alter database open resetlogs' in the script, It won't go that far.

thanks,

Joan

executing script: Memory Script

executing command: SET until clause

Starting recover at 14-DEC-04

starting media recovery

released channel: d1
released channel: aux1
released channel: aux2
released channel: aux3
RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00569: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D ERROR MESSAGE = STACK FOLLOWS =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-00571: =


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D

RMAN-03002: failure of Duplicate Db command at 12/14/2004 15:47:36
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 7166 scn 543676542 found to=20

restore

--
http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 15 2004 - 09:53:08 CST