Search This Blog

Tuesday, June 2, 2009

Set Rac Database in NoARCHIVELOG

export ORACLE_SID=instance_name

sqlplus "/ as sysdba"

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1271564 bytes
Variable Size 314575092 bytes
Database Buffers 750780416 bytes
Redo Buffers 7114752 bytes
SQL> alter system set cluster_database=false scope=spfile;

System altered.

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> exit
SQL> startup mount
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1271564 bytes
Variable Size 314575092 bytes
Database Buffers 750780416 bytes
Redo Buffers 7114752 bytes
Database mounted.
SQL>alter database noarchivelog;


Database altered.
Set the Cluster_database parameter again to true.

SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL>shutdown immediateWe will again use srvctl to start the database and associated service

[/home/oracle>srvctl start database -d