oracle错误

美奇科技

　　1.
　　SQL> startup mount
　　ORACLE instance started.
　　Total System Global Area  838860800 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          错误
　　[oracle@aa ~]$ 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.
　　[oracle@cc ~]$ 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   参数文件里写了，所以要建立。