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

Home -> Community -> Usenet -> c.d.o.server -> Re: Copy cold backup to another DB

Re: Copy cold backup to another DB

From: Papa Piquillo <oraclejva_at_yahoo.es>
Date: 14 Mar 2006 00:35:30 -0800
Message-ID: <1142325330.496833.64560@i39g2000cwa.googlegroups.com>


Carlos:
If the test database and the production database are in different hosts you can restore the cold backup on the host for test and you have a database identical to production for testing. The sid is the same on both hosts and you have to configure the tnsnames properly to access to them.
If the databases are in the same host you will need to recreate the instance and import. This can be easy made if your database is not very big.
Un saludo. Received on Tue Mar 14 2006 - 02:35:30 CST

Original text of this message

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