oracle关闭状态删除活动日志报错恢复（一）

来源：这里教程网时间：2026-03-03 11:48:26 作者：

SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /tsmclient/oracle/app/oradata/autodb/redo01a.log /tsmclient/oracle/app/oradata/autodb/redo01b.log /tsmclient/oracle/app/oradata/autodb/redo02a.log /tsmclient/oracle/app/oradata/autodb/redo02b.log /tsmclient/oracle/app/oradata/autodb/redo03a.log /tsmclient/oracle/app/oradata/autodb/redo03b.log 6 rows selected. SQL> shutdowm immediate SP2-0734: unknown command beginning "shutdowm i..." - rest of line ignored. SQL> shutdown immediate ORA-01031: insufficient privileges SQL> conn / as sysdba Connected. SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@onekey ~]$ cd /tsmclient/oracle/app/oradata/autodb/ [oracle@onekey autodb]$ ls -l total 13483220 -rw-r----- 1 oracle oinstall 10485768192 Jul 20 00:10 auto_data01.pdf -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:10 redo01a.log -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:10 redo01b.log -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:06 redo02a.log -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:06 redo02b.log -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:06 redo03a.log -rw-r----- 1 oracle oinstall 104858112 Jul 20 00:06 redo03b.log -rw-r----- 1 oracle oinstall 1480728576 Jul 20 00:10 sysaux01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 20 00:10 system01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 19 22:00 temp01.dbf -rw-r----- 1 oracle oinstall 104865792 Jul 20 00:10 undotbs01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 20 00:10 users01.dbf [oracle@onekey autodb]$ rm redo0*.log [oracle@onekey autodb]$ ll total 12868796 -rw-r----- 1 oracle oinstall 10485768192 Jul 20 00:10 auto_data01.pdf -rw-r----- 1 oracle oinstall 1480728576 Jul 20 00:10 sysaux01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 20 00:10 system01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 19 22:00 temp01.dbf -rw-r----- 1 oracle oinstall 104865792 Jul 20 00:10 undotbs01.dbf -rw-r----- 1 oracle oinstall 524296192 Jul 20 00:10 users01.dbf 无法启动