My experience is with 10.2, so not 100% sure how it applies to 11g.
1. it is set at the db level, so not set for each instance. at sqlplus
"show parameter db_recovery"
2. To change an instance level parameter
ALTER SYSTEM SET <parameter>=<value> SCOPE=SPFILE SID='*'; <--- This will
change the parm for all instances in the cluster
ALTER SYSTEM SET <parameter>=<value> SCOPE=SPFILE SID='<SID1>'; <--- This
will change the parm for instance 1 in the cluster
3. It will connect you to the local instance, and it will backup all of
your archive logs (assuming they are in ASM or on a shared drive).
4. v$log will tell you which thread/instance the groups are associated
with, and v$logfile will tell you about the members in each group.
-- Chris
"YIF "
<oracledba-ezmlms
hield-x96424436.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
05/29/2008 02:33
PM Subject
Oracle Real Application Clusters
questions
Dear all (RAC Experts)
I have some questions about Oracle RAC.
We are going to set up an oracle 11g using ASM
1. the DB_recovery_destinaction_size is it set on the instance level or on
the database level. If it is how can I find out the value of this
parameter set on each instance, is it by login as the sysdba directly from
the local instance
2. if it is set on the instance , how can I set it up, is it by login as
the sysdba or by conn sys/[Email Address Removed] then
Alter system set db_recovery_destination_size =
3.
If it is set on the instance level, and deleting files from this location
incase it gets full
if I'm using rman, this is my way to use rman
rman target / nocatalog
does this command logs me in to the database or the instance I'm login from
if I use RMAN full back, will it back up all archive files and clean up
the db_recovery_destination_size on both instance
4.
I know each instance has it's own online redo logs, how can I add and view
logfiles to the instance , is it by login directly to the instance , then
adding the logfile, or there is a special way to do
I appreciate any input
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page