Change oraarch directory to a larger folder
This command does not need to restart db.You can do it at run time
In sqlplus,
SQL> show parameter log_archive_dest;
SQL> startup mount;
SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory;
* LOCATION will be the new path for your archive log folder.
* you may remove LOCATION word if sqlplus gives error.
In sqlplus,
SQL> show parameter log_archive_dest;
SQL> startup mount;
SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory;
* LOCATION will be the new path for your archive log folder.
* you may remove LOCATION word if sqlplus gives error.