Solved

Shutting down RAC Oracle database not the Instance

Posted on 2008-06-25
8
1,176 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

734 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