Unanswered: how to change where archive logs are being written to
We are running ORACLE 10g on Linux.
After running: SQL> ARCHIVE LOG LIST;
I confirmed that our database is writing archive logs to the wrong destination folder. This needs to be changed very urgently, but I'm not sure how to do this, and since I dont have a test/dev version to play with i cant try things out so to speak.
Can you good people please assist me with what to do?
I've read stuff like
SQL> alter system set log_archive_dest 'path to dest folder';
SQL> alter system set log_archive_dest_1 = 'path to dest folder';
so not sure which one would work.
Also stuff about stopping and restarting the archive log process:
SQL> alter system archive log stop;
SQL> alter system archive log start;
If you guys could please make sense of this for me then perhaps today wont be so bad for me and i can learn from this...
Sorry to bug you with something so trivial, but our senior DBA is on leave and unreachable and we're in a spot of trouble here as the destination where the archive logs are currently going is basically part of the root volume and there is not enough space...