| help confirm this procedure [message #155264] |
Fri, 13 January 2006 07:15 |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
hello
i need your help to confirm the following strategie to copy an oracle9i database :
On the old database create a text version of the controlfile: alter database backup controlfile to trace;
Go find the new trace file in the directory pointed to by the tunable user_dump_dest: show parameter user_dump_dest
The file will have 2 versions of 'create control file'. You want Set #1 NORESETLOGS. Delete the other set.
Use the Database Configuration Assistant (DBCA) to create a database with the same name as the one you're copying. It doesn't matter which template you use. This will set up the services and create the necessary registry entries.
After it's built, shut it down, delete all it's datafiles. Copy the old datafiles to their new location and edit the 'create control file' script above to point to the proper directory and execute the script to rebuild the control files.
Assuming everything went right, you should now have a copy of the old database.[/B]
wish i had a free server to test on,
thanks for your help over the above steps
regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
