- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Data Recovery
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
тАО04-30-2004 07:40 AM
тАО04-30-2004 07:40 AM
With Oracle you can import/Export to to recover data. And you can recreate a control file to let the database know the data is in another place after a media failure.
Here is my question. If some one deleted a mess of history data that the only copy was in the tablesspace you have backed up as datafile, Could you make Tablespace/Datafiles part of another database so you could extract the data?
Here is my thinking.
Create a small database.
Then create a new controlfile adding a datafile where the datafile you are adding belongs to a diffent database.
This way you could just write a script to copy that data to the orginal database with out having to disrup the production database.
Could you do that?
How?
Marty
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-30-2004 08:53 PM
тАО04-30-2004 08:53 PM
SolutionCKPT writes control information on the each of the datafile and the control file during the checkpoint.
The suggested way will not work under any condition.
Database recovery will work only if you have all/some data files + matching control file and archive & redo log files.
More post on this may clear further.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-01-2004 02:39 AM
тАО05-01-2004 02:39 AM
Re: Oracle Data Recovery
If you had known before hand that you were going to accidently delete data, then you could have recovered much long the lines you describe using "Transportable Tablespaces".
But then just maybe you would not have deleted it huh?
:-)
At this point you pretty much have no choice but to restore the entire database, either on a parallel system, or 'next to' the original one. (hopefully you room!). Startup (maybe changing file names / controlfile ). Export the missing data, shutdown, import in production database.
Hmmm... actually... you might get away with restoring control files, redo, system, the target data (and index). Any other tablespaces could be left un-restored and set offline (but that may be more hassle than it is worth).
Hey, consider it a good recover/restore practice!
I would encourage you to read up on transportable tablespaces. They are a neat tool to move data between database instances.
But you need a matedata export to be able to integrate the data defintions/layout with the datafile, and you do not have that dump now do you?
fwiw, I have used it to carry forward statspack data from experiment to experiment accross full DB restores. Many other possibilities!
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-02-2004 04:46 PM
тАО05-02-2004 04:46 PM
Re: Oracle Data Recovery
Yes there are possible ways of recovering the lost datafile if you have a backup.
One of the options would be:-
If the datafile that is lost is DATA or INDEX, then in your database Offline the tablespace the tablespace for which the datafile is lost and then start the database. Then restore from your previous backup to a separate location (preferrably on a DEV/TRAINING server) and start the database.
Then export the objects in the affected tablespace ( using User or table level export). Create the tablespace in the original database. Import the objects exported above.
Note: If the database is 8i or above, you can also use Transportable tablespace feature.
The other alternative is, if you have the datafile that was lost, system datafile and the redo logs backedup then you can restore only this datafile / tablespace into a different location (preferable a DEV/TRAINING SERVER) and get the data.
On the DEV/TRAINING server restore the redo logs, system datafile and the required datafile. On the original database backup controlfile to trace, as
Alter database backup controlfile to trace;
This command will create a trace file in the USER_DUMP directory. You will have to edit the file to remove the comment lines and also edit the lines where the datafiles are listed. Make sure you keep only the redo logs, system datafile and the datafile that you wanted recovered and save it as an sql file. Then logon to svrmgrl and execute this saved script. Then you can export the data from this database and import. This is silimar to the above option only thing you are not restoring the whole database, only restoring the datafile (will be handy when low disk space).
The third option will be, if your database is not mission critical and you can efford some down time, then you can backup the control file to trace. If your backedup datafile is not too old then, shutdown the database, and restore the missing datafile. And then try to startup the database. The databse will be mounted and ask for a media recovery for the datafile as
ORA-01113: file 7 needs media recovery
ORA-01110: data file
Then recover the datafile that you restored.
as svrmgrl> recover datafile 'name.dbf'
Then open the database.
Of all the three options 1 and 2 are a lot safer and better options.
I hope this helps.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2004 02:49 AM
тАО05-03-2004 02:49 AM
Re: Oracle Data Recovery
I just thought of another idea.
Could I take a backup controlfile and strip out the other datafiles and create a database then leave recovery off as the data I want to extract is in this datafile/Tablespace. Oh, did I tell you that the 2 datafiles only have one tablespace. And I am still on Oracle8 not 8i until next month.
I also have a Standby database that I could have pulled the lost data from if had cought it quicker. I have Archive logs and the datafile backups so I have not lost the data yet. I just cant get to it yet.
Here is an idea!
Since there ia only one tablespace I could reload the datafiles and recover tablespace.
I would have the old data and the new data.
Then after a full backup I could delete the right data.
In this case I should restore the datafiles for the tablespace tables and Indexes for this table.
What you think?
Marty
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-03-2004 03:27 PM
тАО05-03-2004 03:27 PM
Re: Oracle Data Recovery
Yes you could use any of those options depending on your requirement (hot soon you want the data and what down time you can efford) and the availability (how much disk space).
The idea of creating the controlfile to trace and striping the lines with the other datafiles is one of the options that I mentioned you you already.
The other idea that you have to recover the tablespace from the other databse and get the data is a safer and better option.
it does not matter how many datafiles you have, the tablespace can have one or more datafiles defined. The olny thing you cannot do is create a different database (different name) and then recover the datafile from the original datafile as the datafile header will carry the database name id.
You can follow any of the mentioned options.
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 12:25 AM
тАО05-04-2004 12:25 AM
Re: Oracle Data Recovery
I underall the options now.
Thanks for all your help.
Marty
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-04-2004 12:30 AM
тАО05-04-2004 12:30 AM
Re: Oracle Data Recovery
Please also have a look to this great link:
http://examples.oreilly.com/unixbr/oracle.html
hope this helps too!
best regards
yogeeraj