Hi List,
I am really facing a very tough situation since three days. Our datawarehouse db, oracle 9i (9205, 1.6TB) on HP-SUPERDOME got crashed due to the filesystem corrupt. Unfortunately, all the redo groups lost and I am left with only full restore from the last valid backup and open database with resetlog option. Backup has taken using VERITAS NETWORK MANAGER utility through rman, allocating 10 channels. While restoring the complete database, using VERITAS manager, allocating 10 channels, giving nighmares. When allocating 10 channels for recovery, only 7 of the session getting active state and the rest waiting for TAPE. The problem is that when one of the 7 sessions, finishes restoring the datafile, other active sessions, just hangs and stop at 96% completion. Its really strange why one channel finishes restore, other are just hanging and not doing further restoration. I have tried using single channel, but, the kb per second for this was just 5m, and I am afraid, it this is the case, its take ages to finish the 1.6TB restoration. Do any one had faced this kind of session? Your valuable advice on this would be greatly appreicated.
-- Best Regards, Syed Jaffar Hussain 8i,9i & 10g OCP DBA Banque Saudi Fransi, Saudi Arabia
I blog at :http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l