Hot Backup - is this ok - multiple start / stop backup of a tablespace

I found a very straightforward script to do hot backups and I'd like to use it.  The only part that I'm wondering about is that if I have 5 files in a tablespace, it does 5 begin / end backups for the same tablespace.  Any risk in this ?

Example:

alter tablespace INDX_101_TPTRZ begin backup;
host copy /data/test1/indx_101_tptrz_01.dbf /backup/DAY-1/test1/ >> /temp/hotbackup.log
alter tablespace INDX_101_TPTRZ end backup;

alter tablespace INDX_101_TPTRZ begin backup;
host copy /data/test1/indx_101_tptrz_02.dbf /backup/DAY-1/test1/ >> /temp/hotbackup.log
alter tablespace INDX_101_TPTRZ end backup;

alter tablespace INDX_101_TPTRZ begin backup;
host copy /data/test1/indx_101_tptrz_03.dbf /backup/DAY-1/test1/ >> /temp/hotbackup.log
alter tablespace INDX_101_TPTRZ end backup;

alter tablespace INDX_101_TPTRZ begin backup;
host copy /data/test1/indx_101_tptrz_04.dbf /backup/DAY-1/test1/ >> /temp/hotbackup.log
alter tablespace INDX_101_TPTRZ end backup;

alter tablespace INDX_101_TPTRZ begin backup;
host copy /data/test1/indx_101_tptrz_05.dbf /backup/DAY-1/test1/ >> /temp/hotbackup.log
alter tablespace INDX_101_TPTRZ end backup;

Thanks in advance
MTL999Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
No risk but also no real gain.  I would reduce it to one.  begin backup, copy ALL datafiles, end backup.
0
 
BajwaConnect With a Mentor Commented:
and if you want to backup the whole database  and your DB is greater or equal to 10g do this

1. alter database begin backup
2. copy all the files and archived logs.
3. alter database end backup
0
 
slightwv (䄆 Netminder) Commented:
I would suggest not placing the whole database in backup mode at once.  This will likely generate a lot of unecessary redo.

Now if the tablespace in question contains MOST of the database, then it probalby won't matter.
0
 
BajwaCommented:
and you can also see the status of the backup by running

select file#,status from v$backup;

status of 'NOT ACTIVE' means datafile is not in a BACKUP MODE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.