rman output

[BeefStu]

I am using the following backup script (see below) but my output does not appear to be going to the directory specified '/oracle/backup/pri' but is being
placed in $ORACLE_HOME/dbs/

Can somebody tell me what the issue is? BTW, I am running Release 10.2.0.1.0


rman < connect target sys/sys@GOLD_PRI
connect catalog rman/rman@GOLD_CAT

crosscheck Backup;
crosscheck Archivelog All;
run {
SQL 'alter system switch logfile';

CONFIGUE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/pri/control_file_%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 3;

ALLOCATE CHANNEL t1 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

ALLOCATE CHANNEL t2 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

ALLOCATE CHANNEL t3 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%U';

BACKUP INCREMENTAL LEVEL 0 filesperset 2 DATABASE;
backup archivelog all delete input;

release channel t1;
release channel t2;
release channel t3;

}
delete noprompt obsolete;

EOF


RMAN> list backupset;


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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1818 Incr 0 26.81M DISK 00:00:25 15-AUG-10
BP Key: 1822 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
Piece Name: /oracle/10.2.0.1.0/dbs/12lldm71_1_1
List of Datafiles in backup set 1818
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 0 Incr 334107 15-AUG-10 /oracle/data/pri/sysaux01.dbf
8 0 Incr 334107 15-AUG-10 /oracle/data/pri/t3.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1819 Incr 0 113.71M DISK 00:00:25 15-AUG-10
BP Key: 1823 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
Piece Name: /oracle/10.2.0.1.0/dbs/13lldm71_1_1
List of Datafiles in backup set 1819
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 334108 15-AUG-10 /oracle/data/pri/system01.dbf
7 0 Incr 334108 15-AUG-10 /oracle/data/pri/t2.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1820 Incr 0 267.92M DISK 00:00:26 15-AUG-10
BP Key: 1824 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
Piece Name: /oracle/10.2.0.1.0/dbs/14lldm71_1_1
List of Datafiles in backup set 1820
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 0 Incr 334109 15-AUG-10 /oracle/data/pri/undotbs.dbf
6 0 Incr 334109 15-AUG-10 /oracle/data/pri/t1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1821 Incr 0 97.14M DISK 00:00:07 15-AUG-10
BP Key: 1825 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153144
Piece Name: /oracle/10.2.0.1.0/dbs/15lldm7r_1_1
List of Datafiles in backup set 1821
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 0 Incr 334118 15-AUG-10 /oracle/data/pri/pritable01.dbf
5 0 Incr 334118 15-AUG-10 /oracle/data/pri/priindex01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1851 Full 5.95M DISK 00:00:01 15-AUG-10
BP Key: 1854 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153222
Piece Name: /oracle/10.2.0.1.0/dbs/c-657688632-20100815-01
Control File Included: Ckp SCN: 334131 Ckp time: 15-AUG-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1912 2.10M DISK 00:00:02 15-AUG-10
BP Key: 1916 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
Piece Name: /oracle/10.2.0.1.0/dbs/19lldm8k_1_1

List of Archived Logs in backup set 1912
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 239 329107 15-AUG-10 334150 15-AUG-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1913 7.49M DISK 00:00:02 15-AUG-10
BP Key: 1917 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
Piece Name: /oracle/10.2.0.1.0/dbs/18lldm8k_1_1

List of Archived Logs in backup set 1913
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 236 317012 15-AUG-10 319005 15-AUG-10
1 237 319005 15-AUG-10 323443 15-AUG-10
1 238 323443 15-AUG-10 329107 15-AUG-10

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1914 7.94M DISK 00:00:03 15-AUG-10
BP Key: 1918 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153235
Piece Name: /oracle/10.2.0.1.0/dbs/17lldm8j_1_1

List of Archived Logs in backup set 1914
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 233 305265 14-AUG-10 309184 14-AUG-10
1 234 309184 14-AUG-10 314975 15-AUG-10
1 235 314975 15-AUG-10 317012 15-AUG-10

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1945 Full 5.95M DISK 00:00:01 15-AUG-10
BP Key: 1949 Status: AVAILABLE Compressed: NO Tag: TAG20100815T153243
Piece Name: /oracle/10.2.0.1.0/dbs/c-657688632-20100815-02
Control File Included: Ckp SCN: 334170 Ckp time: 15-AUG-10


Thanks in advance to all who answer this post?

[LKBrwn_DBA]

You may need to configure the parallel channels first, execute these commands ONCE, it' not necessary to execute every time you run the script:

CONFIGUE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup/pri/control_file_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
CONFIGURE CHANNEL 0 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/oracle/backup/pri/incr_level0_%d_%T_%s_%u';

Then your script would look something like this:

connect target sys/sys@GOLD_PRI
connect catalog rman/rman@GOLD_CAT

CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
RUN {
    SQL 'ALTER SYSTEM SWITCH LOGFILE';
    BACKUP INCREMENTAL LEVEL 0 
      FILESPERSET 2 DATABASE
      INCLUDE CURRENT CONTROLFILE
      PLUS ARCHIVELOG DELETE INPUT
    ;
}
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
EXIT;

[BeefStu]

Thanks for the response and I will give it a shot.

If I configure it for incr_level0...... what happens when I do an level 1 incr it will have the wrong name (incr_level0 instead of incr_level1). Hence, that is why I configured it in the script.

I guess I really dont need the prefix incr_level# since the ouput does show me what type of back it is.

[LKBrwn_DBA]

...Etc...
I guess I really dont need the prefix incr_level# since the ouput does show me what type of back it is.

Correct:
a) Use generic name in the format '/oracle/backup/pri/%d_%T_%s_%u',
b) You need two scripts anyway, one for lvl 0 and one for lvl 1,
c) You could attach a different "TAG" for each backup type,
d) If you need to know which backup is level 0 or 1, query the catalog.

[BeefStu]

Correct:
a) Use generic name in the format '/oracle/backup/pri/%d_%T_%s_%u',
b) You need two scripts anyway, one for lvl 0 and one for lvl 1,
c) You could attach a different "TAG" for each backup type,
d) If you need to know which backup is level 0 or 1, query the catalog.

Thanks it all worked out!!