Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can not change archive log destination

eric tangApr 21 2023

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25963
Next log sequence to archive 25963
Current log sequence 25965

SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=t:\LOG' SCOPE=BOTH;
ALTER SYSTEM SET log_archive_dest_1='LOCATION=t:\LOG' SCOPE=BOTH
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 3) The system cannot find the path specified.

As you can see above , I want to change the archive log dest to the path t:\log , but it pops the above error.

Would advise what can I do ?

thanks

Comments
Post Details
Added on Apr 21 2023
5 comments
773 views