Overview of steps, detailed steps can be found in the Recovery Manager
User's Guide, Chapter 10 under "Performing Disaster Recovery".
1. Install Oracle software
2. Restore password file, Init.ora and directory structures using os
backup or recreate them
3. Use oradim to create a service for the instance
4. You will need to have the dbid of the database. You can get this by
querying the recovery catalog.
5. Log into RMAN
6. Connect to the recovery catalog
7. Set the DBID
8. Start the database no mount
9. Restore the controlfile
10. Mount the database
11. Restore the database using backup controlfile option
12. Recover the database
13. Open the database reset logs
14. Backup the database
Jim Beveridge
EUR Systems
(717)697-6800 x333
Jim.[Email address protected]
www.eursystems.com
-----Original Message-----
From: Chandrasekhar Rao Dharmapurinagaraja
[mailto:oracledba-ezmlmshield-x53144807.[Email address protected]
Sent: Wednesday, May 31, 2006 11:05 AM
To: LazyDBA Discussion
Subject: RE: restore of a database
Hi,
We are doing the hot backup directly using rman and no third party tool
is involved.
We are using a rman repository and it is present on a different database
server.
There is no autobackup of controlfile.
Regards,
Chandra
-----Original Message-----
From: Marle R. van (Rudie) [mailto:r.van.[Email address protected]
Sent: Wednesday, May 31, 2006 8:29 PM
To: Chandrasekhar Rao Dharmapurinagaraja
Subject: RE: restore of a database
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Hi,
Are you using some kind of third party product to doe the hot backup
with
rman, or are you using just rman.
Are you using a rman repository, or are you using the controlfile ?
Have yu configured rman to autobackup the controlfile or haven't you
done
that ?
Regards,
Rudie
-----Oorspronkelijk bericht-----
Van: Chandrasekhar Rao Dharmapurinagaraja
[Email address protected]
Verzonden: woensdag 31 mei 2006 16:33
Aan: LazyDBA Discussion
Onderwerp: restore of a database
Hi,
We are on Oracle 9i & Windows 2003 server. We used to take a hot backup
of database regularly using the RMAN. Recently our disk failed and we
lost all the datafiles and oracle binaries.
My question is, after I install the oracle server on a new disk, How do
I restore the database. Can somebody give me the initial steps of this
restore?
Regards,
Chandra
Disclaimer:
This email and any files attached hereto are confidential and intended
for
the sole use of the individual or entity to
which they are addressed. If the reader of this message is not the
intended
recipient, you are hereby notified that any
unauthorized disclosure, dissemination, distribution, copying or the
taking
of any action in reliance on the information
herein is strictly prohibited. If you are not the intended recipient,
please
contact the sender and delete all copies.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Disclaimer:
This email and any files attached hereto are confidential and intended
for the sole use of the individual or entity to
which they are addressed. If the reader of this message is not the
intended recipient, you are hereby notified that any
unauthorized disclosure, dissemination, distribution, copying or the
taking of any action in reliance on the information
herein is strictly prohibited. If you are not the intended recipient,
please contact the sender and delete all copies.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page