hi,
Friends and gurus,

i am a new to oracle i installed oracle 10g in RHEL5 running good.
i need to take backup of it to rebuild another server like replica in case of server crash.

What are the things to consider....?
i mean what folders to take backup how to rebuild step-by-step configuration.

Thanks In Advance.

jnreddy

Hi,

read RMAN Concept guide from Oracle website. It is NOT possible to backup an Oracle database by copying the folder containing the datafiles. In 10g you can do backup using database control website provided from Oracle database server software.

1 members found this post helpful.

Thanq mesiol i go through that thanks alot

Thanks In Advance
Jnreddy

There are situations where you can't run RMAN, or don't want to set it up, etc. Or maybe you just want the easy, if not most efficient way.

Assuming you installed your oracle binaries in /orabin;
are storing your transaction logs in /alog;
are storing your oracle databases in /oradb;
and your oracle scripts in /home/oracle

Shut down the DB, and tar them all up to whatever backup you're making, and copy /var/log/rpmpkgs there too.

Use the backup of rpmpkgs as a map of what to install on the new server, untar your backups. Start the DB. Smile.

Oracle really doesn't interact with the OS in the way postgresql or mysql do. No init scripts, no real packages. It makes life harder in some ways, but in this way, easier.

1 members found this post helpful.

Thanq kschmitt

i will try and let you know

Thanks In Advance
jnreddy