Hot Backups Question

Hey gurus
I have a question. I have a tablespace with 6 tablespaces. They are being backed up inthe
following way .
alter tablespace tablespace name begin backup; cp filenum1 to filenum1.back
alter tablespace tablespace name end backup;

alter tablespace tablespace name begin backup; cp filenum1 to filenum2.back
alter tablespace tablespace name end backup;

alter tablespace tablespace name begin backup; cp filenum1 to filenum3.back
alter tablespace tablespace name end backup;

alter tablespace tablespace name begin backup; cp filenum1 to filenum4.back
alter tablespace tablespace name end backup;

alter tablespace tablespace name begin backup; cp filenum1 to filenum5a.back
alter tablespace tablespace name end backup;

Can this be a problem in the backups being consistent ? Do y'all see any problem with this ?

Or should I go for the

alter tablespace tablespacename begin backup;

cp filenum1 to filenum1.bak
cp filenum2 to filenum2.bak
cp filenum3 to filenum3.bak
cp filenum4 to filenum4.bak
cp filenum5 to filenum5.bak

alter tablespace tablespacename end backup;

Is this a more preferred option ? If so why ?

Thanks a lot for the responses.
Any thoughts, outbursts, raves, rants, ideas will be appreciated.

Sent via Deja.com
http://www.deja.com/ Received on Sun Feb 04 2001 - 19:38:38 CST