- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle FS works concurrently with another Orac...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 01:09 PM
тАО07-31-2006 01:09 PM
Oracle FS works concurrently with another Oracle FS issue
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 01:17 PM
тАО07-31-2006 01:17 PM
Re: Oracle FS works concurrently with another Oracle FS issue
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 01:43 PM
тАО07-31-2006 01:43 PM
Re: Oracle FS works concurrently with another Oracle FS issue
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 01:55 PM
тАО07-31-2006 01:55 PM
Re: Oracle FS works concurrently with another Oracle FS issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 02:14 PM
тАО07-31-2006 02:14 PM
Re: Oracle FS works concurrently with another Oracle FS issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2006 04:39 PM
тАО07-31-2006 04:39 PM
Re: Oracle FS works concurrently with another Oracle FS issue
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