Q

Backup strategy for a 2-node 10g RAC cluster

I am about to implement a 2-node 10g RAC cluster. I am unsure as to the best way to implement a backup strategy.

I am about to implement a 2-node 10g RAC cluster (RedHat ES). Shared storage is by way of a SAN. I plan to use RAW+ASM for datafile management. I am unsure as to the best way to implement a backup strategy. I was hoping to use RAW+ASM for the flash_recovery_area and use RMAN to back up the database. That will be OK, but somehow I need to get the flash_recovery_area on to tape. Should I do something else in order to get tape backups? The option of the third-party media management/backup software integrated with RMAN is not available to us (due to cost).
Oracle does supply, free of charge, third-party media software by Legato and/or Veritas with 10g. This software can be used to have RMAN write to a locally attached tape drive on your database server. So this option is still available to you.

Another option is to have RMAN back up to a cooked file system and then have regular OS routines pick up the RMAN

backup and copy to tape using simple tar commands.

This was first published in July 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close