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: need to recreate database

Re: need to recreate database

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Tue, 10 Jul 2001 12:37:49 -0700
Message-ID: <F001.0034637B.20010710125005@fatcity.com>

Lyuda,

My guess is that if your networking folks performed the "copy" for you and now all you have to do is get it up and running, you're probably better off starting over. If the database wasn't shutdown when the controlfiles were copied, you're hosed. I have no idea what you mean by copying the datafiles - if the whole thing was shut down when the copies were made, then why would you have to do an import/export? - the data is already there.

Let's suppose that the networking guys knew about Oracle, and had shut everything down before copying it (and copied) everything they needed to. Safest bet is to move all the stuff to someplace else on your server or another server, and follow this advice from Note #1080849.6 :

                                                                                       
        
                                                               1. Install the Oracle 
software  
                                                               on server B.  You 
cannot simply 
                                                               copy the orant folder 
to the    
                                                               new machine.  Registry 
entries  
                                                               must be modified, file  
        
                                                               dependencies between 
Oracle and 
                                                               the Operating system, 
and       
                                                               between multiple Oracle 
homes   
                                                               (if applicable) must be 
        
                                                               checked, services must 
be       
                                                               created, etc.           
        
                                                                                       
        
                                                               2. Shut down the 
instance on    
                                                               server A.               
        
                                                                                       
        
                                                               3. Move all the data 
files,     
                                                               redologs, archive logs, 
control 
                                                               files, listener.ora,    
        
                                                               tnsnames.ora, 
init<SID>.ora and 
                                                               config<SID>.ora to 
server B.    
                                                                                       
        
                                                               4. On server B, open a 
Command  
                                                               Window and execute the  
        
                                                               following command:      
        
                                                                                       
        
                                                                  oradim80 -new -sid 
sidname   
                                                               -intpwd password -pfile 
        
                                                               path_to_init_file 

-startmode
auto 5. Change the listener.ora to reflect server B's hostname. 6. Change all the tnsnames.ora files on the clients to reflect server B's hostname. 7. Restart the listener. 8. Edit the init<SID>.ora dna config<SID>.ora files to reflect the correct directory paths on server B for your control_file, background_dump_dest, user_dump_dest, etc. 9. Do a startup mount pfile =<location of pfile> . 10.Unless the full path to the directory where all your datafiles/logfiles/controlfiles are on server A is the same as the path on server B, you will have to now tell Oracle where to find your new files. You can either: --Use a series of ALTER DATABASE RENAME FILE commands to rename each file to its new location or --Recreate the controlfile to specify the new file paths/names. This method is easier if you have a LOT of files. 11.Startup the Database. If it tells you that recovery is necessary, issue the recover database command. Hope this helps, it's a lot easier on UNIX.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

                                                                                       
                       
                    lhoska_at_calibre                                                     
                       
                    sys.com              To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>  
                    Sent by:             cc:                                           
                       
                    root_at_fatcity.c       Subject:     need to recreate database        
                       
                    om                                                                 
                       
                                                                                       
                       
                                                                                       
                       
                    07/10/2001                                                         
                       
                    12:26 PM                                                           
                       
                    Please respond                                                     
                       
                    to ORACLE-L                                                        
                       
                                                                                       
                       
                                                                                       
                       




Hello,
I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all
datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way.
One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance.

Lyuda Hoska

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: lhoska_at_calibresys.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:
  INET: DBarbour_at_austin.isd.tenet.edu

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). Received on Tue Jul 10 2001 - 14:37:49 CDT

Original text of this message

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