Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Shutting down RAC Oracle database not the Instance

Posted on 2008-06-25
8
Medium Priority
?
1,183 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

670 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