Oracle 8i Backup & recovery

Posted on 2003-02-28
Medium Priority
Last Modified: 2011-10-03
I need some guide and knowledge in these scenarios of backup and recovery purposes:

(1) Loss of control file;
(2) Loss of a data file of system tablespace;
(3) Recover a lost data file from archive logs.

What are the steps in dealing with those situations.
Please guide. Thank you.
Question by:jazzup7
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 100 total points
ID: 8041347
I think you should take some time to read the RMAN guide, and play around with a test database (note: you should create a database, and put some batch files in place that stop the current test database, and replace them with a know good version, and start that version. This helps alot when you try to build some crash scenarios )

(1) This is done with RMAN:
-> back up this file "to trace" regulary. This can be done with RMAN: backup controlfile to trace
-> restore = either you take the controlfile in the trace folder, or ask RMAN to restore the controlfile.

(2) Again, with RMAN you restore and then recover the system tablespace. For this step, the database needs to be in NOMOUNT state, so RMAN can connect to the database, but in the same time write over any existing system tablespace files.

(3) 2 scenarios:
* you have a full backup (hot or cold) after the time the archivelog file has been generated -> all is fine.
* you don't have a full backup. Then, you can only recover to the point of the last archivelog file before the gap. This is why in case you loose an archivelog file, you should take a full backup ASAP.


Assisted Solution

iozturk earned 100 total points
ID: 8042927
First off all, you have to have a cold (or hot) backup of all datafiles, control files and redolog files in adition database must be running on archivelog mode.

1. If the control files are lost:
   i. shutdown db
   ii. copy control files from backup  to original location
in SVRMGRL or SQLPLUS (as sys or internal user)
   iii. startup mount
   iv. issue the command
        recover automatic database using backup controlfile;
        alter databse open;
Thats it!

2. If a datafile of the system tablespace lost:
   i. Shutdown db
   ii. copy the file from backup to original location
in SVRMGRL or SQLPLUS (as sys or internal user)
   iii. startup mount
   iv. recover automatic datafile 'your datafile';
       alter database open;

3. Same as 2.

Expert Comment

by:Tom Knowlton
ID: 9460519
No comment has been added lately (214 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: split points between angelIII http:#8041347 and iozturk http:#8042927

Please leave any comments here within 7 days.

-- Please DO NOT accept this comment as an answer ! --


EE Cleanup Volunteer

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question