| database clonnig (urgent) [message #197008] |
Mon, 09 October 2006 09:21  |
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
|
Member |
|
|
hi friends.
we need to clone our production db to test db.test db is allready exists but it is very old. now we need to update test db to the current time
setup is like this
production : sun solaris 9,oracle 9i,
test: sun solaris 9,oracle9i
production db and test db are on different file system
production: datafiles are on /d1
logfiles and control files on /d2
test: everything is in /test mount poing
on both side db is in noarchivelog mode.
i m trying to use exp/imp but the db size is 27 gb so i think exp/imp wont workout
so how do i clone my db plz suggest me its realy urgent.
Thanks in advance
|
|
|
|
| Re: database clonnig (urgent) [message #197017 is a reply to message #197008] |
Mon, 09 October 2006 10:00  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
27 GB is nothing. I guess, a good portion of it would be indexes.
Export / Import will work.
Export the database.
Import only the tables. Import indexes seperately or
Recreate indexes in parallel (after you get the DDL).
STill if you are not comfortable, shutdown the production,just copy the files and use the traced control file (since both production and test are on same OS)
Search the forum for cold copy.
[Updated on: Mon, 09 October 2006 10:08] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
