Antwort: Backing up large DBs on ASM

1. One global approach is parallelization - provide a greater number of concurrently usable(!) tape channels, and it will speed up 99% each. I agree, this is an expensive way, but equally efficient.
2. The customer should consider an incemental or differential backup solution, if this is appropriate, only the customer and the guy working with the customer can know.
3. Another thought is to migrate to some kind of split mirror backup, though it has to be carefully checked for pitfalls with ASM. Especially if ASM mirrors across more than one storage subsystem, or worst, over storage subsystems from different vendors, it makes this approach impossible.
4. The fourth and last think I can think of, is a special backup disk array. Fast and cheap fibre channel disk subsystems are available at about 15.000 EUR, they can reside $SOMEWHERE in the SAN and you can do all that you want with RMAN without need for any kind of backup software if you don't have needs beyond encryption and compression.

Ah, compression: Of course, switching off compression may speed up the whole process a lot, especially if you are using the to-disk-option (4) .

--
Mit freundlichem Gruß


Martin Klier
Senior Oracle Database Administrator
------------------------------------------------------------------------------

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.:  +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier_at_klug-is.de
www.klug-is.de
------------------------------------------------------------------------------

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg




|------------>

| Von:       |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |"Hameed, Amir" <Amir.Hameed_at_xerox.com>                                                                                                            |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| An:        |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |<oracle-l_at_freelists.org>                                                                                                                          |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Datum:     |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |22.06.2009 04:54                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Betreff:   |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |Backing up large DBs on ASM                                                                                                                       |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|


|------------>

| Gesendet   |
| von:       |


|------------>

  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |oracle-l-bounce_at_freelists.org                                                                                                                     |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|





Folks,
One of our large client has a very large DB (~40TB) configured with ASM.
They are currently using RMAN to back it up to tape and it takes a very
long time to do that. They have also tried backing up to disk but the
timing has not really improved much. What they are looking for is ways
to speed up the backup and restore timing. I am not directly involved
with this client and do not have extensive experience with ASM and RMAN
either. Are their any ways and best practices to speed up backups on ASM
for very large DBs. Any feedback will be greatly appreciated.

Thanks
Amir

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






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