Oracle-L: RE: RMAN/Veritas guru request

From: Ron Yount <ronwy_at_swbell.net>
Date: Wed, 21 May 2003 19:17:02 -0800
Message-ID: <F001.0059F6A7.20030521191702@fatcity.com>

Joe,

We initially used this approach by making the change as suggested and halting backups at the time of the restore on the alternate host. The bottom line though, is unless your source database cannot be shutdown for a good old OS copy for purposes of database cloning, this is a much simpler solution than the rman duplicate approach.

We use standard cloning and then the new dbid utility in 9i or a procedure in 8i dbms??? (I can get this for you if you need it) to alter the dbid of the new database. (I have a document on this process if you would like it)

Of course cloning approaches are of no use if the new (auxiliary) database needs to be a copy of the original database at a previous PIT.

Regards,
-Ron-

ronwy_at_swbell.net (home)
ryount_at_erac.com (work)

-----Original Message-----

Sent: Wednesday, May 21, 2003 9:27 AM
To: Multiple recipients of list ORACLE-L

Ok i've been battling with RMAN and veritas for a few weeks. My question to the guru out there.

while cloning(duplicate database) with rman, it requires a "alternate client restore" since its being cloned to a different server.

the veritas docs on veritas support says you HAVE to change the client_name in the bp.conf file to say what the original client_name that did the backup via RMAN.

I've tried the altnames ordeal with no luck I had to change the client_name in the bp.conf file on the "auxiliary" database server, my problem with that is while the restore is happening all backups are now saying they belong to a different server.

Anyone got a decent workaround?

thanks, joe

PS: 9.2.0.3, AIX, latest version of veritas.

Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--

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

Author: Joseph S Testa
INET: jtesta_at_dmc-it.com

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

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

Author: Ron Yount
INET: ronwy_at_swbell.net

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