rman full backup script

admin

1. [oracle@raca2 13-Nov-23]$ cat RMAN_FULL_nohup.sh
   
2. #!/bin/bash
   
3. nohup /u01/app/oracle/product/19.0.0/db_1/bin/rman target / cmdfile=/u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/RMAN_FULL_raca2.rman | tee /u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/rmanlog.13-Nov-23.log  2>&1 &
   
4. [oracle@raca2 13-Nov-23]$ cat RMAN_FULL_raca2.rman
   
5. 
   
6. run {
   
7. allocate channel C1 type disk;
   
8. allocate channel C2 type disk;
   
9. BACKUP  FORMAT '/u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/%d_%I_%t_%s_%p' TAG='FULLBKP'
   
10. FILESPERSET 100 DATABASE include current controlfile PLUS ARCHIVELOG;
    
11. BACKUP  FORMAT '/u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/CONTROLFILE_%d_%I_%t_%s_%p.bkp' REUSE TAG='CONTROL_BKP' CURRENT CONTROLFILE;
    
12. SQL "ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS ''/u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/controlfile.trc'' REUSE";
    
13. SQL "CREATE PFILE=''/u01/app/oracle/rman/RMANBKP_raca2/13-Nov-23/initraca2.ora'' FROM SPFILE";
    
14. }
    

复制代码