ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
원인:noarchivelog모드 에서 archivelog모드로 변경시, 아카이브 파일이 떨어지는 위치 지정시
(SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/aaa/ORCL/' scope=spfile ;)
실제로 자신에 환경에는 없는 위치(/u01/app/oracle/aaa/ORCL/)를 지정한후 db mount 한 경우
해결 방법 : 해당 위치에 폴더를 만들어 준다. 또는 백업된 spfile 및 pfile로 복구 한다
[oracle@oracle admin]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Dec 28 23:33:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 96471284 bytes
Database Buffers 67108864 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database noarchivelog ;
Database altered.
SQL> alter database open
2 ;
Database altered.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/oradata/ORCL/
Oldest online log sequence 19
Current log sequence 21
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/10.2.0
/db_1/dbs/spfileORCL.ora
SQL> alter system set log_archive_format='%t_%s_%r.arc' scope=spfile ;
System altered.
SQL> alter system set log_archive_dest_1='location=/u01/app/oracle/aaa/ORCL/' scope=spfile ;
(실제로는 /u01/app/oracle/aaa/ORCL/ 폴더는 없다 ^^)
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory
[oracle@oracle oracle]$ mkdir aaa <-- 수동으로 /u01/app/oracle/ 밑에 aaa 폴더를 만든다)
[oracle@oracle aaa]$ mkdir ORCL <-- 수동으로 /u01/app/oracle/aaa 밑에 ORCL 폴더를 만든다)
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 100665588 bytes
Database Buffers 62914560 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> alter database archivelog ;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/aaa/ORCL/
Oldest online log sequence 19
Next log sequence to archive 21
Current log sequence 21
SQL> alter database open
2 ;
Database altered.
SQL> alter system switch logfile ;
System altered.
SQL> alter system switch logfile ;
System altered.
[oracle@oracle ORCL]$ ls
1_21_672329027.arc 1_22_672329027.arc
[oracle@oracle ORCL]$ pwd
/u01/app/oracle/aaa/ORCL
[oracle@oracle ORCL]$