• Arun Kumar

Enable Archivelog Mode in RAC


SQL> select log_mode from v$database;

SQL> show parameter recovery;

SQL> alter system set db_recovery_file_dest_size = '20G' scope=both sid='*';


If DB_RECOVERY_FILE_DEST is set to disk group, LOG_ARCHIVE_FORMAT is ignored

If DB_RECOVERY_FILE_DEST is set to disk group location, LOG_ARCHIVE_FORMAT comes in effect

From node 1:

ALTER SYSTEM SET log_archive_dest_1='location=+FRA/RAC/ARCH/' SCOPE=spfile;

ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile;

./srvctl stop database -d RAC

sqlplus / as sysdba

startup mount

alter database archivelog;

alter database open;

select log_mode from v$database;

From node 2:


select log_mode from v$database;

archive log list;


Recent Posts

See All

11gR2 Non-RAC to RAC Migration

In this article we will be looking at Non-RAC to RAC migration using DBCA. I have RACN1 and RACN2 where I will show you how to migrate a single instance database running on machine DT_VM. Create Templ

RMAN Backups in RAC

BACKUP DEFAULT LOCATION All backups by default go to FRA disk group TAKE BACKUP TO CUSTOM LOCATION ON ASM RMAN> backup as compressed backupset database format '+RMANDG'; or run{ allocate channel ch1

Create Diskgroup Sqlplus Command

In this article we will be creating new ASM diskgroup using SQLPLUS command while connected to ASM instance. You must have an unused partition / disk on the server that can be used to create ASM diskg

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis