Re: Backup of Oracle databases

Vijay,

Just doing this is not enough, you may want to backup the arch* files, and a copy of the current control file (they do get damaged also), also note online backups by their very use cause extra redo logs to be written, therefor if complete recovery is desired, after the backup the arch files produced while the backup is executing should also be backed up within the same set.

Hope this heps.

--
Vikram Goel                                
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:                              Motorola email: vgoel_at_pts.mot.com
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 
In article <4qpcjl$p9u_at_eccdb1.pms.ford.com>, Vijay Banda <vbanda_at_fldb1.fl.ford.com> writes:


>simon_at_openplus.co.uk (Simon Fawkes) wrote:


>>I need some information about backing up Oracle databases.  I want to

>>perform a file level backup of an oracle database whilst the database

>>

>>Simon Fawkes

>hI, Simon if you run the Database in ARCHIVE LOG mode, the users can 

>still access the database normally and you can do hot backup of all

>your datafiles..

>

>Try using          

>          Alter Tablespace Begin Backup ;         

>          Use Host command to copy the datafiles of the current table    

>          space;

>          Alter Tablespace end Backup;  

>  Repeat this for all tablespaces;

>

> Hope this helps to some extent.

> Vijay Kumar Banda

> Ford Motors.