Re: Copying a database

You have two choices. You can copy a coldbackup or a hotbackup set of database files to your development server. If you're restoring a coldbackup and your disk mountpoints structure and $ORACLE_HOME environments are duplicated exactly in development, all you'll need to do is start up the database. If you're restoring from a hotbackup set, you'll need to perform recovery until all your SCN's are the same, at which point you can open the database resetlogs (recover database using backup controlfile until cancel; ). If your mountpoint structure is not the same in development as production, you'll need to rename all datafiles and logs prior to running recovery and/or opening the database ( alter database rename file '/oldpath/file.dbf' to '/newpath/file.dbf'; ) .

Have fun...

David Jordan
Certified Oracle DBA

You may or may not wish to refresh your development init.ora and config.ora files.

blair_at_pjm.com on 08/25/2000 03:48:12 PM

Please respond to ORACLE-L_at_fatcity.com

                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: David Jordan/HQ/PCS PrimeCo)                  
                                                              
                                                              
                                                              
 Subject: Copying a database                                  
                                                              

I need to copy a production database onto a development environment. The AIX environment is the same. I have installed Oracle onto the development AIX but not created an Oracle instance.

We decided to do this by restoring a backup of the production environment onto the development environment. What is my basic procedure for this? Specifically, do I have to create the Oracle instance first? Can I just copy all the files without having created an instance and just start it up?

tia,

..tom

--
Author:
  INET: blair_at_pjm.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).