topic Re: Oracle backup in Operating System - Linux

Oracle backup

jaivinder — Wed, 19 Sep 2007 07:16:04 GMT

Hi Experts,

In my setup i have to take the backup of the Oracle volume group vg_rac.This vg is shared by the both node of the MCSG cluster and i want to backup this vg data using some HPUX command .Is it possible to backup the raw data and if possible please suggest the way.

Re: Oracle backup

Ivan Ferreira — Wed, 19 Sep 2007 07:32:13 GMT

The recommended way to backup oracle database is using RMAN. Ask your DBA to provide RMAN scripts to backup data.

Re: Oracle backup

jaivinder — Wed, 19 Sep 2007 07:41:54 GMT

I do not want to use RMAN and if i can use ignite or any other HPUX command.

Re: Oracle backup

Ivan Ferreira — Wed, 19 Sep 2007 08:01:45 GMT

The only command that can backup RAW data is "dd". But it's bad idea, again, you should be familiarized and use RMAN. Rman will provide consistent backup, incremental backups, archive logs handling, online backups, etc.

Re: Oracle backup

Oviwan — Wed, 19 Sep 2007 08:36:33 GMT

RMAN should be your choice. dd would work but is not consistent etc..

Re: Oracle backup

jaivinder — Wed, 19 Sep 2007 22:30:54 GMT

How to backup the oracle raw data with dd .Please specify the complete syntax. This is only for experimental check.

Re: Oracle backup

dirk dierickx — Thu, 20 Sep 2007 01:57:07 GMT

you can use dd, but be aware that you database should be offline for it to work.

well, with work i mean that you will otherwise end up with a corrupt filesystem or at least database on restore.