#hotbak1.bat~hotbak7.bat

set stamp=%date:~7,2%
cd d:\backup\hotbak\Mon
del CONTROLFILE.%stamp%.CTL
ren CONTROLFILE.CTL CONTROLFILE.%stamp%.CTL
sqlplus /nolog @D:\backup\script\onlinebackup1.sql

#onlinebackup1.sql~onlinebackup7.sql

conn sysem/pdmDB@wind as sysdba;
spool d:\backup\hotbak\Mon\Mon\pdm_online_backup.log;
alter system switch logfile;
host echo BACKUP CONTROLFILE
alter database backup controlfile to 'D:\backup\hotbak\Mon\controlfile.ctl';
alter database backup controlfile to trace;                                                 
host echo BACKUP SYSTEM   TABLESPACE        
alter tablespace SYSTEM begin backup;                                          
 host copy    e:\oradata\wind\system*.dbf d:\backup\hotbak\Mon                       
alter tablespace SYSTEM end backup;                                                         
host echo BACKUP UNDOTABS  TABLESPACE                                       
alter tablespace UNDOTBS1 begin backup;                                        
 host copy    e:\oradata\wind\undotb*.dbf d:\backup\hotbak\Mon
alter tablespace UNDOTBS1 end backup;                                                       
host echo BACKUP INDEX  TABLESPACE                                                      
alter tablespace INDX begin backup;                                            
 host copy    e:\oradata\wind\indx*.dbf d:\backup\hotbak\Mon     
alter tablespace INDX end backup;                                                           
host echo BACKUP TOOLS  TABLESPACE                                                       
alter tablespace TOOLS begin backup;                                           
 host copy    e:\oradata\wind\tool*.dbf d:\backup\hotbak\Mon                        
alter tablespace TOOLS end backup;                                                          
host echo BACKUP USERS  TABLESPACE               
alter tablespace USERS begin backup;                                           
 host copy    e:\oradata\wind\user*.dbf d:\backup\hotbak\Mon                                
alter tablespace USERS end backup;                                                          
host echo BACKUP BLOBS  TABLESPACE                                       
alter tablespace BLOBS begin backup;                                           
 host copy    e:\oradata\wind\BLOB*.dbf d:\backup\hotbak\Mon  
alter tablespace BLOBS end backup; 
alter system switch logfile;
spool off; 
exit