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

2003-08-14 Thread Tanel Poder 
Hi!

One of the fastest and most reliable ways to verify backups is to look into
the safe (or drawer) and check whether the tapes are still there. It doesn't
waste much IO bandwidth either, except a little in the path from your desk
to the location of tapes. Only very little CPU processing is needed,
especially when Async IO is available (= a junior DBA whom to send to
check). You can verify virtually terabytes of any backups in less than a
second using this proven method.

Ok, time to go to sleep now, it's 2:21 AM here...
Tanel.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 06, 2003 2:59 AM


> You heard him.
>
> Top men.
>
> ;)
>
>
> Verifying backups is something we do in our spare time, one
> of those skunk works projects we don't tell our bosses 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:
> 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 reminds me of the ending to the movie "Indiana Jones" - "we
> have a team of top experts working on that", you know, the scene where
> they're packing the ark away in an enormous warehouse.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -Original Message-
> Sent: Tuesday, August 05, 2003 5:19 PM
> To: Multiple recipients of list ORACLE-L
> auxi
>
>
> >  I would be interested how other sites that rely on RMAN handle this
> issue.
>
> I for one, don't use RMAN for that.  It's too much work.
>
> There's a separate project for verifying backups.
>
> The databases I'm called on to duplicate have lately been 400-500
> gigs, more than I want to pull from tape unless absolutely necesssary.
>
> It's much faster to plug two servers into a gigabit switch and
> copy the files across a private network at approx 100 gigabytes
> per hour.
>
> Jared
>
>
>
>
>
>
> DENNIS WILLIAMS <[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 - 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
> backup.
> It is nice to say that I would just periodically verify the backups, but
> like most DBAs, there is always a more pressing task.
>With RMAN, I assumed that I would continue this practice. It has been a
> pain, but I ended up with a method that works. The biggest problem is that
> when the test database is recovered, it initially has the same name as the
> production database, then I change the name.
>I would be interested how other sites that rely on RMAN handle this
> issue.
> also send the HELP command for other information (like subscribing).
>
>
>
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author:
>   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).
> -- 
> 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: [EMA

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

2003-08-14 Thread DENNIS WILLIAMS 
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 backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been a
pain, but I ended up with a method that works. The biggest problem is that
when the test database is recovered, it initially has the same name as the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, August 05, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
auxi


>> 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://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).
-- 
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).

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

2003-08-14 Thread Paula_Stankus 
Title: Message



Thanks 
for the confirmation - I really believe that was it as well!!  - please see 
my earlier e-mail.  

  -Original Message-From: Jack van Zanen 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 05, 2003 5:24 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  URGENT: Trying to duplicate database from cold backup - 
  auxi
  
  
  
  Hi Paula
   
  Another issue you may encounter is that duplicate in 
  8.1.7 may not work w/o a "set until" clause see bug 2329702
   
   
  Jack
   
   -Original 
  Message-From: [EMAIL PROTECTED] 
  [mailto:[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]connect catalog 
rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run 
{resync catalog;allocate auxiliary channel d1 type disk;allocate 
auxiliary channel d2 type disk;set newname for datafile 
'/data/oracle8/TEST2/systemTEST2.dbf' TO 
'/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile 
'/data/oracle8/TEST2/rbsTEST2.dbf' TO 
'/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile 
'/data/oracle8/TEST2/tempTEST2.dbf' TO 
'/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile 
'/data/oracle8/TEST2/dataTEST2.dbf' TO 
'/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch 
logfile';duplicate target database to 
test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 
1M,'/data/oracle8/TEST3/redoTEST302.log' size 
1M,'/data/oracle8/TEST3/redoTEST303.log' size 
1M;}EOF

  -Original Message-From: Stankus, Paula G 
  Sent: Monday, August 04, 2003 4:12 PMTo: 
  '[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate 
  database from cold backup - auxiliary database not mounted 
  error!!!
  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
  
 

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

2003-08-14 Thread Jared . Still 
No doubt about it, the old way is much easier.

I've had to do it often enough that I wrote some PL/SQL, SQL and Perl to 
more or less automate the generation of the scripts needed to mount
and unmount shares, copy files, generate the controlfile script and
open up the database.

Doing this with RMAN is prohibitively difficult. 

My reason for doing so was to get the experience needed to restore
an entire database to a new server should the old one fail, as it is
the same process.

Jared





Freeman Robert - IL <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
 08/05/2003 02:44 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 
>> 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://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

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

2003-08-14 Thread DENNIS WILLIAMS 
Jared
   Okay, I'll bite. What do you mean about a "separate project for verifying
backups". It reminds me of the ending to the movie "Indiana Jones" - "we
have a team of top experts working on that", you know, the scene where
they're packing the ark away in an enormous warehouse.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, August 05, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
auxi


>  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS <[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 - 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 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been a
pain, but I ended up with a method that works. The biggest problem is that
when the test database is recovered, it initially has the same name as the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
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).

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

2003-08-14 Thread Freeman Robert - IL 
We have top men working on that right now Mr. Jones.

Who? 

Top Men.

RF 

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

Jared
   Okay, I'll bite. What do you mean about a "separate project for
verifying
backups". It reminds me of the ending to the movie "Indiana Jones" - "we
have a team of top experts working on that", you know, the scene where
they're packing the ark away in an enormous warehouse.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, August 05, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
auxi


>  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS <[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 - 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 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been
a
pain, but I ended up with a method that works. The biggest problem is
that
when the test database is recovered, it initially has the same name as
the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).

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

2003-08-14 Thread Jared . Still 
>  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS <[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 - 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 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been a
pain, but I ended up with a method that works. The biggest problem is that
when the test database is recovered, it initially has the same name as the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

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

2003-08-14 Thread Jack van Zanen 
Title: Message






Hi Paula
 
Another issue you may encounter is that duplicate in 
8.1.7 may not work w/o a "set until" clause see bug 2329702
 
 
Jack
 
 -Original Message-From: 
[EMAIL PROTECTED] [mailto:[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]connect catalog 
  rman/[EMAIL PROTECTED]connect auxiliary sys/[EMAIL PROTECTED]run 
  {resync catalog;allocate auxiliary channel d1 type disk;allocate 
  auxiliary channel d2 type disk;set newname for datafile 
  '/data/oracle8/TEST2/systemTEST2.dbf' TO 
  '/data/oracle8/TEST3/systemTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/rbsTEST2.dbf' TO 
  '/data/oracle8/TEST3/rbsTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/tempTEST2.dbf' TO 
  '/data/oracle8/TEST3/tempTEST3.dbf';set newname for datafile 
  '/data/oracle8/TEST2/dataTEST2.dbf' TO 
  '/data/oracle8/TEST3/dataTEST3.dbf';sql 'alter system switch 
  logfile';duplicate target database to 
  test3LOGFILE'/data/oracle8/TEST3/redoTEST301.log' size 
  1M,'/data/oracle8/TEST3/redoTEST302.log' size 
  1M,'/data/oracle8/TEST3/redoTEST303.log' size 
  1M;}EOF
  
-Original Message-From: Stankus, Paula G 
Sent: Monday, August 04, 2003 4:12 PMTo: 
'[EMAIL PROTECTED]'Subject: RE: URGENT: Trying to duplicate 
database from cold backup - auxiliary database not mounted 
error!!!
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

   

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

2003-08-12 Thread Freeman Robert - IL 
>> 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://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).

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

2003-08-11 Thread Paula_Stankus 
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 database from cold backup -
auxi



>> 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://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).

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

2003-08-10 Thread Jared . Still 
You heard him.

Top men. 

;)


Verifying backups is something we do in our spare time, one
of those skunk works projects we don't tell our bosses 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: 
    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 reminds me of the ending to the movie "Indiana Jones" - "we
have a team of top experts working on that", you know, the scene where
they're packing the ark away in an enormous warehouse.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Tuesday, August 05, 2003 5:19 PM
To: Multiple recipients of list ORACLE-L
auxi


>  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS <[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 - 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 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been a
pain, but I ended up with a method that works. The biggest problem is that
when the test database is recovered, it initially has the same name as the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).

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

2003-08-08 Thread DENNIS WILLIAMS 
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- 
 ] 
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]  > ] 
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  >  
-- 
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: Freeman Robert - IL 
  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). 

-- 
Please see the official ORA

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

2003-08-06 Thread DENNIS WILLIAMS 
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, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Tuesday, August 05, 2003 11:29 AM
To: Multiple recipients of list ORACLE-L



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- 
 ] 
Sent: Tuesday, August 05, 2003 11:39 AM 
To: Multiple recipients of list ORACLE-L 
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 "untilclause" 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 recipient

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

2003-08-06 Thread DENNIS WILLIAMS 
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 "untilclause" 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- 
 ] 
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]  > ] 
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]  > > ] 
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
 > >  
-- 
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
 > >  
San Diego, California-- Mailing list and w

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

2003-08-05 Thread Freeman Robert - IL 
Yep, if I can just move the datafiles over gigabit link, thats what I will
do.

Otherwise I just do a restore and rename...

RF


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

>  I would be interested how other sites that rely on RMAN handle this 
issue.

I for one, don't use RMAN for that.  It's too much work.

There's a separate project for verifying backups. 

The databases I'm called on to duplicate have lately been 400-500
gigs, more than I want to pull from tape unless absolutely necesssary.

It's much faster to plug two servers into a gigabit switch and
copy the files across a private network at approx 100 gigabytes
per hour.

Jared






DENNIS WILLIAMS <[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 - 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 
backup.
It is nice to say that I would just periodically verify the backups, but
like most DBAs, there is always a more pressing task.
   With RMAN, I assumed that I would continue this practice. It has been
a
pain, but I ended up with a method that works. The biggest problem is
that
when the test database is recovered, it initially has the same name as
the
production database, then I change the name.
   I would be interested how other sites that rely on RMAN handle this
issue.
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).

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

2003-08-05 Thread Paula_Stankus 
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 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 "untilclause" 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

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

2003-08-05 Thread Paula_Stankus 
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 the bug alluded to using the "untilclause" 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-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 05, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
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]> ] 
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]> > ] 
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> >  
-- 
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> >  
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 wa

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

2003-08-04 Thread Jared . Still 
I posted a document a couple weeks ago that may be of help.

It includes netbackup stuff, but you can ignore that.

Jared

www.tinyurl.com/hu4r

or 

http://www.cybcon.com/~jkstill/Alternate%20Client%20Restore%20With%20Veritas%20NetBackup%20and%20Oracle%20RMAN.doc






[EMAIL PROTECTED]
Sent by: [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 <http://www.orafaq.net
-- 
Author: 
  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).

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

2003-08-04 Thread Paula_Stankus 
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 faster to clone from disk.  Thanks 
for your attention on this.  It is always nice to hear from you.  


  -Original Message-From: 
  [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003 
  7:14 PMTo: Multiple recipients of list ORACLE-LSubject: 
  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 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- From: 
  Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Monday, August 04, 2003 6:34 PM To: 
  Multiple recipients of list ORACLE-L Subject: RE: 
  URGENT: Trying to duplicate database from cold backup - 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]> ] 
  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>  
  -- 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: Freeman Robert - IL   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).

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

2003-08-04 Thread Paula_Stankus 
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 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-
From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 04, 2003 6:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
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]> ] 
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>  
-- 
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: Freeman Robert - IL
  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).

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

2003-08-04 Thread Freeman Robert - IL 
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- 
 ] 
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
  
-- 
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). 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  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).

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

2003-08-04 Thread DENNIS WILLIAMS 
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 Robert's book on 9i 
This database and clone is in 8.1.7 hmmm. 

-Original Message- 
 ] 
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
  
-- 
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). 

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

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

2003-08-04 Thread Paula_Stankus 
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 recipients of list ORACLE-L
Subject: RE: URGENT: Trying to duplicate database from cold backup -
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
-- 
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).

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

2003-08-04 Thread DENNIS WILLIAMS 
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
-- 
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).

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

2003-08-04 Thread Paula_Stankus 
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 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 backup - auxi
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

   

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

2003-08-04 Thread Anne Yu 
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 backup - auxi
  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
  
 

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

2003-08-04 Thread Paula_Stankus 
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 from auxiliary database: ORA-01507: database not 
mounte
d

   

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

2003-08-04 Thread Paula_Stankus 
Title: Message



This 
is the type of script I am using:
 
rman