online backup db

[230173]

Hi,

Is it necessary to backup the control files, logfiles and dat files?
This database is running in ARCHIVELOG mode.
I don't think it's necessary because i backup al the datafiles but...

If I need to backup them, please let me know how because I backup with a sql statement that selects al the datafiles(so no .log, .ctl or .dat files)

 

[carp]

Yes, backup your control files. You don't need to backup the redo log files; that's what Archiver is doing. And definitely backup your data files (which you say you are already doing).
While it's true that you can recreate a control file, it takes a while to do, it's easy to foul up, and it's just one more delay before you can get your database back online.

 

[dklloyd]

I'd carry out 2 types of control file backup
'alter database backup controlfile to '/path/Control_file_backup';
and a
'alter database backup controlfile to trace';
The first backs up the control file which can be copied to tape; the second creates a script (in .../admin/udump/ora_nnnnn.trc) that you can use to recreate the control file, plus you can actually read it for pathnames which is safer than an out of date config list you may have created once.
Check the backup & recovery guide for more info on how & when to use a trace file & backup control files.

dklloyd