Archive log Destination change
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\APP\ATHIL\ADMIN\ORCL\arch
...
SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=C:\Athil\Arch\ORCL' scope=both;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=C:\Athil\Arch\ORCL' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
SQL> sho parameter arc
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string C:\APP\ATHIL\ADMIN\ORCL\arch
SQL> alter system set LOG_ARCHIVE_DEST='LOCATION=C:\Athil\Arch\ORCL' scope=both
2 ;
alter system set LOG_ARCHIVE_DEST='LOCATION=C:\Athil\Arch\ORCL' scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux-x86_64 Error: 2: No such file or directory
After checking in Doc
LOG_ARCHIVE_DEST
Property | Description |
---|---|
Parameter type | String |
Syntax | LOG_ARCHIVE_DEST = filespec |
ALTER SYSTEM SET LOG_ARCHIVE_DEST =
filespec
, where filespec
is the new archive destination.NO "LOCATION " for LOG_ARCHIVE_DEST
SQL> alter system set LOG_ARCHIVE_DEST='C:\Athil\Arch\ORCL' scope=both;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\Athil\Arch\ORCL
...
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> host dir C:\Athil\Arch\ORCL
06/08/2012 10:45 AM 38,752,256 ORCL_1_137_780346113.ARC
06/08/2012 10:45 AM 1,024 ORCL_1_138_780346113.ARC
06/08/2012 10:45 AM 3,072 ORCL_1_139_780346113.ARC
No comments:
Post a Comment