Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Shutting down RAC Oracle database not the Instance

Posted on 2008-06-25
8
Medium Priority
?
1,185 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
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
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 800 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 1200 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
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 explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

926 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