DBA NAREN BLOG: how to change archive log location in Oracle 11g database

how to change archive log location in Oracle 11g database

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 512

Next log sequence to archive 515

Current log sequence 515

Db_recovery_file_dest location change:

alter system set db_recovery_file_dest='/RMANB/' scope=spfile;

log_archive_dest_1 location change:

alter system set log_archive_dest_1='/RMANB/11g/archive' scope=spfile;

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1603887104 bytes

Fixed Size 2089064 bytes

Variable Size 385884056 bytes

Database Buffers 1207959552 bytes

Redo Buffers 7954432 bytes

Database mounted.

Database opened.

SQL> show parameter db_recovery_file_dest

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /RMANB/

db_recovery_file_dest_size big integer 2G