Solved

Shutting down RAC Oracle database not the Instance

Posted on 2008-06-25
8
1,170 Views
Last Modified: 2013-12-18
Guys

I have a 2 node RAC Cluster 10g with ASM I want to do a COLD backup of the database.

Now I am able to use ftp to connect to the ASM instance which would give me access to the datafiles but this is only possible while the instance is running.

I was told to shutdown the database and not the instance so I use
srvctl stop database -d IT2B
but this shutsdown the database and instance

what is confusing me is that there is also a
srvctl stop instance -d IT2B -I IT2B1

command which seems to also do the same thing

Am I doing something wrong I need the database stopping but the instances still running

Any Ideas

Darren
0
Comment
Question by:DarrenJackson
  • 3
  • 3
  • 2
8 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 21872538
You have to restrict the access of all RAC nodes to the ASM instance for the time you do the cold backup.
Or even shut them down what is the clasic approach.
If you can get the list of the files it will be easier to do the job.
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 21872713
I believe the converse is true. i.e you can shut down the instance but not the database.

Imagine you have multiple instance all accessing the same database. If you shut down the database then all the instances are useless. However, you can selectively shutdown individual instances while the database reamins available to the running instances. Does this make sense?

To take a COLD backup using whatever means, you must shutdown the database which also shutsdown the instances. Even if you RMAN, you still need to shutdown all instances accessing the database otherwise you get errors.

Richard.
0
 

Author Comment

by:DarrenJackson
ID: 21878211
schwertner / richard

Thank you for you time

Schwertner is asking for the files is this the datafiles list your after?
0
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.

 
LVL 48

Expert Comment

by:schwertner
ID: 21881509
Yes, backups are based on datafiles. It is physical backup. This means datafiles.

Another way is to Export (by restricted database), but this is not backup, this is a snapshot...
0
 
LVL 16

Assisted Solution

by:Richard Olutola
Richard Olutola earned 200 total points
ID: 21881563
v$datafile will give you a list of all your datafiles.
v$controlfile for you control files etc.

R.
0
 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 300 total points
ID: 21881777
0
 

Accepted Solution

by:
DarrenJackson earned 0 total points
ID: 21916179
Schwertner / Rolutola from my experiences over this week I am thinking that it is impossible to do a cold backup of a rac 2 node instance using ASM.

How ever I have found maybe the best solution to this problem is for me to utilise the RMAN hot backup method as described in this doc from metallink  doc id 415579.1 How to Restore Rman Disk backups of RAC database to a single instance on another node.

As always I am very gratefull for any help that I am given so will award points according to posts
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 21971315
DarrenJackson,

For the benefit of anyone reading this thread in future, I forgot to mention that if you use ASM, then you MUST use RMAN for either cold or hot backup. This is because ASM uses OMF.

Therefore, for those not comfortable with RMAN or who have reasons not to use RMAN, they should not deploy ASM.

R.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

809 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