1.shutdown the database
2.decide the directory and create the required directory
3.go to the /dbs and open the parameter file and specify the entries
4.move the spfile with different name
5.start the database
root> mkdir -p /u03/app/oracle/arch
root> chown -R oracle:oinstall /u03/app/oracle/arch/
root> chmod -R 775 /u03/app/oracle/arch/
root> su - oracle
oracle> cd $ORACLE_HOME/dbs
oracle> pwd
oracle> ls
oracle> vi initcrms.ora
log_archive_dest='/u03/app/oracle/arch'
comment the FRA and the FRA dest_size entry.
oracle> mv spfilecrms.ora spfilecrms.ora.bkp
oracle> export ORACLE_SID=crms
oracle> sqlplus / as sysdba
SQL> startup
SQL> archive log list;
see the path
oracle> cd /u03/app/oracle/arch
oracle> ls
SQL> alter system switch logfile;
SQL> archive log list;
oracle> cd /u03/app/oracle/arch
oracle> ls
If the archive logs destination is FRA the extension of the log files is .arc and if the archive logs destination is different then the extension is .dbf
To enable/disable the archive mode we need to be in the MOUNT state.
SQL> shut immediate
SQL> startup mount
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> archive log list;
SQL> shut immediate
SQL> startup mount
SQL> alter database archive log;
SQL> show parameter log_
