sqlplus /nolog
conn / as sysdba
alter database datafile ‘/pb/oracle9/OraHome1/owprojects/CY_9017293A.dbs’ offline;
启动数据库报下面错误：
ORA-16068: redo log file activation identifier mismatch
ORA-00312: online log 1 thread 1: ‘/usr/app/oracle/oradata/db1/redo01.log’
采取下面步骤解决：
SQL> startup mount
SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 168891412 bytes
Fixed Size 451604 bytes
Variable Size 134217728 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
1关闭数据库
su – oracle9
dbshut
sqlplus /nolog
conn / as sysdba
alter database datafile ‘/pb/oracle9/OraHome1/owprojects/CY_9017293A.dbs’ offline drop;
alter database open;
