| please confirm [message #155133] |
Thu, 12 January 2006 09:16  |
marwan.h
Messages: 24
Registered: December 2005
Location: bey
|
Junior Member |
|
|
hello
i need your help to confirm the following startegie 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 ytour help over the above steps
regards
|
|
|
|
|
|
|
|
|
|
| Re: please confirm [message #155338 is a reply to message #155144] |
Sat, 14 January 2006 00:37  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
|
I do not have a test environment to check your process.but I used rman once for this..you can try out both and test and then decide..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
