5 Replies Latest reply: Nov 16, 2011 9:03 AM by L-MachineGun RSS

    RMAN image copies not generating

    885970
      Hi All,

      i have configured default backup type as image copes in below

      RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY
      2> ;

      old RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COPY;
      new RMAN configuration parameters:
      CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 2;
      new RMAN configuration parameters are successfully stored
      starting full resync of recovery catalog
      full resync complete

      still the backup is taking only backup sets not image copies

      Please advice how to get image copies instead of backup sets, below are the backup and list of copy backups

      RMAN> backup as copy database;

      Starting backup at 15-NOV-11
      using channel ORA_DISK_1
      using channel ORA_DISK_2
      channel ORA_DISK_1: starting datafile copy
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:47
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      continuing other job steps, job failed will not be re-run
      channel ORA_DISK_1: starting datafile copy
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      continuing other job steps, job failed will not be re-run
      channel ORA_DISK_1: starting datafile copy
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      continuing other job steps, job failed will not be re-run
      channel ORA_DISK_1: starting datafile copy
      copying current control file
      channel ORA_DISK_2: starting datafile copy
      RMAN-03009: failure of backup command on ORA_DISK_2 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      continuing other job steps, job failed will not be re-run
      channel ORA_DISK_2: starting datafile copy
      RMAN-03009: failure of backup command on ORA_DISK_2 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      continuing other job steps, job failed will not be re-run
      channel ORA_DISK_2: starting full datafile backup set
      channel ORA_DISK_2: specifying datafile(s) in backup set
      including current SPFILE in backup set
      channel ORA_DISK_2: starting piece 1 at 15-NOV-11
      output file name=/u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T145447_7d5jw867_.ctl tag=TAG20111115T145447 RECID=6 STAMP=767285688
      channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:00
      channel ORA_DISK_2: finished piece 1 at 15-NOV-11
      piece handle=/u01/app/oracle/flash_recovery_area/APPLE/backupset/2011_11_15/o1_mf_nnsnf_TAG20111115T145447_7d5jw8fq_.bkp tag=TAG20111115T145447 comment=NONE
      channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================

      RMAN-03009: failure of backup command on ORA_DISK_2 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:47
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      RMAN-03009: failure of backup command on ORA_DISK_2 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      RMAN-03009: failure of backup command on ORA_DISK_1 channel at 11/15/2011 14:54:48
      ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
      RMAN> list copy;

      specification does not match any datafile copy in the repository
      specification does not match any archived log in the repository
      List of Control File Copies
      ===========================

      Key S Completion Time Ckp SCN Ckp Time
      ------- - --------------- ---------- ---------------
      920 A 15-NOV-11 838639 15-NOV-11
      Name: /u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T145447_7d5jw867_.ctl
      Tag: TAG20111115T145447

      891 A 15-NOV-11 838154 15-NOV-11
      Name: /u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T144236_7d5j5f1d_.ctl
      Tag: TAG20111115T144236

      872 A 15-NOV-11 837188 15-NOV-11
      Name: /u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T141632_7d5gnjx5_.ctl
      Tag: TAG20111115T141632

      835 A 15-NOV-11 836343 15-NOV-11
      Name: /u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T140136_7d5frjxw_.ctl
      Tag: TAG20111115T140136

      794 A 15-NOV-11 835524 15-NOV-11
      Name: /u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111115T134712_7d5dxjpb_.ctl
      Tag: TAG20111115T134712

      Thanks in advance.

      Vara
        • 1. Re: RMAN image copies not generating
          LKBrwn_DBA
          >
          ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
          You need to shutdown the database and startup mount.
          :p
          • 2. Re: RMAN image copies not generating
            885970
            Is it mandatory, to be in mount status while taking RMAN image copies,
            My database is in Archive log mode.

            Regards.
            • 3. Re: RMAN image copies not generating
              19426
              cannot backup or copy active file in NOARCHIVELOG mode
              My database is in Archive log mode.

              RMAN does not confirm your statement.
              • 4. Re: RMAN image copies not generating
                885970
                Hi all,

                Can you please suggest now, there is no ora error for not being in archive log mode, and my db in archive log mode,
                and again i took a fresh backup of image copies,


                RMAN> show all;

                RMAN configuration parameters for database with db_unique_name APPLE are:
                CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
                CONFIGURE BACKUP OPTIMIZATION OFF; # default
                CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
                CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
                CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
                CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 2;
                CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
                CONFIGURE MAXSETSIZE TO UNLIMITED; # default
                CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
                CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
                CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
                CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
                CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/11.2.0/dbs/snapcf_APPLE.f'; # default
                RMAN> backup as copy database;

                Starting backup at 16-NOV-11
                using channel ORA_DISK_1
                using channel ORA_DISK_2
                channel ORA_DISK_1: starting datafile copy
                input datafile file number=00001 name=/u01/app/oracle/oradata/APPLE/system01.dbf
                channel ORA_DISK_2: starting datafile copy
                input datafile file number=00002 name=/u01/app/oracle/oradata/APPLE/sysaux01.dbf
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/datafile/o1_mf_sysaux_7d8djobx_.dbf tag=TAG20111116T165844 RECID=8 STAMP=767379556
                channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:35
                channel ORA_DISK_2: starting datafile copy
                input datafile file number=00005 name=/u01/app/oracle/oradata/APPLE/example01.dbf
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/datafile/o1_mf_system_7d8djnj8_.dbf tag=TAG20111116T165844 RECID=9 STAMP=767379570
                channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:51
                channel ORA_DISK_1: starting datafile copy
                input datafile file number=00003 name=/u01/app/oracle/oradata/APPLE/undotbs01.dbf
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/datafile/o1_mf_example_7d8dkrkx_.dbf tag=TAG20111116T165844 RECID=10 STAMP=767379571
                channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:15
                channel ORA_DISK_2: starting datafile copy
                copying current control file
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/datafile/o1_mf_undotbs1_7d8dl7v0_.dbf tag=TAG20111116T165844 RECID=12 STAMP=767379577
                channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:04
                channel ORA_DISK_1: starting datafile copy
                input datafile file number=00004 name=/u01/app/oracle/oradata/APPLE/users01.dbf
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/controlfile/o1_mf_TAG20111116T165844_7d8dl8ok_.ctl tag=TAG20111116T165844 RECID=11 STAMP=767379577
                channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:03
                channel ORA_DISK_2: starting full datafile backup set
                channel ORA_DISK_2: specifying datafile(s) in backup set
                including current SPFILE in backup set
                channel ORA_DISK_2: starting piece 1 at 16-NOV-11
                output file name=/u01/app/oracle/flash_recovery_area/APPLE/datafile/o1_mf_users_7d8dlckf_.dbf tag=TAG20111116T165844 RECID=13 STAMP=767379579
                channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
                channel ORA_DISK_2: finished piece 1 at 16-NOV-11
                piece handle=/u01/app/oracle/flash_recovery_area/APPLE/backupset/2011_11_16/o1_mf_nnsnf_TAG20111116T165844_7d8dlcqz_.bkp tag=TAG20111116T165844 comment=NONE
                channel ORA_DISK_2: backup set complete, elapsed time: 00:00:01
                Finished backup at 16-NOV-11

                RMAN> list backup;


                List of Backup Sets
                ===================


                BS Key Type LV Size Device Type Elapsed Time Completion Time
                ------- ---- -- ---------- ----------- ------------ ---------------
                958 Full 80.00K DISK 00:00:00 16-NOV-11
                BP Key: 959 Status: AVAILABLE Compressed: NO Tag: TAG20111116T165844
                Piece Name: /u01/app/oracle/flash_recovery_area/APPLE/backupset/2011_11_16/o1_mf_nnsnf_TAG20111116T165844_7d8dlcqz_.bkp
                SPFILE Included: Modification time: 16-NOV-11
                SPFILE db_unique_name: APPLE

                Regards,
                Vara
                • 5. Re: RMAN image copies not generating
                  L-MachineGun
                  Try:
                  RMAN> list copy;
                  :p