Home » RDBMS Server » Server Administration » database clonnig (urgent)
database clonnig (urgent) [message #197008] Mon, 09 October 2006 09:21 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: database clonnig (urgent) [message #197022 is a reply to message #197008] Mon, 09 October 2006 10:39 Go to previous messageGo to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

Thanks for the reply

but for cold backup we must have same file sysem.. i mean to say location of datafiles in production db is in /d1 and in test db it is in /test mountpoint will it work?

second que.
if i'll user exp/imp, before doing imp to test db we need to drop all the users. but wat about sys and system

plz kindly suggest me
Thanks in advance
Re: database clonnig (urgent) [message #197025 is a reply to message #197022] Mon, 09 October 2006 10:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i mean to say location of datafiles in production db is
>> in /d1 and in test db it is in /test
Yes.
It will work. Just change the path in your controlfile (that you got from trace).
Just search the forum /artices/faq section.
There are nummerous examples.

>> if i'll user exp/imp, before doing imp to test db we need to
>> drop all the users. but wat about sys and system
DO NOT DROP SYS and SYSTEM ( any other default users).
If you are using special options like XML/XDB etc, do not touch them.
Carry only the users you want.
Search the forum.
Too many examples to quote.
Re: database clonnig (urgent) [message #197026 is a reply to message #197025] Mon, 09 October 2006 10:58 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just search!.
THere are tooo many examples around
http://www.google.com/search?complete=1&hl=en&q=oracle+clone+database&btnG=Google+Search
Previous Topic: how can i link two databases
Next Topic: Dropping datafile
Goto Forum:
  


Current Time: Mon Dec 05 06:39:53 CST 2016

Total time taken to generate the page: 0.04393 seconds