$export ORACLE_SID=ORCL1
$sqlplus “/ as sysdba”
Check the status of archive mode of the database:
SQL>archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 407
Current log sequence 408
SQL> alter system set cluster_database=false scope=spfile sid=’ORCL1′;
$ srvctl stop database -d cobra
$ sqlplus “/ as sysdba”
SQL> startup mount
SQL> alter database archivelog;
SQL> alter system set cluster_database=true scope=spfile sid=’ORCL1′;
SQL> shutdown immediate
#srvctl start database -d orcl
#srvctl start service -dorcl
$sqlplus “/ as sysdba”
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 407
Current log sequence 408
Thank you
Osama mustafa