How to change Archive destination
Use similar commands to change archive destination, to change archive destination no need to bounce the database.
1. Verify existing values
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/arch/vada <------
Oldest online log sequence 147
Next log sequence to archive 149
Current log sequence 149
SQL>
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------------
log_archive_dest_1 string LOCATION=/u01/app/oracle/arch/vada
SQL>
2. Modify the archive destination
SQL> alter system set log_archive_dest_1='LOCATION=/u02/arch/vada' scope=both; System altered. SQL>
3. Verify the results
SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /u02/arch/vada <---- Oldest online log sequence 147 Next log sequence to archive 149 Current log sequence 149 SQL> SQL> show parameter log_archive_dest_1 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_1 string LOCATION=/u02/arch/vada
Note: If you set log_archive_dest_1 and log_archive_dest_2, it will store same log file in both locations.
Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
These statements worked as exactly mentioned.
Thanks Maga
hi,
I have to change the destination on the standby database, the procedure is the same as I did and did it work on the primary?
old destination
/backup/log_arc_dest/caseeser/
1) alter system set log_archive_dest_3=’LOCATION=+CE_FRA’ scope=both sid=’*’;
2) ALTER SYSTEM SET log_archive_dest_state_1 = DEFER;
waiting for your answer, I salute you