SQL> startup
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
解决方式:
SQL> create pfile='/u01/app/initorcl.ora' from spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl.ora';
File created.
SQL> exit
Disconnected
[oracle@orcl22 dbs]$ cd /u01/app/
[oracle@orcl22 app]$ ll
total 12
-rw-r--r-- 1 oracle oinstall 1059 Jun 11 23:48 initorcl.ora
drwxrwxr-x. 11 oracle oinstall 4096 Jun 11 22:44 oracle
drwxrwx---. 5 oracle oinstall 4096 Jun 9 19:15 oraInventory
[oracle@orcl22 app]$ vi initorcl.ora
*.log_archive_dest_1='location=/u01/app/oracle/oradata/archivelog' ---修改成该样式
[oracle@orcl22 app]$ dba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 11 23:49:49 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile='/u01/app/initorcl.ora';
File created.
SQL> startup
ORACLE instance started.
Total System Global Area 730714112 bytes
Fixed Size 2256832 bytes
Variable Size 255852608 bytes
Database Buffers 465567744 bytes
Redo Buffers 7036928 bytes
Database mounted.
Database opened.