First, I think you might have the parameter name mistyped. Are you concerned with DB_RECOVERY_FILE_DEST_SIZE in a RAC cluster? If so, here are your answers:
1. DB_RECOVERY_FILE_DEST_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area. There is no default size. The question is how many days/weeks/months are you planning on keeping in your Flashback area? How many archive logs do you have generated in 1 day? On average, DBAs set their flashback area to be 2x-3x the size of the database and all of its files. Remember that the flash recovery area contains multiplexed copies of current control files and online redo logs, as well as archived redo logs, flashback logs, and RMAN backups so make sure you have enough space!
2. sqlplus /nolog
connect sys/oracle as sysdba
SELECT * FROM V$INSTANCE;
ALTER SYSTEM ... SID='*'
3. You will use RMAN to connect to each instance in the cluster. For example, a 2-node RAC cluster with 1 database named docrac, create an RMAN script for docrac1 and one for docrac2.
4. For RAC, each instance has its own thread of redo. If the archive log destination is the same for all instances, then in the Archive Log Destination field, change the value to the location of the archive log destination for the cluster database. For example, you might set it to +DATA if using ASM. If you need to configure a different archive log destination for any instance, you must go to the Initialization Parameters page and modify the LOG_ARCHIVE_DEST_1 parameter that corresponds to the instance for which you want to configure the archive log destination. The Instance column should display the name of the instance, for example docrac1. Change the Value field to contain the location of the archive log destination for that instance.
Linda
"640KB ought to be enough for anybody." - Bill Gates, 1981
----- Original Message ----
From: YIF <oracledba-ezmlmshield-x96424436.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Thursday, May 29, 2008 2:33:10 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