- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Splitting an Oracle Database "Hot" with EMC TimeFi...
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
тАО11-26-2003 01:52 AM
тАО11-26-2003 01:52 AM
1. I must set environmnet variables:
export SYMCLI_RDB_CONNECT="username/password@service"
export SYMCLI_RDB_TYPE=Oracle
export ORACLE_HOME=/u1001/app/oracle/product/9.2.0
export PATH=$PATH:$ORACLE_HOME/bin
What username do I use? "sys", "system", what? What "service" do I use? (This is the 9.2.0 Oracle.) (I can ask my Oracle DBA this question.)
2. Do I really need to "freeze" and "thaw" the database? If I'm in Backup Mode, all transactions are going to the Archive Logs anyway...
symioctl begin backup -type oracle
symioct freeze -type oracle
symmir -g dgname split -instant -noprompt symioctl thaw -type oracle symioctl end backup -type oracle
3. The "symioctl begin backup" has an "object" argument. But I want the whole database (every tablespace) to go into backup mode. Can I leave off the arguments and have the whole DB go into Backup Mode (every tablespace).
4. Does anyone have example scripts for splitting an Oracle Database "live" with symioctl?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 02:41 AM
тАО11-26-2003 02:41 AM
SolutionNow to answer your questions :
1. Yes you must set those environment variables . The dba is the person to ask . Serivce name is the TNS or TNS alias name of your instance . YOu use it if you plan to run the script remotley over the network.
2. Yes you need to freeze and thaw the databse if using symioctl . The other way is to use consistent splits with powerpath .
3.yes if the object name is skipped the entire database goes in backup mode .
4. We used consistent splits and symioctl . But the other side of consistent split is that when the split BCV is brought back up on the secondary host ,it had no record of a clean shutdown or backup , so the database will go into recovery mode . My DBA didn't like that so we moved to back to regular , stop databse and then split , type of thing .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2004 12:44 AM
тАО02-27-2004 12:44 AM
Re: Splitting an Oracle Database "Hot" with EMC TimeFinder/BCV "symioctl" command ?
Thanks
Al
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2004 01:10 AM
тАО02-27-2004 01:10 AM
Re: Splitting an Oracle Database "Hot" with EMC TimeFinder/BCV "symioctl" command ?
We use Oracle 8.1.7.4, and ID system to do the split, so I can't answer your question.
However, I do know that the ID priviledge scheme changed at Oracle 9, so you have to do something different. Our testing didn't get that far.
If you find out what to do, please let me know.
Also, the "alter database backup controlfile to trace;" changed too. It produces a "double" "trace" file. You have to pick out what you want.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2004 01:33 AM
тАО02-27-2004 01:33 AM
Re: Splitting an Oracle Database "Hot" with EMC TimeFinder/BCV "symioctl" command ?
WE have three lv's set up.
Down database
mount -F vxfs -o snapof=/dev/vg02/lvol4 /dev/vg02/lvol16 /oraback
three times to different containers for the three oracle fs's
Database back up.
Looks like we can get a good cold backup image in 45 seconds.
Thats pretty nice and cold always beats hot.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-27-2004 02:14 AM
тАО02-27-2004 02:14 AM
Re: Splitting an Oracle Database "Hot" with EMC TimeFinder/BCV "symioctl" command ?
Simon