I admin several Oracle DB servers. Recently I have had to run backups by hand. I cannot backup one server though. When I do a "backup database" it will go quickly through the first three channels, and then hang on the fourth. This has happened repeatedly. And I have let run for hours, without completion. Eventually, I ctl c it.
It is configured for four channels and it is backing up to disk (nfs to a SAN), OS is Linux, database version is 11.1.0.7.0.
RMAN> backup database;
Starting backup at 22-JUN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=109 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=123 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=116 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=104 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00012 name=/u03/data/sid1/storedata07.dbf
input datafile file number=00016 name=/u03/data/sid1/storedata03.dbf
input datafile file number=00023 name=/u03/data/sid1/storedata11.dbf
input datafile file number=00024 name=/u03/data/sid1/storedata12.dbf
input datafile file number=00029 name=/u03/data/sid1/storedata17.dbf
input datafile file number=00027 name=/u03/data/sid1/storedata15.dbf
input datafile file number=00033 name=/u03/data/sid1/storedata21.dbf
input datafile file number=00004 name=/u03/data/sid1/users01.dbf
input datafile file number=00022 name=/u03/data/sid1/storeindex08.dbf
channel ORA_DISK_1: starting piece 1 at 22-JUN-11
channel ORA_DISK_2: starting compressed full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00009 name=/u03/data/sid1/storedata10.dbf
input datafile file number=00013 name=/u03/data/sid1/storedata06.dbf
input datafile file number=00017 name=/u03/data/sid1/storedata02.dbf
input datafile file number=00026 name=/u03/data/sid1/storedata14.dbf
input datafile file number=00032 name=/u03/data/sid1/storedata20.dbf
input datafile file number=00007 name=/u03/data/sid1/storeindex02.dbf
input datafile file number=00020 name=/u03/data/sid1/storeindex06.dbf
input datafile file number=00021 name=/u03/data/sid1/storeindex07.dbf
channel ORA_DISK_2: starting piece 1 at 22-JUN-11
channel ORA_DISK_3: starting compressed full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00011 name=/u03/data/sid1/storedata08.dbf
input datafile file number=00015 name=/u03/data/sid1/storedata04.dbf
input datafile file number=00002 name=/u03/data/sid1/undotbs01.dbf
input datafile file number=00025 name=/u03/data/sid1/storedata13.dbf
input datafile file number=00030 name=/u03/data/sid1/storedata18.dbf
input datafile file number=00005 name=/u03/data/sid1/storeindex04.dbf
input datafile file number=00008 name=/u03/data/sid1/storeindex01.dbf
channel ORA_DISK_3: starting piece 1 at 22-JUN-11
channel ORA_DISK_4: starting compressed full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00010 name=/u03/data/sid1/storedata09.dbf
input datafile file number=00014 name=/u03/data/sid1/storedata05.dbf
input datafile file number=00018 name=/u03/data/sid1/storedata01.dbf
input datafile file number=00028 name=/u03/data/sid1/storedata16.dbf
input datafile file number=00031 name=/u03/data/sid1/storedata19.dbf
input datafile file number=00006 name=/u03/data/sid1/storeindex03.dbf
input datafile file number=00019 name=/u03/data/sid1/storeindex05.dbf
input datafile file number=00001 name=/u03/data/sid1/system01.dbf
input datafile file number=00003 name=/u03/data/sid1/sysaux01.dbf
channel ORA_DISK_4: starting piece 1 at 22-JUN-11
user interrupt received
Finished backup at 22-JUN-11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03099: job cancelled at user request
I also tried running a backup on only one channel and it hung.
I am fairly new to RMAN and would appreciate any ideas on this.
Thanks
Edited by: user13716631 on Jun 23, 2011 10:37 AM