Oracle-L: RE: RMAN backup/restore to disk on 600G

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Thu, 30 Jan 2003 10:25:19 -0800
Message-ID: <F001.0053F28B.20030130102519@fatcity.com>

Hi,

I have used 12 channels to backup 700GB database and writing to FOUR TAPES at the same time. I used to backed up in 4 1/2 hours. On EMC disk, restore was done in 8 hours.

                allocate channel c1 type 'SBT_TAPE';
                allocate channel c2 type 'SBT_TAPE';
                allocate channel c3 type 'SBT_TAPE';
                allocate channel c4 type 'SBT_TAPE';
                allocate channel c5 type 'SBT_TAPE';
                allocate channel c6 type 'SBT_TAPE';
                allocate channel c7 type 'SBT_TAPE';
                allocate channel c8 type 'SBT_TAPE';
                allocate channel c9 type 'SBT_TAPE';
                allocate channel c10 type 'SBT_TAPE';
                allocate channel c11 type 'SBT_TAPE';
                allocate channel c12 type 'SBT_TAPE';
                setlimit channel c1 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c2 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c3 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c4 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c5 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c6 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c7 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c8 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c9 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c10 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c11 kbytes 2097150 maxopenfiles 16 readrate 500;
                setlimit channel c12 kbytes 2097150 maxopenfiles 16 readrate 500;

Thanks
Muqthar Ahmed
DBA
-----Original Message-----
Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L SPEED? Hi,

I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database.

The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card.

IF anyone has done it...what speeds could you obtain with RMAN from Disk?

What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths.... anymore?)

Thanks,
Brian Spears

-----Original Message-----
Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L

OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright.

And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless.

Hmmmmm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day!

http://society.servebeer.com :)

Now back to your regularly schedule database problems...

Rich

Rich Jesse                              System/Database Administrator
rjesse_at_qtiworld.com                     Quad/Tech International, Sussex, WI

USA -----Original Message-----
[mailto:Charlie_Mengler_at_HomeDepot.com]
Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L

Hey,
I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work & likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour.

HAND!

                      "Koivu, Lisa"

                      <Lisa.Koivu_at_efair        To:       Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>             
                      field.com>               cc:

                      Sent by:                 Subject:  RE: "Take Care of
your DBAs"                                            
                      root_at_fatcity.com

 

 

                      01/29/2003 01:54

                      PM

                      Please respond to

                      ORACLE-L

I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :)

Most of the dba's I have met are not into physical activity and exercise.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Spears, Brian
INET: BSpears_at_Limitedbrands.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP