Oracle-L: RE: RMAN - questions.. Rob Freeman?

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 06 Feb 2003 08:49:16 -0800
Message-ID: <F001.00545FE8.20030206084916@fatcity.com>

Thanks Dennis...

Ya.. its all on disk and problably only a test with some tuning is going to give me realistic picture. I am going to try it on NETAPPS new disaster recovery SAN solution

Brian Spears

-----Original Message-----
Sent: Wednesday, February 05, 2003 3:50 PM To: Multiple recipients of list ORACLE-L

Brian - Hopefully Robert will have a chance to respond to your question, but if I might make some suggestions, I think your recovery time has two components:

If the backup files are not on disk, the time to locate the tape, load the files.
RMAN recovery time. I think you will just have to perform some tests on your equipment. There are several tunable RMAN parameters that will make a great deal of difference (or not), depending on your hardware. There are many different types of recovery. Some recoveries may require very little data from RMAN, others may require a lot. You need to outline (and eventually test) for the different types of recovery scenarios. Overall, my experience has been that RMAN offers very fast performance, usually limited just by disk speeds. But what impresses me may not meet your needs. I'm easily impressed.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, February 05, 2003 2:16 PM To: Multiple recipients of list ORACLE-L

I am considering doing an rman to disk backup and recovery solution for a 500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users

This rman would be the secondary recovery solution.... (Timefinder is the first).

Anybody know time frames I might be able to restore/backup 500Gig to 1terabyte
of database from disk?

I will perform it before it goes live but I would like get a ball park idea of restore times before hand so we can determine if it can fit
in the SLA requirements.

Any parameters to focus on to improve performance other than allocating channels?

Thanks for any help
Brian Spears

-----Original Message-----
Sent: Wednesday, February 05, 2003 9:53 AM To: Multiple recipients of list ORACLE-L

Check out the doc's at tahiti.oracle.com and look up the parameter noprompt.

Robert

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM

Hello List,

I think my question is very simple...

How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically?

Many thanks for your help.
--

Best regards,

Alex                          mailto:Oleksandr_A_at_yahoo.co.uk

__________________________________________________

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

--

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

Author: Alex Andriyashchenko
INET: Oleksandr_A_at_yahoo.co.uk

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: Freeman Robert - IL
INET: FREEMANR_at_tusc.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
---------------------------------------------------------------------

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
---------------------------------------------------------------------