If your present archivelog mountpoint is FULL or for any other reason, you want to change the archivelog destination in the database, then follow the below steps.
NOTE – > It can be done ,when the database up are running. No downtime required. FOR STANDALONE DATABASE: 1. Find the current archivelog location:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /dbaclass05/ORCLSIT2/Arch
Oldest online log sequence 25626
Next log sequence to archive 25628
Current log sequence 25628
SQL> select destination,STATUS from v$archive_dest where statuS='VALID';
DESTINATION STATUS
---------------------------------- ---------
/dbaclass05/ORCLSIT2/Arch VALID
