RE: RMAN restore times

Thanks for your feedback.

Yes, my main hesitation with the RMAN backups for such a large database was the restore times.

Why would a 4 GB file take 4 hours to restore? Contention for tape resources? Really slow tape drives, network?

Thanks!
-----Original Message-----

From: Lora Martin [mailto:lmartin_at_clubmom.com] Sent: Thursday, August 04, 2005 10:01 AM To: Khemmanivanh, Somckit; oracle-l_at_freelists.org Subject: RE: RMAN restore times

If you have BCV - I would use that. I have used EMC BCV... very fast... then go to tape from there. When we restored 4GB file using RMAN from tape on a 2TB system - the restore took 4 hrs

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Thursday, August 04, 2005 12:50 PM To: oracle-l_at_freelists.org
Subject: RMAN restore times  

Hi,

I've been trying to understand the restore times associated with RMAN backups. The Oracle version is 9205.

My question is this, with a Full, multiple Incremental(s) and archivelogs to restore how are the RMAN restore times compared to scripted on disk based backups?

Anyone here use EMC BCVs for backup? Would you consider RMAN for a production backup/restore if you had BCV technology available to you?

Would you run the RMAN backup to the BCV first, then back up the BCV to tape at your leisure? The BCV will still be available on disk for fast restore times.

How long would a 1 TB RMAN backup take to restore? Would I need massive tape drive capacity/speed to see decent restore times?

Thoughts?

Thanks for you input.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 04 2005 - 12:23:18 CDT