Re: Moving Oracle database data files from Veritas to a non-Veritas

From: <Steve.Gough_at_gocorp.com.au>
Date: Wed, 24 May 2000 08:05:32 +1000
Message-Id: <10506.106440@fatcity.com>

hi scott,

i've restored from an OPS an a Solaris cluster using Veritas raw devices to a single node system using UFS.

it worked ok but the restore was partially done using RMAN to put the datafiles back on the UFS system. i took the result at face value and never followed it any futher.

---

Steve Gough
Database Administrator
GOCORP
Ph: (07) 55792882
Fax:(07) 55792800

---

                                                                                                                
                    Scott Lockhart                                                                              
                    <sdlockhart_at_bigp        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
                    lanet.com>              cc:                                                                 
                    Sent by:                Subject:     Moving Oracle database data files from Veritas to a    
                    root_at_fatcity.com        non-Veritas                                                         
                                                                                                                
                                                                                                                
                    23/05/00 15:16                                                                              
                    Please respond                                                                              
                    to ORACLE-L                                                                                 
                                                                                                                
                                                                                                                

Lazy DBA List Mates,
I am building a test environment from our Production databases and plan to clone the databases from their hot backups. No biggie; just move the datafiles and archive logs, alter the controlfile, start up the database in nomount, and recover to a point-in-time with the archive logs. Piece of cake. :)

The only wrinkle is that the Production database contains a mixture of database datafiles in Veritas and standard UFS files. The Test environment is strictly "cooked" or UFS filesystems.

My UNIX Sys Admins assure me that these Veritas files will work on a UFS filesystem with no problems.

Does anyone have any experience taking database datafiles from Veritas and placing them on a straight UFS filesystem?

Thanks in advance,
Scott Lockhart
Sr. Oracle DBA
Nu Skin Enterprises
Provo, UT USA

--
Author: Scott Lockhart
  INET: sdlockhart_at_bigplanet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Tue May 23 2000 - 17:05:32 CDT