1 Reply Latest reply: Apr 11, 2007 6:32 AM by 538744 RSS

    rman full backup시 파일이 2개씩 생성 됩니다.

    538744
      rman을 사용해서 cron으로 일요일 새벽마다 full backup 을 하고 있는데, 백업 볼륨 full 이 발생해서 로그를 살펴보니 아래와 같습니다.

      같은 사이즈, 같은 생성 시각의 파일들이 2개씩 생성 되었습니다.

      rman 백업에 별다른 작업을 하지 않았는데도 저렇게 결과가 나오니 어떻게 해야할지 감을 못잡겠습니다, 특히 아래 두껍게 표시한 줄은 로그도 좀 잘린것 같습니다.



      ■ rman full backup 수행 로그

      Recovery Manager: Release 8.1.6.0.0 - Production

      RMAN-06005: connected to target database: ORCL (DBID=1151661191)
      RMAN-06008: connected to recovery catalog database

      RMAN>
      RMAN-03021: executing script: full_backup

      RMAN-03022: compiling command: allocate
      RMAN-03023: executing command: allocate
      RMAN-08030: allocated channel: backup_loveme
      RMAN-08500: channel backup_loveme: sid=224 devtype=DISK

      RMAN-03022: compiling command: backup
      RMAN-03023: executing command: backup
      RMAN-08008: channel backup_loveme: starting incremental level 0 datafile backupset
      RMAN-08502: set_count=14779 set_stamp=619322468 creation_time=08-APR-07
      RMAN-08010: channel backup_loveme: specifying datafile(s) in backupset
      RMAN-08522: input datafile fno=00085 name=/sdisk02/data/ts01.dbf
      RMAN-08522: input datafile fno=00027 name=/sdisk01/data/ts02.dbf
      RMAN-08522: input datafile fno=00004 name=/sdisk01/data/temp01.dbf
      RMAN-08522: input datafile fno=00006 name=/sdisk01/data/indx01.dbf
      RMAN-08522: input datafile fno=00015 name=/sdisk01/data/ts03.dbf
      RMAN-08013: channel backup_loveme: piece 1 created
      RMAN-08503: piece handle=/sdisk03/backup/ff_driek734_14779_1 comment=NONE
      RMAN-08525: backup set complete, elapsed time: 00:11:55
      RMAN-08008: channel backup_loveme: starting incremental level 0 datafile backupset
      RMAN-08502: set_count=14781 set_stamp=619323184 creation_time=08-APR-07
      RMAN-080RMAN-08013: channel backup_loveme: piece 1 created
      RMAN-08503: piece handle=/sdisk03/backup/ff_dsiek734_14780_1 comment=NONE
      RMAN-08525: backup set complete, elapsed time: 00:11:55
      RMAN-08008: channel backup_loveme: starting incremental level 0 datafile backupset
      RMAN-08502: sRMAN-08013: channel backup_loveme: piece 1 created
      RMAN-08503: piece handle=/sdisk03/backup/ff_dtiek7pg_14781_1 comment=NONE
      RMAN-08525: backup set complete, elapsed time: 00:06:55
      RMAN-08008: channel backup_loveme: starting incremental level 0 datafile backupset
      RMAN-08502: set_count=14783 set_stamp=619323599 creation_time=08-APR-07
      RMAN-080RMAN-08013: channel backup_loveme: piece 1 created
      RMAN-08503: piece handle=/sdisk03/backup/ff_duiek7pg_14782_1 comment=NONE
      RMAN-08525: backup set complete, elapsed time: 00:06:55
      (후략...)


      ■ rman full backup 생성 파일

      ls -al /sdisk03/backup/*
      -rw-r----- 1 oracle dba 5780783616 4월 8 02:13 backup/ff_driek734_14779_1
      -rw-r----- 1 oracle dba 5780783616 4월 8 02:13 backup/ff_dsiek734_14780_1
      -rw-r----- 1 oracle dba 3423191552 4월 8 02:19 backup/ff_dtiek7pg_14781_1
      -rw-r----- 1 oracle dba 3423191552 4월 8 02:19 backup/ff_duiek7pg_14782_1
      (후략...)


      ■ RMAN> print script full_backup
      {
      allocate channel backup_loveme
      type disk
      format '/sdisk03/backup/ff_%u_%s_%p';
      backup
      incremental level=0
      ( database include current controlfile );
      }

      글 수정:
      발로차는새