This discussion is archived
1 Reply Latest reply: Nov 30, 2012 12:09 PM by Niket Kumar RSS

Rman Issue

$phinx19 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points