Oracle 10g Replication.

[Teresa_Nugent]

Do you have any suggestions? I have not done it before. I have a project that I need to do it. I have extensive knowledge in development in PL/SQL, and DB administration. What articles or books will assist me in learning the most efficient way to do it.

Thanks,

tnuge

[DavidParker]

Teresa,
If by 'replication' you mean backing up your Oracle DB with NetBackup, then you have a couple of options.

NetBackup features an Oracle Agent that integrates with RMAN and can be used to send db backups to tape on the fly.

You can also dump your db to a file and then initiate a file backup with a minor amount of scripting.

Can you elaborate more on your setup?
What version of NetBackup? What type of tapes/library? What OS's are involved?

[Teresa_Nugent]

The company is moving from Solaris to Linux and from Oracle 8i to 10g.

[DavidParker]

Sounds good.
How does this relate to NetBackup?

Are you going to backup the db and then restore it to the new server or something?

[Joseph_Correia]

Teresa,
David's post is accurate, if your talking about backing up your Oracle data Netbackup offers an agent option that simplifies the creation and management of templates that get used by RMAN to backup the Oracle data both online and offline. The Netbackup agent supports 8i through 10g so no worries there.
There is pretty extensive documentation that goes with the Netbackup product and will walk you through setting this up.Message was edited by:
Joseph Correia

[Dennis_Strom]

oracle database backups exports datapump
good thread
http://forums.symantec.com/discussions/thread.jspa?threadID=68448&tstart=0

[DavidParker]

Dennis, you just like saying 'datapump', don't you?

:)

[Dennis_Strom]

yup

[zippy]

tnuge,

Oracle replication should be addressed by your companies needs and or hardware software limitation.

Take a look at this pdf or html from Oracle web site.

http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10732/toc.htm

Using any replication tool requires hardware and a Good System Administrator that is knowledgeable in his or her field.

Cloning or BCV's replicate data as a 1 to 1 copy, brake the clone and mount it on a different mount, start the database (not recovery needed) and you now have an perfect replica of your production database.

SNAP or Snaps replicate data at a block level and only keep track of the changes, in the case of a database snap the data base must be copied and recovered and in some cases logs need to be applied.

Data pump ships with oracle
http://builder.com.com/5100-6388_14-5800445.html

RAC is super expensive, I know what the concept is but have not worked with it.

JD

[Teresa_Nugent]

Great Answers!! Thank you so much!!!