Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: NT disaster recovery for Oracle - your experiences

RE: NT disaster recovery for Oracle - your experiences

From: Khushalani, Vikram <vkhushalani_at_grci.com>
Date: Fri, 22 Sep 2000 09:15:41 -0400
Message-Id: <10627.117657@fatcity.com> 





Bruce,



Thanks for the note.



Yes one could certainly use oradim to create the sid and one could also use
regedit to edit a backed-up registry files. 



And if you chose to follow that approach you could use only the first
command you mentioned:



"oradim -new -sid abcd -intpwd thepwd -startmode auto -pfile
D:\oracle\admin\abcd\pfile\pfileABCD.ora "



You would not necessarily need the second command you mentioned:
"oradim -startup -sid abcd -starttype srvc,inst -usrpwd thepwd -pfile
D:\oracle\admin\abcd\pfile\pfileABCD.ora 



Since the first command will create your services, sid and the password
file.



Before you do that however you will need to have your INIT<SID>.ORA file
copied to the correct location.


The next step then would be to create/configure your listener.



If you created the Database instead, AND you did not already have an
instance on the new Server, the listener would be created for you during the
creation of the Database and you would not need to configure it. 



I was trying to keep it simpler and straight forward for anyone wanting to
use this approach and with fewer steps to worry about. Besides, the command
line ORADIM utility (on the NT Platform) does not return any success/failure
messages - this sometimes confuses those who are not familiar with it.  One
could also use the GUI version to create the instance.  There used to be one
which allowed you to create the sid only (without the database) on 7.3.x
which I believe was replaced with the 'Oracle Database Assistant' and which,
if I remember correctly, only allows for the creation of the database.



HTH 



Vikram Khushalani


Oracle DBA



-----Original Message-----


From: Reardon, Bruce (CALBBAY)


[mailto:Bruce.Reardon_at_comalco.riotinto.com.au]
Sent: Thursday, September 21, 2000 9:41 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: NT disaster recovery for Oracle - your experiences




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-----


Sent: Friday, 22 September 2000 1:41


To: Multiple recipients of list ORACLE-L




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:



    
  
  1.   Install Oracle Server(same version as the one for which you have your
backup).
  
  2.   Decide where you want your new databases datafiles to be and use this
information in the next step.
  
  3.   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.

  
    
  
  4.   Shutdown your new database, but 'do not stop' the Oracle related
services.
  
  5.   Copy (from your backup) ALL the datafiles to the new locations.
  
  6.   Edit your INIT<SID>.ORA file and change the entries 
   (where relevant) for locations for your CONTROL FILE,
   ROLLBACKS, TRACE FILES, etc. etc.)
  
  7.   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)
  
  8.   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.



    
  
  1.   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.



    
  
  1.   We are not done yet.  Now shutdown the database (normal) within the 
    SVRMGR and then restart the database.

  
  2.   Verify your data integrity, etc.

  
  3.   Before one goes live with this database one should take a backup.

  
  4.   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.




-- 
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


(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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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


Received on Fri Sep 22 2000 - 08:15:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US