Ana Sayfa Keşfet Yardım
Üye Ol Giriş Yap
neal
/
scripts
1
0
Çatalla 0
Dosyalar Sorunlar 0 Değişiklik İstekleri 0 Wiki
Dal: master
Dallar Biçim İmleri
scripts
/
LJCOPY
/
RMAN
/
SYSTST3_rman_cmds_DEBUG.rman

SYSTST3_rman_cmds_DEBUG.rman 1.1 KB
Kalıcı Bağlantı Geçmiş Ham

123456789101112131415161718192021222324 
  1. connect target / 
    2. 

  2. connect catalog rcatadm/RCATADM@RCAT
    3. 

  3. run {
    4. 

  4. sql 'alter session set optimizer_mode=RULE';
    5. 

  5. resync catalog;
    6. 

  6. sql 'ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=60 SCOPE=BOTH';
    7. 

  7. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    8. 

  8. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
    9. 

  9. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    10. 

  10. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
    11. 

  11. ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '+FRA';
    12. 

  12. ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '+FRA';
    13. 

  13. ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '+FRA';
    14. 

  14. ALLOCATE CHANNEL disk4 DEVICE TYPE DISK FORMAT '+FRA';
    15. 

  15. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_SYSTST3.f';
    16. 

  16. sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    17. 

  17. CROSSCHECK backup of database;
    18. 

  18. CROSSCHECK backup of controlfile;
    19. 

  19. CROSSCHECK backup of spfile;
    20. 

  20. CROSSCHECK backup of archivelog all;
    21. 

  21. BACKUP as compressed backupset SECTION SIZE 20G INCREMENTAL LEVEL 0 TAG='L0_SYSTST3_11042018T113529' DATABASE include current CONTROLFILE plus ARCHIVELOG;
    22. 

  22. DELETE FORCE NOPROMPT OBSOLETE;
    23. 

  23. }
    24. 

  24. exit
    25.