Evaluate

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

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

This was last published in September 2008

Dig Deeper on Oracle database administration

All
Evaluate
Manage
Problem Solve

Related Q&A from Brian Peasland

Managing Oracle connections from third-party apps

Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading

Perfect the Oracle RMAN duplicate 10g command

One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading

Managing SQL parent table-child table relations

Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading

Have a question for an expert?

Please add a title for your question

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

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Chief data officer skills tested by AI tech blitz

A reporter's notebook from a recent MIT symposium provides insights on chief data officer needs, as the AI wave starts to hit ...

Open source database software finally gets down to business

Once used primarily in web applications, open source databases are finding a place in more mission-critical business systems -- a...

Open source RDBMS uses spurred by lower costs, cloud options

Open source technologies have become more capable alternatives to mainstream relational databases for cost-conscious users -- and...

SearchBusinessAnalytics

Reddit and the aspiring data scientist

For amateur data scientists, Reddit provides the opportunity to post about personal projects, chat with like-minded people and ...

Talking Data: AI advances and the MIT Startup Exchange

The Talking Data podcast team discusses some of the MIT startups that are making advances in AI and natural language processing.

Tableau BI gets Extensions API in version 2018.2 update

Tableau's BI software sees general release of a 2018.2 update with an API for dashboard extensions, while a 2018.3 beta adds more...

SearchSAP

S/4HANA supply chain software integration options

Starting with S/4HANA supply chain software and adding additional capabilities through components such as Ariba and C/4HANA can ...

SAP S/4HANA Cloud update adds functionality for two industries

SAP focuses on manufacturing and professional services with the new features it's adding to S/4HANA Cloud. The enhancements are a...

French transit develops chatbot with SAP Conversational AI

The transit system in the Paris metropolitan area is tackling an AI-driven chatbot project to create an easy way for riders to ...

SearchSQLServer

2 ways to attach SQL Server database files to Linux containers

SQL Server files can be stored outside of Docker containers in host directories or volumes. Here's how to set up SQL Server on ...

Get started with SQL Operations Studio in 7 steps

Microsoft's newest tool, SQL Operations Studio, provides DBAs with a free, lightweight option for managing SQL Server and Azure ...

Quick start tips for using the new MSSQL-CLI SQL query tool

The new MSSQL-CLI command-line tool provides many enhancements over SQLCMD CLI that enable you to quickly write and run T-SQL ...

TheServerSide.com

10 Git quiz questions to test your distributed version control skills

Test your distributed version control knowledge with this 10 Git questions quiz. It's a quick test that will see how well you ...

Meaning of inversion of control in Spring and Java: IoC explained

What is inversion of control, and why has inversion of control in Spring and Java become such a core development concept?

Ten Jenkins quiz questions to test your install and config IQ

Here are 10 Jenkins questions designed to test your knowledge of the build tool. Think you know continuous integration well? Take...

SearchDataCenter

Converged data center migration practices to avoid data loss

Refreshing data center hardware is no simple task, especially for organizations with multiple workflows. Before completing an ...

14 SIEM reports and alerts to boost security

Setting up an SIEM reporting infrastructure requires an overall knowledge of what data capture is available. With standard ...

IBM Power9 servers add reliability, reduce maintenance costs

IBM looks to grab high-end hardware market share from archrival Intel with the introduction of two Power9 servers that offer ...

SearchContentManagement

Box AI, workflow automation strategies about to unfold

Box is set to reveal new AI and workflow automation tools to add to its cloud content services platform -- technology seen as key...

Office 365 SharePoint Online features raise CIO concerns

Most of Office 365's products can help solve specific challenges facing CIOs, but they also seem to compete directly with some of...

Content services platforms are the new incarnation of ECM

A tribal council is preserving British Columbia's native languages with the help of a newer type of content management platform ...

SearchHRSoftware

Gartner analyst sees limit to tech's ability to fix hiring bias

The best approach to fixing hiring bias is through an analysis of actual hiring data, a Gartner analyst advises. New technologies...

Employee turnover prediction takes aim at rising quit rate

The economy is encouraging employees to look for new jobs, and the quit rates are rising. HR has a variety of tools and methods ...

5 keys to ensuring your new SaaS HR system excels

Running HR in the public cloud brings data, integration and change management issues. Here are tips on overcoming the biggest ...

Related Resources

Dig Deeper on Oracle database administration

Related Q&A from Brian Peasland

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.