• 【测试】通过RMAN联机全库备份,包括控制文件,归档日志文件,备份成功后,删除已备份的归档日志。


    RMAN是一个很方便很好用的备份,恢复,还原的一个工具,做这个小测试其实只有一个RMAN语句就完全解决了这么大的需求:

    RMAN> backup as backupset full database format '/u01/app/backup/db_%U.rmn' include current controlfile plus archivelog delete all input;
    
    
    Starting backup at 10-OCT-16
    
    current log archived
    
    using target database control file instead of recovery catalog
    
    allocated channel: ORA_DISK_1
    
    channel ORA_DISK_1: SID=143 device type=DISK
    
    channel ORA_DISK_1: starting archived log backup set
    
    channel ORA_DISK_1: specifying archived log(s) in backup set
    
    input archived log thread=1 sequence=11 RECID=6 STAMP=924895260
    
    channel ORA_DISK_1: starting piece 1 at 10-OCT-16
    
    channel ORA_DISK_1: finished piece 1 at 10-OCT-16
    
    piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/0bri1i0t_1_1 tag=TAG20161010T192101 comment=NONE
    
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
    channel ORA_DISK_1: deleting archived log(s)
    
    archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_11_924890639.dbf RECID=6 STAMP=924895260
    
    Finished backup at 10-OCT-16
    
     
    
    Starting backup at 10-OCT-16
    
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: starting full datafile backup set
    
    channel ORA_DISK_1: specifying datafile(s) in backup set
    
    input datafile file number=00001 name=/u01/app/oracle/oradata/ORA11GR2/system01.dbf
    
    input datafile file number=00002 name=/u01/app/oracle/oradata/ORA11GR2/sysaux01.dbf
    
    input datafile file number=00005 name=/u01/app/oracle/oradata/ORA11GR2/example01.dbf
    
    input datafile file number=00003 name=/u01/app/oracle/oradata/ORA11GR2/undotbs01.dbf
    
    input datafile file number=00004 name=/u01/app/oracle/oradata/ORA11GR2/users01.dbf
    
    channel ORA_DISK_1: starting piece 1 at 10-OCT-16
    
    channel ORA_DISK_1: finished piece 1 at 10-OCT-16
    
    piece handle=/u01/app/backup/db_0cri1i0v_1_1.rmn tag=TAG20161010T192103 comment=NONE
    
    channel ORA_DISK_1: backup set complete, elapsed time: 00:05:42
    
    channel ORA_DISK_1: starting full datafile backup set
    
    channel ORA_DISK_1: specifying datafile(s) in backup set
    
    including current control file in backup set
    
    including current SPFILE in backup set
    
    channel ORA_DISK_1: starting piece 1 at 10-OCT-16
    
    channel ORA_DISK_1: finished piece 1 at 10-OCT-16
    
    piece handle=/u01/app/backup/db_0dri1ibl_1_1.rmn tag=TAG20161010T192103 comment=NONE
    
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
    Finished backup at 10-OCT-16
    
     
    
    Starting backup at 10-OCT-16
    
    current log archived
    
    using channel ORA_DISK_1
    
    channel ORA_DISK_1: starting archived log backup set
    
    channel ORA_DISK_1: specifying archived log(s) in backup set
    
    input archived log thread=1 sequence=12 RECID=7 STAMP=924895610
    
    channel ORA_DISK_1: starting piece 1 at 10-OCT-16
    
    channel ORA_DISK_1: finished piece 1 at 10-OCT-16
    
    piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/0eri1ibq_1_1 tag=TAG20161010T192650 comment=NONE
    
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    
    channel ORA_DISK_1: deleting archived log(s)
    
    archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_12_924890639.dbf RECID=7 STAMP=924895610
    
    Finished backup at 10-OCT-16

    总结:

    RMAN> backup as backupset full database format '/u01/app/backup/db_%U.rmn' include current controlfile plus archivelog delete all input;

  • 相关阅读:
    S03E01 蓝牙操作
    GET与POST方法
    Http请求头与响应头
    HttpClient初步
    Http
    深度为H的满k叉树
    html5-css选择器
    html5-css的使用强制优先级
    html5-样式表的使用-初步
    html5-css的引入
  • 原文地址:https://www.cnblogs.com/tomatoes-/p/5947603.html
Copyright © 2020-2023  润新知