- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Move tablespace out of the db
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 02:31 AM
тАО11-26-2003 02:31 AM
is it possible to move the tablespace to a read only device (CD-ROM, DVD) and reput them online in case of need in few time?
I need to move out the db the archived data but in case of request, put them available in 24 hours.
Any other ideas/suggestions?
TIA,
Art
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 02:36 AM
тАО11-26-2003 02:36 AM
Re: Move tablespace out of the db
Form a UNIX standpoint, any file(s) or directory trees could be stored on on-line storage (discs - hdd/dasd, optical media - DVD/CDR) or near-line storage (optical media - CDROM/DVD, tapes or virtual tape subsystems).. so it is up to your application if they support such -- in your case Oracle. I believe it will work as you can bring a Tablespace online in R/O mode but as far as speed goes -- that is suspect...
You can try most certainly and let us know how it goes...
Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 02:39 AM
тАО11-26-2003 02:39 AM
Re: Move tablespace out of the db
Most people don't bother with this because disk has become pretty cheap over the years.
We have a tape library system that lets us take databases offline. We an either restore the, or with a hardware upgrade have the data come online automatically when the request comes through. Obviously a big database will take some time to lay down.
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
тАО11-26-2003 02:42 AM
тАО11-26-2003 02:42 AM
Re: Move tablespace out of the db
This allows you to switch tablespaces in and out of the database.
We use this (albeit not with CD-ROM) and it works fine.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 03:37 AM
тАО11-26-2003 03:37 AM
Re: Move tablespace out of the db
I see you gave Graham '3 points'. Now I don't care how many points you give any or all of us, but I hope you realize the importance of Graham's suggestion! Please re-read.
Transportable tablespaces are likely to be the ultimate solution for your problem.
Unlike just putting a tablespace (file) 'offline' in Oracle, you can actaully hook them up back to the origianl DB, or connect them to a different DB. Powerfull stuff.
Other replies comment on the (lack of) speed on CDrom/DVD. The way I read the original quesion one possibel usage is to use the optical media (or tape) to roll out to a mountpoint, use it (at disk speeds), and loose it when done.
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 03:45 AM
тАО11-26-2003 03:45 AM
Re: Move tablespace out of the db
This is teh reason why i assigned 3 point.
The suggestion is good, but not useful for me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-26-2003 02:36 PM
тАО11-26-2003 02:36 PM
Re: Move tablespace out of the db
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-28-2003 04:48 PM
тАО11-28-2003 04:48 PM
Re: Move tablespace out of the db
The procedure will be something like:
create tablespace tbs_lmt_medium
datafile '/tmp/tts_test1.dbf' size 2m reuse autoextend off
uniform size 256k
/
Tablespace created.
alter tablespace tbs_lmt_medium
add datafile '/tmp/tts_test2.dbf' size 2m reuse autoextend off
/
alter tablespace tbs_lmt_medium READ ONLY;
exp transport_tablespace=y tablespaces=tbs_lmt_medium
drop tablespace tbs_lmt_medium including contents;
mv /tmp/tts_test1.dbf /readonly/better_name1.dbf
mv /tmp/tts_test2.dbf /readonly/better_name2.dbf
imp transport_tablespace=y 'datafiles=(/readonly/better_name1.dbf,/readonly/better_name2.dbf)'
alter tablespace tbs_lmt_medium read write;
hope this helps too!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-28-2003 04:48 PM
тАО11-28-2003 04:48 PM
Re: Move tablespace out of the db
The procedure will be something like:
create tablespace tbs_lmt_medium
datafile '/tmp/tts_test1.dbf' size 2m reuse autoextend off
uniform size 256k
/
alter tablespace tbs_lmt_medium
add datafile '/tmp/tts_test2.dbf' size 2m reuse autoextend off
/
alter tablespace tbs_lmt_medium READ ONLY;
exp transport_tablespace=y tablespaces=tbs_lmt_medium
drop tablespace tbs_lmt_medium including contents;
mv /tmp/tts_test1.dbf /readonly/better_name1.dbf
mv /tmp/tts_test2.dbf /readonly/better_name2.dbf
imp transport_tablespace=y 'datafiles=(/readonly/better_name1.dbf,/readonly/better_name2.dbf)'
alter tablespace tbs_lmt_medium read write;
hope this helps too!
regards
Yogeeraj