s about. ;)
>
> Jared
>
>
>
>
>
> DENNIS WILLIAMS <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/05/2003 03:29 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
>
Robert - What I've done over the years is tie the creation of test databases
to backup verification. The old issue of how can you trust your backups
unless you've done a recovery. It has seemed that I get a request to build a
test database at about the right interval to periodically verify the back
lto:[EMAIL PROTECTED] Sent: Monday, August 04,
2003 11:09 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: URGENT: Trying to duplicate database from cold
backup - auxi
This is the type of script I am using:
rman <connect target
rman/[EMAIL PROTECTED]co
PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
>> BTW, I just waited till afterhours brought the database down, copied
>
EMAIL PROTECTED]>
cc:
Subject:RE: URGENT: Trying to duplicate database from cold
backup - auxi
Robert - What I've done over the years is tie the creation of test
databases
to backup verification. The old issue of how can you trust your backups
unless you've
AMS <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/05/2003 02:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:RE: URGENT: Trying to duplicate database from
cold
backup - auxi
Robert
:59 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
Robert - What I've done over the years is tie the creation of test
databases
to
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate
database from cold backup - auxi
This
is the type of script I am using:
rman
<connect target rman/[EMAIL PROTECTED]connect catalog
rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run
{resync cat
>> BTW, I just waited till afterhours brought the database down, copied
>> the file and cloned the easy way.
I love RMAN, but truth be told, I still find the old manual method of
cloning a database to be easier somehow. Must be an old fogie.
RF
--
Please see the official ORACLE-L FAQ: http://
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
I am with ya.
-Original Message-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
Jared
Okay, I'll bite. What do you mean about a "separate project for
verifying
backups". It remin
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 pro
Paula - Now you've got my attention. Can you describe in more detail what
you mean by "editing backup controlfile". I use a backup controlfile to
create test databases / validate RMAN backups, so this sounds like something
I could use. Thanks.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, I
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
E-L
<[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from
cold backup - auxi
Robert - What I've done over the years is tie the creation of test
databases
to backup verification. The old issue of how can you trust your backups
unless you
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
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
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
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
: [EMAIL PROTECTED]
08/04/2003 02:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: URGENT: Trying to duplicate database from cold backup -
auxi
This is the type of script I am using:
rman
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
Robert,
Page
405+ of your 9i backup book looks like it is do to me using a backup control
file for this "duplication" and therefore must use the "set until".
H. Not to mention it just is faste
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
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
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 y
Paula - Look in the back, in Appendix C, at the end there is a page on
Duplication in Oracle8i.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message---
Sent: Monday, August 04, 2003 5:14 PM
To: Multiple recipients of list ORACLE-L
Hmmm.
Got Rob
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi
Hmmm.
Got Robert's book on 9i
This database and clone is in 8.1.7 hmmm.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 04, 2003 5:49 PM
To: Multiple recipien
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
Title: Message
I
did.
-Original Message-From: Anne Yu
[mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003 5:24
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
URGENT: Trying to duplicate database from cold backup -
auxi
you
need to : startup nomount
Title: Message
you
need to : startup nomount pfile=xxx.ora
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 4:09 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: URGENT: Trying to duplicate
database from cold
Title: Message
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 fro
Title: Message
This
is the type of script I am using:
rman
28 matches
Mail list logo