oracle错误
1.SQL> startup mount
ORACLE instance started.
Total System Global Area838860800 bytes
Fixed>
Variable> Database Buffers 444596224 bytes
Redo Buffers 7163904 bytes
Database mounted.
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 30
Current log sequence 32
SQL>> alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode 错误
$ oerr ora 265
00265, 00000, "instance recovery required, cannot set ARCHIVELOG mode"
// *Cause:The database either crashed or was shutdown with the ABORT
// option. Media recovery cannot be enabled because the online
// logs may not be sufficient to recover the current datafiles.
// *Action: Open the database and then enter the SHUTDOWN command with the
// NORMAL or IMMEDIATE option.
2.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /archive/
Oldest online log sequence 37
Next log sequence to archive 39
Current log sequence 39
SQL>> alter database noarchivelog
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance
3.
ORA-19625: error> 删掉了备份和归档日志才有这样｀｀｀
4.
$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2007, Oracle.All Rights Reserved.
Connected to an> SQL> startup nomount
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux Error: 2: No such file or directory
SQL>
建立目录db_recovery_file_dest 参数文件里写了，所以要建立。
页:
[1]