OraFAQ Forum: Backup & Recovery » Oracle data Replication

Home » RDBMS Server » Backup & Recovery » Oracle data Replication

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle data Replication [message #287652]

Thu, 13 December 2007 01:14

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

Report message to a moderator

Re: Oracle data Replication [message #287654 is a reply to message #287652]

Thu, 13 December 2007 01:17

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.

Report message to a moderator

Re: Oracle data Replication [message #287655 is a reply to message #287652]

Thu, 13 December 2007 01:18

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.

Report message to a moderator

Re: Oracle data Replication [message #287657 is a reply to message #287655]

Thu, 13 December 2007 01:21

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.

Report message to a moderator

Re: Oracle data Replication [message #287659 is a reply to message #287652]

Thu, 13 December 2007 01:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle data Replication [message #287662 is a reply to message #287652]

Thu, 13 December 2007 01:27

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.

Report message to a moderator

Re: Oracle data Replication [message #287666 is a reply to message #287662]

Thu, 13 December 2007 01:30

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: Oracle data Replication [message #287695 is a reply to message #287652]

Thu, 13 December 2007 03:35

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.

Report message to a moderator

Re: Oracle data Replication [message #287700 is a reply to message #287690]

Thu, 13 December 2007 03:43

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	10G backup scripts
Next Topic:	rman backup cannot restore

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:41:06 CST 2024