Oracle FS works concurrently with another Oracle FS issue

[Mohd Azril Dollah]

Hi Team,
Here's the bdf cmd for my server
$ bdf
Filesystem kbytes used avail %used Mounted on
/dev/vg00/lvol3 204800 141856 62832 69% /
/dev/vg00/lvol1 298928 153008 116024 57% /stand
/dev/vg00/lvol8 4710400 870392 3816800 19% /var
/dev/vg00/lvol7 2244608 1306984 930320 58% /usr
/dev/vg00/lvol4 204800 37552 166152 18% /tmp
/dev/vg00/lvol6 2727936 2418512 307048 89% /opt
/dev/vg00/lvol5 24576 2336 22072 10% /home
/dev/vg02/lvol1 46080000 26304376 19621184 57% /cramerdb
/dev/vg01/lvol2 16384000 12194220 4072546 75% /cramerapps
/dev/vg02/lvol2 24576000 18418256 6073876 75% /cramerapp1

as you can see, previously Oracle db 9i is located at /cramerapps mount point. I've inserted new hardisk and make a new LV with the mount point of /cramerapp1.
The reason is I want to migrate all the data in /cramerapps to a new FS which is /cramerapp1. The problem is, when i do cp from /cramerapps to /cramerapp1 - everything is fine.
So now there are 2 Oracle dir in my server. The problem is when I try to delete my current FS for Oracle, it also reflect the data in /cramerapp1 (newFS). How can I do the migration from /cramerapps to /cramerapp1 correctly?

[A. Clay Stephenson]

It's very easy. First I assume that when you did the copy the database was down and is still down. If that is not the case then shutdown the database and do the copy again making sure that you preserve ownerships and permissions. Next:
umount /cramerapps1
umount /cramerapps

Now edit /etc/fstab and reverse those two filesystem entries so that /cramerapps now uses /dev/vg02/lvol2. You then simply mount /cramerapps. Next do a bdf to make sure that the new LVOL is being used. You can now start the database. Note: No database (Oracle commands) changes are needed. After you are satified that Oracle is happy, you can remove the unused entry in /etc/fstab and remove the old LVOL.

[Mohd Azril Dollah]

I've successfully migrate the data from /cramerapps to /cramerapp1 according to ur suggestion. The problem is when i try to rm all the data(files) in /cramerapp1 the changes will reflect to the /cramerapps also. For example, in /cramerapp1 I create 1 file named as testing.delete. The file will also exist in /cramerapps mountpoint.
Then, when I try to delete the file, the changes (deletion) also occured (reflect) vise versa. I'm doing the deleteion during the database is running. Or do i need to shutdown the database first?

[A. Clay Stephenson]

What you are describing is simply not possible unless you have symbolically linked the the mountpoints. After the files are copied from one filesystem to the other -- again, with the database shutdown then there should be no connection between them.

[Mohd Azril Dollah]

I will try after shutting down the database. Anyway thanks for the help. Really appreciate it.

[Yogeeraj_1]

hi,

before you shutdown the database, verify that all your datafiles are in the new File system by running the following comamnd using sqlplus:

alter database backup controlfile to trace;


The trace file hereby generated (in your udump directory) which contains details about all the files being used by the database.


hope this helps too!
kind regards
yogeeraj