How to switch the directory of archive log
Hello everybody,
I would like to change the archived log directory which the file system is nearly full to another one that can take all of them.
The configuration is:
The host OS is Solaris 10
The database is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bits
the parameter log_archive_dest_1 is currently fulfilled and the parameter log_archive_dest_2 is not.
Could I change online the value of the parameter log_archive_dest_1 to the new mounted point without the restart of the database ?
Or should I switch to log_archive_dest_2 first and then switch back to log_archive_dest_1 which is the same directory ?
I would like to change the archived log directory which the file system is nearly full to another one that can take all of them.
The configuration is:
The host OS is Solaris 10
The database is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bits
the parameter log_archive_dest_1 is currently fulfilled and the parameter log_archive_dest_2 is not.
Could I change online the value of the parameter log_archive_dest_1 to the new mounted point without the restart of the database ?
Or should I switch to log_archive_dest_2 first and then switch back to log_archive_dest_1 which is the same directory ?
0