DBA Hub

📋Steps in this guide1/3

Change Archive Dest - Bright DBA

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 … Continue readi

oracle clusteringintermediate
by OracleDba
11 views
1

Overview

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 2. Modify the archive destination

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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

Section 2

2. Modify the archive destination 3. Verify the results Note: If you set log_archive_dest_1 and log_archive_dest_2, it will store same log file in both locations.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
SQL> alter system set log_archive_dest_1='LOCATION=/u02/arch/vada' scope=both;

System altered.

SQL>

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
3

Section 3

Note: 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 . 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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!