Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Moving from Raw file system to Cooked

SOLVED
Go to solution
Mike Gangler
Occasional Visitor

Moving from Raw file system to Cooked

We are moving our oracle database and hardware from a raw file system to a cooked file system. What are the O/S steps ? Are there any references to read or look at to assist us in the move ? We need to preserve the data, hopefully no export / import will have to be done for the move !

Mike

 

 

P.S. This thread has been moved from Disk to HP-UX > databases. - Hp Forum moderator

Your not late, unless you show up
2 REPLIES
Leif Halvarsson_2
Honored Contributor

Re: Moving from Raw file system to Cooked

Hi,
Which Oracle version do you use. If Oracle 8/9, perhaps RMAN can be used as an alternative.
See the chapter "Create a duplicate database with Recovery manager" in the RMAN manual
Stuart Abramson_2
Honored Contributor
Solution

Re: Moving from Raw file system to Cooked

I have never done this, but here's what I think:

The internal format for mounted and raw file systems is COMPLETELY DIFFERENT.

You are going to have to:

1. build completely new mounted file systems the size and name you want:

/oracle/SID/oradata01
/oracle/SID/oradata02

pvcreate
mkdir
mknod
vgcreate
lvcreate
lvextend
newfs
mkdir mtpoint
vi /etc/fstab
mount -a

2. export all the raw data to exportfiles,
3. and then import the raw data into your new file systems.

You should expect:
Complete rebuild.
Hours of downtime.