RAC in archive log mode
Enable Archive Log Mode in Oracle RAC 10g Database
Oracle RAC on Archive Log Mode
1- Login to one of the clustered database nodes and change parameter cluster_database to false:
sqlplus / as sysdba
alter system set cluster_database=false scope=spfile sid='rac1'
2- Stop all database instances:
srvctl stop database -d racdb
3- startup mount the instance and enable archivelog mode:
sqlplus / as sysdba
startup mount;
alter database archivelog;
4- Shutdown the previous running Instance and set cluster_database
sqlplus / as sysdba
alter system set cluster_database=true scope=spfile sid='rac1' ; -----<<<<<<<--- Imp
shutdown immediate;
5- Start all instance back:
srvctl start database -d racdb
To check the mode:
sqlplus / as sysdba
archive log list;
or
select log_mode from v$database;
Search This Blog
Total Pageviews
Saturday, 22 October 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment