Rman is running a long time
mDyJun 5 2008 — edited Jun 5 2008Hai all,
I have EBS 11.5.10.2 with DB 9i R2...My DB Size is 60 GB.. I used RMAN to take a full backup of my database..
so it started with ..
RMAN> backup database;
Starting backup at 05-JUN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=99 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00379 name=/d05/oracle/oratest/proddata/undo01.dbf
input datafile fno=00394 name=/d05/oracle/oratest/proddata/a_ref01.dbf
input datafile fno=00393 name=/d05/oracle/oratest/proddata/a_txn_ind01.dbf
input datafile fno=00400 name=/d05/oracle/oratest/proddata/a_media01.dbf
input datafile fno=00403 name=/d05/oracle/oratest/proddata/a_txn_ind02.dbf
input datafile fno=00404 name=/d05/oracle/oratest/proddata/a_txn_ind03.dbf
input datafile fno=00407 name=/d05/oracle/oratest/proddata/a_ref02.dbf
input datafile fno=00001 name=/d05/oracle/oratest/proddata/system01.dbf
input datafile fno=00002 name=/d05/oracle/oratest/proddata/system02.dbf
input datafile fno=00003 name=/d05/oracle/oratest/proddata/system03.dbf
input datafile fno=00004 name=/d05/oracle/oratest/proddata/system04.dbf
input datafile fno=00005 name=/d05/oracle/oratest/proddata/system05.dbf
input datafile fno=00012 name=/d05/oracle/oratest/proddata/a_txn_data04.dbf
input datafile fno=00288 name=/d05/oracle/oratest/proddata/system10.dbf
input datafile fno=00354 name=/d05/oracle/oratest/proddata/system11.dbf
input datafile fno=00392 name=/d05/oracle/oratest/proddata/a_txn_data01.dbf
input datafile fno=00395 name=/d05/oracle/oratest/proddata/a_int01.dbf
input datafile fno=00396 name=/d05/oracle/oratest/proddata/a_summ01.dbf
input datafile fno=00398 name=/d05/oracle/oratest/proddata/a_archive01.dbf
input datafile fno=00401 name=/d05/oracle/oratest/proddata/a_txn_data02.dbf
input datafile fno=00402 name=/d05/oracle/oratest/proddata/a_txn_data03.dbf
input datafile fno=00405 name=/d05/oracle/oratest/proddata/a_txn_ind04.dbf
input datafile fno=00406 name=/d05/oracle/oratest/proddata/a_txn_ind05.dbf
input datafile fno=00295 name=/d05/oracle/oratest/proddata/system06.dbf
input datafile fno=00351 name=/d05/oracle/oratest/proddata/system07.dbf
input datafile fno=00352 name=/d05/oracle/oratest/proddata/system09.dbf
input datafile fno=00353 name=/d05/oracle/oratest/proddata/system08.dbf
input datafile fno=00008 name=/d05/oracle/oratest/proddata/a_queue02.dbf
input datafile fno=00013 name=/d05/oracle/oratest/proddata/a_ts_tools01.dbf
input datafile fno=00014 name=/d05/oracle/oratest/proddata/rman.dbf
input datafile fno=00399 name=/d05/oracle/oratest/proddata/a_queue01.dbf
input datafile fno=00009 name=/d05/oracle/oratest/proddata/odm.dbf
input datafile fno=00010 name=/d05/oracle/oratest/proddata/olap.dbf
input datafile fno=00314 name=/d05/oracle/oratest/proddata/portal01.dbf
input datafile fno=00397 name=/d05/oracle/oratest/proddata/a_nolog01.dbf
input datafile fno=00011 name=/d05/oracle/oratest/proddata/xxail01.dbf
input datafile fno=00006 name=/d05/oracle/oratest/proddata/ctxd01.dbf
input datafile fno=00007 name=/d05/oracle/oratest/proddata/owad01.dbf
channel ORA_DISK_1: starting piece 1 at 05-JUN-08
and it hangs at this stage.. to know whether it is working properly.. I checked
select message from V$SESSION_LONGOPS
RMAN: aggregate input: backup 20: 81919 out of 128000 Blocks done
Table Scan: SYS.LOB$: 13111 out of 13111 Blocks done
RMAN: full datafile backup: Set Count 7: 119551 out of 128000 Blocks done
RMAN: full datafile backup: Set Count 7: 75136 out of 0 Blocks done
RMAN: aggregate input: backup 20: 3960320 out of 3960320 Blocks done
RMAN: aggregate output: backup 20: 1346816 out of 1346816 Blocks done
RMAN: aggregate output: backup 20: 1346816 out of 1346816 Blocks done
RMAN: aggregate input: backup 20: 1105336 out of 3960320 Blocks done
RMAN: aggregate output: backup 20: 824704 out of 0 Blocks done
RMAN: full datafile backup: Set Count 6: 1118328 out of 3960320 Blocks done
RMAN: full datafile backup: Set Count 6: 830720 out of 0 Blocks done
RMAN: aggregate output: backup 20: 75136 out of 0 Blocks done
and this count keeps increasing eveytime I execute the script.
Now, Shall I wait till this backup process finishes as am getting the increase in the no of blocks done. or shall I drop and run a new rman using debug option ?
any idea ?
Yusuf