Basic management of Oracle 10g RAC spfile

--- Spfile is created when you use dbca to create a database.
--- Spfile must be created on the shared volume or shared raw device
--- All instances use the same spfile
--- If you create a database manually, use pfile to create a spfile.
[Oracle @ rac11 DBS] $ more initprod1.ora
Spfile = '+ data1/Prod/spfileprod. ora'

[Oracle @ rac22 DBS] $ more initprod2.ora
Spfile = '+ data1/Prod/spfileprod. ora'

--- Change parameter settings
Alter system set <dpname> scope = memory SID = <Sid | *>;
*. Pname applies to all instances.
Sid. pname applies to Sid
Sid. pname has a higher priority than *. Sid

--- Use current or future *. dpname settings for <Sid>
Alter system reset dpname scope = memory SID = <Sid>;


--- Delete entry from spfile
Alter system reset dpname scope = spfile SID = <Sid | *>;

--- List of parameters that require unique settings (with Sid:
Instance settings:
Thread instance_number rollback_segments undo_tablespace instance_name

--- Quiescing RAC database silent database. Only sys users can log on and perform operations.
Alter system quiesce restricted;
Alter system unquiesce;
These two operations affect all instances in the RAC environment.
When the database is in the quiesce status, you cannot perform the cold backup operation.

--- Influence of common sqlplus commands on Instances
Archivelog affects the current instance
Connect affects default instances
Host affects the node that runs the SQL plus command
Recover does not affect a specific instance and affects the entire data block.
Show parameter and show SGA display the current instance parameters and SGA Information
Startup affects the current instance
Shutdown affects the current instance

Show instance: displays information about the current instance.

For reprint, please indicate the author's source and original article link:

Http://blog.csdn.net/xiangsir/article/details/8644387