Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

How to back up Oracle 10g RAC database on an AIX system

An Oracle user wants to take a backup of an Oracle 10g RAC database on an AIX system. Read an expert's advice here.

I have a two-node Oracle 10g RAC database with Automatic Storage Management (ASM) on an AIX system. One node is disabled. I want to take a cold backup of my data files on the tap drive, which resides on SAN. How do I see the data files? How do I get a cold backup?
If one node in the RAC cluster is still up and running, then you will not be able to obtain a cold backup. The data files are used by all nodes in the RAC cluster. In order to obtain a cold backup, you will need to shut down all instances in the RAC environment.

How you use OS-level commands to backup your database depends on your environment. Since you are using AIX, you might be able to use tar for this operation. However, RAC can make things more complex. Is your RAC file system a RAW file system? An ASM file system? Or a clustered file system? If you're using a clustered file system, then you can use tar. If you're using a RAW file system, you can use the dd command. In all cases, using RMAN will back up your RAC database regardless of the file system.

Dig Deeper on Oracle database administration

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.