backup

[harpal]

I need to back-up the following files what would be the best way to do this within a script.

-- Control files
/m1/oracle/oradata/live/control01.ctl
/m2/oracle/oradata/live/control02.ctl
/oracle/oradata/live/control03.ctl

-- Redo Log files
/m1/oracle/oradata/live/redo01.log
/m1/oracle/oradata/live/redo02.log
/m1/oracle/oradata/live/redo03.log

-- Tablespace files
/m2/oracle/oradata/live/system01.dbf
/m2/oracle/oradata/live/rbs01.dbf
/m2/oracle/oradata/live/temp01.dbf
/r1/oracle/oradata/live/users01.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_archndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_ashndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_bspkndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_genndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_histndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_archdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_bspkdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_gendata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_s00_histdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_archndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_ashndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_bspkndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_genndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_histndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_archdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_ashdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_bspkdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_gendata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_m00_histdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_archndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_genndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_genndx_b.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_histndx_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_archdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_ashdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_bspkdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_gendata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_gendata_b.dbf
/r1/oracle/oradata/live/nsb/nsb_support_a.dbf
/r1/oracle/oradata/live/nsb/nsb_support_temp_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_histdata_a.dbf
/r1/oracle/oradata/live/nsb/mercatus/nsbme_l00_ashndx_1.dbf

thanks in advance

 

[bjverzal]

If they are in the same volume group, use "savevg". If not, try "tar".

Bill.

 

[aixqueen]

Doesn't the Oracle Database have to be down....? since the redo logs and the ctrl files are time stamped...and if you you don't maintain the datestamps across all of them,
you cannot restore?

Some use mirroring and break the mirror and back it up, some use the Oracle backup facilities. Some do exports of the system.

If your database is down, and it is the same volume group, yes, you can do savevg...
or any of the backups...The key is if the database is down, I think

 

[bjverzal]

The database does indede need to be down, unless you flag Oracle that a "Hot" backup is running.

Bill.