?
Solved

Shutting down RAC Oracle database not the Instance

Posted on 2008-06-25
8
Medium Priority
?
1,192 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month5 days, 6 hours left to enroll

601 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