Tuesday, July 1, 2014

How to null log_archive_dest parameter

==================================================================
In this case if database are archive log mode database will send archive log file in DB_RECOVERY_FILE_DEST (Value of this Parameter).
==================================================================

SQL> ALTER SYSTEM SET log_archive_dest_2='' SCOPE=BOTH;

System altered.

SQL> ALTER SYSTEM SET log_archive_dest_3='' SCOPE=BOTH;

System altered.

SQL> ALTER SYSTEM SET log_archive_dest_4='' SCOPE=BOTH;

System altered.

1 comment: