Friday, February 19, 2010

How to change Archive Log Destination

Description:

I used below steps to change Archivelog destination for Oracle 10g.

Step 1: Login to Database as SYSDBA

Step 2: Check the Archive Destination using archive log list command.

Step 3: Set the value of db_recovery_file_dest Parameter.

Step 4: Set the value for db_recovery_file_dest_size Parameter

Step 5: Check the new location for Archivelog destination

Step 6: Use the below command to generate Archivelog.

Step 7: Use the below command to check Archive Destination and log sequence.

No comments: