rman output

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?

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

Code:

---

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';

---

:rolleyes:
Then your script would look something like this:

Code:

---

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;

---

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.

Quote:

---

Originally Posted by BeefStu

...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.
;)

Quote:

---

Originally Posted by LKBrwn_DBA

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!!