- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Moving datafile
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
тАО08-18-2006 12:20 AM
тАО08-18-2006 12:20 AM
Moving datafile
could you please help me with the following:
As my actual datafile as corrupted blocks i wish to alter the tablespace replacing the actual datafile with an old one with less data.
Could be possible?
May i follow the following steps:
-alter tablespace offline
-alter database rename file
-alter tablespace online
may i rename the datafile with an mounted database?
Thansk in advance for any tips.
Regards,
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 12:30 AM
тАО08-18-2006 12:30 AM
Re: Moving datafile
Why not just down the database and overwrite with a recent cold backup.
Then you can apply archive logs if you have them to make your data as current as possible.
If its just one tablespace, depending on your data relationship, your replacement method may work. It really depends on key relationships between the tables.
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
тАО08-18-2006 12:38 AM
тАО08-18-2006 12:38 AM
Re: Moving datafile
So may I shutdown the db put it on open state and then replace the datafile?
For sure few blocks are corrupted into the tablespace and some indexes too.
After having replaced the datafile should i rebuild or analyse teh tablespace structure?
Thanks and sorry for my questions but i'm not an expert...
Thanks so much....
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 12:39 AM
тАО08-18-2006 12:39 AM
Re: Moving datafile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 12:49 AM
тАО08-18-2006 12:49 AM
Re: Moving datafile
the restored datafile has less data respect the corrupted one but it's identical as structure.
So I need to shutdown the db replace the datafile and the raise a startup?
Thanks...
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 12:57 AM
тАО08-18-2006 12:57 AM
Re: Moving datafile
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 01:12 AM
тАО08-18-2006 01:12 AM
Re: Moving datafile
but just the last question:
after having replaced the datafile with the restored one should i just restart the db?
I'm in the meanwhile readind documentation and they suggested to do a recover tablespace after teh startup, should I?
Regards,
Fabio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 01:38 AM
тАО08-18-2006 01:38 AM
Re: Moving datafile
with Oracle it is not just as easy as that!
You can't just replace the datafile like that. You may corrupt your database further!!!
At worst you will have to restore your whole database on another machine and do recovery using sqlcopy or export.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 01:44 AM
тАО08-18-2006 01:44 AM
Re: Moving datafile
What backup strategy to you have in place?
If you have a cold backup, you will have to do a full restore and recovery.
You should follow the steps as per the strict guidelines.
If this is something mission critical, it will be preferrable to contact oracle support!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-18-2006 01:45 AM
тАО08-18-2006 01:45 AM
Re: Moving datafile
so may i follow these instructions:
--ALTER TABLESPACE xxxx OFFLINE IMMEDIATE;
--cp
--RECOVER TABLESPACE xxxx
--ALTER TABLESPACE xxxx ONLINE;
Thanks so much.
Fabio