-
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?
-
Channels also like a name...
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';
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;
Last edited by LKBrwn_DBA; 08-16-2010 at 10:22 AM.
Reason: Added script
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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.
-
It's all in the name...
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.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
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!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|