How to change archive destination folder on oracle 11g:

Posted by Unknown on 15:51 with 1 comment
**How to change archive destination folder on oracle 11g:


Old Archive destination         /u01/ora/db/tech_st/11.1.0/dbs/arch
New Archive destination       /u01/Arch_BKP


Note:- Check your Database running with SPfile or Pfile.If Database using SPfile than directly use below statement or restart Archive-log.
SQL> alter system set log_archive_dest='/u01/Arch_BKP' scope=spfile;

Steps:-1  Connect to SQL as sysdba
[ora@sujeet 11.1.0]$ sqlplus / as sysdba  


Steps:-2 Down Database
SQL> shutdown immediate;

Steps:-3 Start with Mount
SQL> startup mount


Steps:-4 If your Database in Archive mode:-
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/ora/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence      8
Next log sequence to archive   9
Current log sequence                9

Change noarchive mode

SQL> alter database noarchivelog;
Database altered.
SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/ora/db/tech_st/11.1.0/dbs/arch
Oldest online log sequence     10
Current log sequence               11 

Steps:-5 You have 2 option to change Archive destination:-
1. edit the init.ora parameter file (Pfile)
              OR 
Set other Archive destination location.my Location= /u01/Arch_BKP
SQL> alter system set log_archive_dest='/u01/Arch_BKP' scope=spfile;

Steps:-6 Change Archive Mode 
SQL> alter database archivelog;
Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/Arch_BKP
Oldest online log sequence      8
Next log sequence to archive   9
Current log sequence                 9

Steps:-7 Open Database:-
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.