Solved

Oracle Backup Solution

Posted on 2013-11-06
4
484 Views
Last Modified: 2013-11-12
Experts -

PRODUCT : EMCs avamar backup solution.

OS : IBM AIX - LPAR

We've 4 databases, each one is 5 TB in size.

Do you have any objection/preference to migrate the RMAN backups over to Avamar?

The database is in Archive log mode.

Thanks,
sve
0
Comment
Question by:sventhan
4 Comments
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 50 total points
ID: 39629531
no, none whatsoever
0
 
LVL 15

Assisted Solution

by:Franck Pachot
Franck Pachot earned 200 total points
ID: 39629735
Hi,
Avamar do deduplication. It is good on full backups. Not so efficient on archivelogs - and with a large retention window archivelogs may be the bigger volume.
There are a few rman settings to check when doing deduplication. For exemple, it's better to have only one datafile per backupset because multiplexing can give different backupsets even with same data.
Regards,
Franck.
0
 
LVL 19

Accepted Solution

by:
Thommy earned 250 total points
ID: 39629785
Why do you plan to migrate to AVAMAR?

If your goal is fastening backup and reducing amount of network data, you're on the right way.

But you will still need RMAN to initiate backups, before the backup will finally be executed by AVAMAR...
Backup and Restore using AVAMAR

You may also have a look at this detailed review...
Backing Up Large SAP Oracle Databases Using EMC Avamar and Oracle RMAN
0
 
LVL 18

Author Closing Comment

by:sventhan
ID: 39641691
Thanks for all the help.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
form builder not starting 3 34
Help on model clause 5 31
what privileges needed for S2 for this function (Oracle 12c)? 3 22
error in my cursor 5 30
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question