-------------正常备份

[oracle@localhost backup]$ pwd
/oracle/backup
[oracle@localhost backup]$ echo $ORACLE_HOME
/oracle/product/11.1.0/db_1
[oracle@localhost backup]$ echo $ORACLE_SID
orclasm
[oracle@localhost backup]$ cat backup.sh
export ORACLE_HOME=/oracle/product/11.1.0/db_1
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
export ORACLE_SID=orclasm
$ORACLE_HOME/bin/rman target / nocatalog cmdfile=/oracle/backup/rman.sql
log=/oracle/backup/rman.log append
[oracle@localhost backup]$ cat rman.sql
run {
BACKUP
    incremental level=0
    SKIP INACCESSIBLE
    FILESPERSET 10
    # recommended format
    FORMAT '/oracle/backup/diskdb0_T.%T_s.%s_d.%d'
    DATABASE;
sql 'alter system archive log current';
BACKUP
incremental level=0
   filesperset 200
   FORMAT '/oracle/backup/diskar0_T.%T_s.%s_d.%d'
   ARCHIVELOG ALL delete all input ;
BACKUP
    # recommended format
    FORMAT '/oracle/backup/diskctl0_T.%T_s.%s_d.%d'
    CURRENT CONTROLFILE;
sql "create pfile=''?/dbs/initorclasm.ora.bak'' from spfile";
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
restore database validate;
restore controlfile validate;
restore archivelog from time 'sysdate-1' until time 'sysdate' validate;
    }

[oracle@localhost backup]$

-------------------------增量备份

level=0 改成1

ITPub博客

11gedu_backup

最新文章