Oracle-L: RE: URGENT: Trying to duplicate database from cold backup

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 04 Aug 2003 15:14:27 -0800
Message-ID: <F001.005C8DE8.20030804151427@fatcity.com>

Dear Robert,

Wow, I get the best!!! Anyway, in this case I am trying to clone/duplicate an existing database to a new database. Therefore, I don't have an existing control file and when I have done this with same database name from Host A to Host B as part of the duplication command it basically recreates the control file. I have gotten that type of clone to work.

I have also gotten clones to work where I was on host A and wanted to clone database A to database B by copying from a shutdown database, editing the "backup controlfile to trace" file.

This case is different from either one above. In this case I am trying to use RMAN and one Host A take a backup of database A and restore it as database B all from the backup itself. This operation I have not been able to do so I wait for off-hours to do the second option listed above.

-----Original Message-----
Sent: Monday, August 04, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L auxi

Paula,

Try to mount the auxillary database manually, and see what error you get. That might help point you in the right direction in solving the problem. probably 70% of the time it's an issue with the configuration of the aux database (e.g. parameter set wrong, etc...). Manual startup will show you if that is the case most of the time.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 8/4/2003 5:14 PM

Hmmm.

Got Robert's book on 9i
This database and clone is in 8.1.7 hmmm.

-----Original Message-----
<mailto:DWILLIAMS_at_LIFETOUCH.COM> ]
Sent: Monday, August 04, 2003 5:49 PM
To: Multiple recipients of list ORACLE-L auxi

Paula - I was never able to get this working, but then I didn't have Robert
Freeman's book at that time. Do you have his book as a resource?

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, August 04, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L

I did.

-----Original Message-----
Sent: Monday, August 04, 2003 5:24 PM
To: Multiple recipients of list ORACLE-L

you need to : startup nomount pfile=xxx.ora

-----Original Message-----
Sent: Monday, August 04, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L

Guys,

When trying to duplicate database with this script

I have my auxiliary setup as new database, target setup as old database and
am using duplicate database command along with logfile command to create new
logfiles.

Get error:

RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not
mounte

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

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.net
--

Author: Freeman Robert - IL
INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

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

Author:
INET: Paula_Stankus_at_doh.state.fl.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: URGENT: Trying to duplicate database from cold backup - auxi