1 Reply Latest reply: Nov 30, 2012 2:09 PM by Niket Kumar RSS

    Rman Issue

    $phinx19
      Hi All,

      OS: Windows
      DB :10g Xpress

      While i am trying to backup my oracle database using rman :
      backup database plus archive log;

      the backup of my archives and datafiles is happening at the specifed location but th ebackup of my controlfile and redologfiles is happening in the FRA. Following is the config:
      RMAN> show all;
      RMAN configuration parameters are:
      CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
      CONFIGURE BACKUP OPTIMIZATION OFF; # default
      CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
      CONFIGURE CONTROLFILE AUTOBACKUP ON;
      CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
      CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
      CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
      CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\orahome_10g_xpress\oradata\XE_rman_bkp\rman_%d_%u';
      CONFIGURE MAXSETSIZE TO UNLIMITED; # default
      CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
      CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
      CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
      CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'F:\ORAHOME_10G_XPRESS\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA'; # default
      and below is the o/p of list backup

      RMAN> list backup;


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

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      1 Full 646.13M DISK 00:01:11 01-DEC-12
      BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20121201T003830
      Piece Name: F:\ORAHOME_10G_XPRESS\ORADATA\XE_RMAN_BKP\RMAN_XE_01NRNQ46
      List of Datafiles in backup set 1
      File LV Type Ckp SCN Ckp Time Name
      ---- -- ---- ---------- --------- ----
      1 Full 253307 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\SYSTEM.DBF
      2 Full 253307 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\UNDO.DBF
      3 Full 253307 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\SYSAUX.DBF
      4 Full 253307 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\USERS.DBF

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      2 Full 6.77M DISK 00:00:02 01-DEC-12
      BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20121201T003946
      Piece Name: F:\ORAHOME_10G_XPRESS\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2012_12_01\O1_MF_N_800843986_8CL13VVV_.BKP
      Control File Included: Ckp SCN: 253336 Ckp time: 01-DEC-12

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      3 38.86M DISK 00:00:05 01-DEC-12
      BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20121201T004327
      Piece Name: F:\ORAHOME_10G_XPRESS\ORADATA\XE_RMAN_BKP\RMAN_XE_03NRNQDG

      List of Archived Logs in backup set 3
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 2 213573 30-NOV-12 219744 30-NOV-12
      1 3 219744 30-NOV-12 219747 30-NOV-12
      1 4 219747 30-NOV-12 219762 30-NOV-12
      1 5 219762 30-NOV-12 241017 30-NOV-12
      1 6 241017 30-NOV-12 253421 01-DEC-12

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      4 Full 646.13M DISK 00:01:10 01-DEC-12
      BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20121201T004337
      Piece Name: F:\ORAHOME_10G_XPRESS\ORADATA\XE_RMAN_BKP\RMAN_XE_04NRNQDP
      List of Datafiles in backup set 4
      File LV Type Ckp SCN Ckp Time Name
      ---- -- ---- ---------- --------- ----
      1 Full 253428 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\SYSTEM.DBF
      2 Full 253428 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\UNDO.DBF
      3 Full 253428 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\SYSAUX.DBF
      4 Full 253428 01-DEC-12 F:\ORAHOME_10G_XPRESS\ORADATA\XE\USERS.DBF

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      5 2.00K DISK 00:00:02 01-DEC-12
      BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20121201T004453
      Piece Name: F:\ORAHOME_10G_XPRESS\ORADATA\XE_RMAN_BKP\RMAN_XE_05NRNQG5

      List of Archived Logs in backup set 5
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 7 253421 01-DEC-12 253456 01-DEC-12

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      6 Full 6.77M DISK 00:00:02 01-DEC-12
      BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20121201T004456
      Piece Name: F:\ORAHOME_10G_XPRESS\APP\ORACLE\FLASH_RECOVERY_AREA\XE\AUTOBACKUP\2012_12_01\O1_MF_N_800844296_8CL1FK8N_.BKP
      Control File Included: Ckp SCN: 253462 Ckp time: 01-DEC-12

      Need your inputs

      BR
      Sphinx
        • 1. Re: Rman Issue
          Niket Kumar
          REDO log files are not backed up by rman backup.

          RMAN>BACKUP CURRENT CONTROLFILE format 'C:\control.bak';

          choose any address for control file in format.

          your autobackup of control file and spfile is on so control file and spfile are always backed up with every backup taken by rman.