Basic management of Oracle 10g RAC spfile

Basic management of Oracle 10g RAC spfile --- SPFILE www.2cto.com will be created when DBCA is used to create a database --- SPFILE must be created on the shared volume or shared raw device --- all instances use the same SPFILE --- if you manually create a database, create a SPFILE through PFILE. Www.2cto.com [oracle @ rac11 dbs] $ more initPROD1.oraSPFILE = '+ DATA1/PROD/spfilePROD. ora '[oracle @ rac22 dbs] $ more initPROD2.oraSPFILE =' + DATA1/PROD/spfilePROD. ora '--- change the parameter settings alter system set <dpname> scope = memory sid = <sid | *> ;*. pname applies to all instance sid. pname applies to sid. the pname priority is higher *. sid --- use current or future *. dpname settings for <sid> alter system reset dpname scope = memory sid = <sid>; --- Delete the 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 to the alter system quiesce restricted and alter system unquiesce operations. 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. --- Impact of common sqlplus commands on instances archivelog impact of current instance connect impact of default instance host impact of node recover running sqlplus command does not affect specific instances, affect the entire data block show parameter and show sga display the current instance parameters and SGA information startup affect the current instance shutdown affect the current instance show instance display the current instance information source http://blog.csdn.net/xiangsir/article/details/8644387