在操作系统损坏时恢复Oracle10g全过程

    9、alter database mount，出现错误提示
    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-01990: error opening password file '/oracle/app/oracle/OraHome/dbs/orapw'
    ORA-27037: unable to obtain file status
    IBM AIX RISC System/6000 Error: 2: No such file or directory
    Additional information: 3

    10、建立口令文件
    orapwd file=$ORACLE_HOME/dbs/orapwd.ora password=oracle
    11、
    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-01100: database already mounted

    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-38760: This database instance failed to turn on flashback database

    SQL> alter database flashback off;

    Database altered.

    SQL> alter database open;

    Database altered.

    SQL> archive log list;
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /oracle/app/oracle/OraHome/dbs/archive
    Oldest online log sequence 614
    Next log sequence to archive 616
    Current log sequence 616
    SQL>

查看本文来源