Home » RDBMS Server » Backup & Recovery » Oracle data Replication
Oracle data Replication [message #287652] Thu, 13 December 2007 01:14 Go to next message
deepak samal
Messages: 29
Registered: February 2005
Junior Member
Hi ,

I am working in Oracle 10g. I am new to DBA.
Requirment: I have a database in onsite ( some other place). i am connecting to that DB. Here the data retrieval is very very slow. so i want to replicate the same DB to my local. The db size is big.so i can not ask them to export the db and sent it to me. i want to replicate the same db here locally.
If also i dont have a system/sys password then also how can i perform this task.

thanks
deepak
Re: Oracle data Replication [message #287654 is a reply to message #287652] Thu, 13 December 2007 01:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>If also i dont have a system/sys password then also how can i >perform this task.
Ask your dba which know sys/system password.

Re: Oracle data Replication [message #287655 is a reply to message #287652] Thu, 13 December 2007 01:18 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Shut down the database and copy all the files (data files, password files,control files, spfiles ) to new location.

Take a backup of the source database and restore it in the new location( like perform diaster recovery).

You can use RMAN duplicate Database.
Re: Oracle data Replication [message #287657 is a reply to message #287655] Thu, 13 December 2007 01:21 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Arju,
It is possible to done above task without SYS password.

OP want replicate instead of duplicate.

Re: Oracle data Replication [message #287659 is a reply to message #287652] Thu, 13 December 2007 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have DBA privileges to set up replication then you simply can't.
If your performances problem comes from network and want a replication of live database then you can't.
If you want to replicate from time to time, then the best way is to use your source database backups and restore them locally or use transportable tablespaces if it is possible (see restrictions on documentation).

Regards
Michel
Re: Oracle data Replication [message #287662 is a reply to message #287652] Thu, 13 December 2007 01:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I am suspicious about his requirement. As he once said network is so so slow and again he said replicate , so I considered myself that he wanted to mean how he can get duplicate of database.
Re: Oracle data Replication [message #287666 is a reply to message #287662] Thu, 13 December 2007 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I agree with you Arju.
It seems to me OP only wants to faster query the same database/data.
So duplication seems a better way than replication.
Of course, it depends on the ratio "needed data"/"whole database".

Regards
Michel

[Updated on: Thu, 13 December 2007 01:30]

Report message to a moderator

Re: Oracle data Replication [message #287690 is a reply to message #287652] Thu, 13 December 2007 03:25 Go to previous messageGo to next message
deepak samal
Messages: 29
Registered: February 2005
Junior Member
Yes, I think i made my requirment complicated. Actually i want a duplicate schema rather than the whole databse.
Actually the server is in a different country itself. so i cant take a backup of the database locally ( also i dont have a system password). What i want is , to which schema i am connecting thru client , i want that schema in my local server.

thanks
deepak
Re: Oracle data Replication [message #287695 is a reply to message #287652] Thu, 13 December 2007 03:35 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I can suggest you to use network mode data pump import which seems to me best feet to your requirement.

You can also use transport tablespaces feature if your specified schema holds self contained tablespaces.
Re: Oracle data Replication [message #287700 is a reply to message #287690] Thu, 13 December 2007 03:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, investigate if network is not your problem, if you want a up to date database or only one refreshed from time to time and which frequency.
In addition, investigate if your query are appropriate ones that is don't return thousand and thousand rows.

Regards
Michel
Previous Topic: 10G backup scripts
Next Topic: rman backup cannot restore
Goto Forum:
  


Current Time: Sat Dec 03 00:57:39 CST 2016

Total time taken to generate the page: 0.11335 seconds