In this article you will be able to create a copy of your Oracle database that is in NOArchivelog Mode on another database server to be used as a test or developement area.
Note:
This article is used on Microsoft Windows Platform.
1- On the Source Database Server open SQLPLUS and connect with user SYS and shutdown the database
SQL> conn / as sysdba
SQL> SHUTDOWN IMMEDIATE
2- On the Destination Database Server install Oracle Software only
3- On the Destination Database Server create the same directory structure as Source Database Server
D:\>mkdir D:\oracle\product\10.2.0\admin\ORCL\bdump
D:\>mkdir D:\oracle\product\10.2.0\admin\ORCL\udump
D:\>mkdir D:\oracle\product\10.2.0\admin\ORCL\cdump
D:\>mkdir D:\oracle\product\10.2.0\admin\ORCL\pfile
D:\>mkdir D:\oracle\product\10.2.0\oradata\ORCL
4- On the Destination Database Server copy all datafiles,control files and Redo Log Files from Source Database.
D:\> XCOPY \\10.0.0.100\D$\oracle\product\10.2.0\oradata\ORCL\*.* D:\oracle\product\10.2.0\oradata\ORCL
5- Also copy spfile and password file from Source Database
6- Insure that all files exist in their correct locations
7- Edit network files
- LISTENER.ORA edit HOST string and change IP ADDRESS according to the current machine)
- TNSNAMES.ORA edit HOST string and change IP ADDRESS according to the current machine)
8- Create Oracle Service
D:\>ORADIM -NEW -SID ORCL
D:\>ORADIM -EDIT -SID ORCL -STARTMODE AUTO
9- Connect to the newly created Oracle Service and start the Instance
D:\>set ORACLE_SID=ORCL
D:\>sqlplus / as sysdba
SQL> STARTUP
Now the database is working fine on the new database server.
2 comments:
thank u for ur post.
i am doing cold cloning from no-archive log database from one server to another server with differenet database name and different file structure. when i am opening database with resetlogs option, it is showing error like " file 1 needs more recovery".
but checkpoints are same for all datafiles.
is it possible to do the above? or any alternative solution is there? kindly revert the same.
Dear Nagaraju,
Thank you for passing on my blog.
For this issue you have,as you are copying from database to another with different name and file structure I think you need to recreate the controlfile and recover the database.
Post a Comment