Re: More Rman q's

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Tue, 22 Jan 2002 09:31:50 -0800
Message-ID: <F001.003F74F4.20020122090037@fatcity.com>

You need to have the auxiliary database started nomount. All you need is the init.ora to do this. The duplicate will create the control, data, and redo log files.

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> nlzanen1_at_EY.NL 01/22/02 09:20AM >>>

Hi All,

Trying my first attempt to clone a database using rman and ending up with errors.

Situation:
TEST1 database = catalog Status=OPEN
TEST2 database= target database and to be cloned status= OPEN TEST3 database= future clone of TEST2 status = NOMOUNT (as per docs)

I have all sorts of backups (full, incremental level0,1&2 and datafile copy and controlfile copy) on disk.

I run the following script

*********************SCRIPT*********************************

rman <<EOF
connect target rman/rman_at_test2
connect catalog rman/rman_at_test1
connect auxiliary sys/rman_at_test3
run {
allocate auxiliary channel d1 type disk; allocate auxiliary channel d2 type disk; duplicate target database to test3;
}
EOF

*********************/SCRIPT*********************************

I set db_file_name_convert & log_file_name_convert in the initTEST3.ora file so no need to put in the script (yet).

Following the documentation this should have worked but I get following output.

****************************OUTPUT*******************************************

Recovery Manager: Release 8.1.7.2.0 - Production

RMAN>
RMAN-06005: connected to target database: TEST2 (DBID=535250382)

RMAN>
RMAN-06008: connected to recovery catalog database

RMAN>
RMAN-06020: connected to auxiliary database

RMAN> 2> 3> 4> 5>

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=11 devtype=DISK

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: d2
RMAN-08500: channel d2: sid=9 devtype=DISK

RMAN-03022: compiling command: Duplicate Db

RMAN-03027: printing stored script: Memory Script {

   set until scn 281474976710655;
   set newname for datafile 1 to
"/data/oracle8/TEST3/systemTEST3.dbf";
   set newname for datafile 2 to
"/data/oracle8/TEST3/rbsTEST3.ora";
   set newname for datafile 3 to
"/data/oracle8/TEST3/tempTEST3.ora";
   set newname for datafile 4 to
"/data/oracle8/TEST3/dataTEST3.ora";
   restore
   check readonly
   clone database
   ;
}
RMAN-03021: executing script: Memory Script

RMAN-03022: compiling command: set

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08019: channel d1: restoring datafile 00001
RMAN-08507: input datafilecopy recid=34 stamp=451836451

filename=/data/oracle8/BACKUP/systemTEST2.dbf RMAN-08509: destination for restore of datafile 00001: /data/oracle8/TEST3/systemTEST3.dbf

RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-08031: released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command:

IRESTORE

RMAN-07004: unhandled exception during command execution on channel d1
RMAN-10035: exception raised in RPC: ORA-01507: database not mounted
RMAN-10031: ORA-1507 occurred during call to

DBMS_BACKUP_RESTORE.COPYDATAFILECOPY

****************************/OUTPUT*******************************************

I don't understand why I should be getting the message about not mounted, since I can't even mount an non-existing database. and the documentation states that database should be in nomount phase.

Can anybody explain???

TIA Jack

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: 
  INET: nlzanen1_at_EY.NL 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jan 22 2002 - 11:31:50 CST