RE: NT disaster recovery for Oracle

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Thu, 21 Sep 2000 22:17:37 -0000
Message-Id: <10626.117617@fatcity.com>

Hi Vikram,

Thanks for the detailed information.

If I understand correctly, in steps 3 & 4 you are effectively just creating the Oracle services for the database.
ie oracleserviceSID and in versions before 815 possibly the database start service.

These can be created using oradim (oradim80 in 805) rather than going through the whole process of creating a new database.
(Or you could just back up to a .reg file the relevant registry entries -
these will need to be edited if file locations change).

eg you could just do (commands for 815):

oradim -new -sid abcd -intpwd thepwd -startmode auto -pfile D:\oracle\admin\abcd\pfile\pfileABCD.ora oradim -startup -sid abcd -starttype srvc,inst -usrpwd thepwd -pfile D:\oracle\admin\abcd\pfile\pfileABCD.ora

Regards,
Bruce Reardon
mailto:bruce.reardon_at_comalco.riotinto.com.au

-----Original Message-----
From: Khushalani, Vikram [mailto:vkhushalani_at_grci.com] Sent: Friday, 22 September 2000 1:41
To: Multiple recipients of list ORACLE-L Subject: RE: NT disaster recovery for Oracle - your experiences

Sean,

We are facing a potentially similar situation.

Here is how we would approach it on an NT platform with a 'cold backup' of our lost system at hand:
(this is for versions 7.3.x --> 8i)

Portions of this have been tested. The part I have not tested yet is the renaming of the CONTROL FILE. Theoretically it should work, but I like to test everything.

Do a dry run first to ensure success.

On the New Server:

Install Oracle Server(same version as the one for which you have your backup).
Decide where you want your new databases datafiles to be and use this information in the next step.
Create a small Database with the Same Name as the lost DB
- Either using the GUI
- Or via scripts The purpose of this is to have the correct Registry entries and to have the correct Services created.
Shutdown your new database, but 'do not stop' the Oracle related services.
Copy (from your backup) ALL the datafiles to the new locations.
Edit your INIT<SID>.ORA file and change the entries (where relevant) for locations for your CONTROL FILE, ROLLBACKS, TRACE FILES, etc. etc.)
Open a 'Command Prompt' window and issue the SVRMGR23 (I think for your 7.3.x version) or SVRMG30 (for your 8.0.x version) or SVRMGRl (for your 8i versions) and 'connect internal/passxxx' (passxxx is your internal password)
Now you want to mount your database with a startup command but do not open the database yet. Then you will want to rename (for Oracle) your datafiles to new locations. Here is how-

SVRMGR> Startup mount pfile=d:\orant\database\initsid.ora Note- Replace 'd:\orant\database\initgd2k.ora' with where

your INIT<SID>.ORA file is.

       After the database is mounted (you should see
       'DATABASE MOUNTED.' from SVRMGR) you can start renaming
       the files (i.e. telling Oracle where they have been moved to).
       Remember this is done inside the SVRMGR since
       oracle needs to know where its files are (your datafiles 
       already exist physically at the new locations)

SVRMGR> Alter database rename file 'D:\orant\database\log1sid.ora' to 'e:\oradata\log1sid.ora'
Note- substitute your file names here

9) Do this for each file which is changing location.

Once all the files have been renamed you can open the database -

SVRMGR> Alter database open
Note- If things worked fine then the SVRMGR will just tell you

'Statement Processed' and you database is up.

We are not done yet. Now shutdown the database (normal) within the SVRMGR and then restart the database.
Verify your data integrity, etc.
Before one goes live with this database one should take a backup.
Make sure that you change any scripts you have (for cold backups, etc.) to reflect your new configuration.

Test-->Test--->and Test Again before implementing.

Forgive me if you know all the commands and the details are superfluous.

HTH
Vikram Khushalani
Oracle DBA

-----Original Message-----
Sent: Thursday, September 21, 2000 8:15 AM To: Multiple recipients of list ORACLE-L

Anyone out there care to share experiences of gotcha's and things to do learnt from experiences of recovering Oracle on NT platforms in disaster recovery situtations (simulated or real!) where original server has been "taken out" and differrent server with different disk arrangements etc. has had to be used for recovery purposes. So we are talking about NT being rebuilt, I know an NT admin issue and then Oracle software and data being restored from tape backups. I "suspect" NT registry may be an issue.

Sean :)

######   ######  ######  ###### 
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base 
#    #  #######  ######  #    #  Adminstrator
-------------------------------- ------------

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

The only man who never makes a mistake is the man who never does anything.

Theodore Roosevelt

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: Sean.ONeill_at_organon.ie

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Khushalani, Vikram
  INET: vkhushalani_at_grci.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

Received on Thu Sep 21 2000 - 17:17:37 CDT