With DR did use RMAN. Again:
(1) using RMAN worked fine from one host to another of same database
(2) using cold backup and editing backup controlfile worked fine for same host different database name
(3) using RMAN for duplicating one database to same host with different database name in Version 8.1.7.X seemed to require "until...."
-----Original Message-----
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 11:39 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
Paula - Okay, when you say you brought the database down, copied the files,
etc., I presume that had nothing to do with RMAN? You didn't mention RMAN in
that post, but your original post was all about RMAN.
-----Original Message-----
Sent: Tuesday, August 05, 2003 10:19 AM
To: Multiple recipients of list ORACLE-L
I have done DR just fine using the same database name and creating (with
links or otherwise) the same file system names. This was using a complete
backup to restore a database to the same host with a different name and the
bug alluded to using the "until....clause" I feel is the key. BTW, I just
waited till afterhours brought the database down, copied the file and cloned
the easy way.
-----Original Message-----
<mailto:[EMAIL PROTECTED]> ]
Sent: Tuesday, August 05, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
auxi
Paula - How is your duplication going? Well I hope. Are you basically trying
to perform a disaster recovery? That was basically what I was requested to
do. The statement was "imagine the computer room was taken out by
terrorists, and all you have are the tapes from the off-site storage. You
are provided another server, now recover the database". Is this anything
like what you are trying to do? As I recall, DUPLICATE wouldn't work because
it just copies the production database, not using the backup tape. With help
from a local consultant I accomplished that.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, August 04, 2003 6:14 PM
To: Multiple recipients of list ORACLE-L
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-----
< mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > ]
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.
RF
-----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:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <
mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > ]
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.
[EMAIL PROTECTED]
-----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
d
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
< http://www.orafaq.net <http://www.orafaq.net> < http://www.orafaq.net
<http://www.orafaq.net> > >
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< http://www.fatcity.com <http://www.fatcity.com> >
< http://www.fatcity.com <http://www.fatcity.com> < 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: [EMAIL PROTECTED] (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
<http://www.orafaq.net>
< http://www.orafaq.net <http://www.orafaq.net> >
--
Author: Freeman Robert - IL
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>
< 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: [EMAIL PROTECTED] (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
<http://www.orafaq.net>
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 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: [EMAIL PROTECTED] (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).