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 无法启动
oracle关闭状态删除活动日志报错恢复(一)
来源:这里教程网
时间:2026-03-03 11:48:26
作者:
编辑推荐:
- sqlldr的使用方法03-03
- 存储过程访问其他用户的表的问题03-03
- oracle关闭状态删除活动日志报错恢复(一)03-03
- word2010输入特殊符号的两种方法03-03
- word2010怎么合并两个文档03-03
- 收集关于SQL的运行报告方法03-03
- 打补丁时重建Inventory目录03-03
- 坑爹的Oracle 11.2.0.303-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 用好HugePage,告别Linux性能故障
用好HugePage,告别Linux性能故障
26-03-03 - Maya建模教程:打造最逼真的可乐瓶子
Maya建模教程:打造最逼真的可乐瓶子
26-03-03 - Oracle 性能优化之内核的shmall 和shmmax 参数
Oracle 性能优化之内核的shmall 和shmmax 参数
26-03-03 - Oracle 性能优化 之 游标及 SQL
Oracle 性能优化 之 游标及 SQL
26-03-03 - ORACLE启动报错之ORA-03113&ORA-16038&ORA-30012
- 《SAW》John制作解析:人物灯光材质篇
《SAW》John制作解析:人物灯光材质篇
26-03-03 - Maya教程:《后羿射日》3D效果制作解析
Maya教程:《后羿射日》3D效果制作解析
26-03-03 - 补丁psu、spu、cpu的意思
补丁psu、spu、cpu的意思
26-03-03 - Maya教程:详解《SAW》制作景材质篇
Maya教程:详解《SAW》制作景材质篇
26-03-03 - word2010中怎么加密码
word2010中怎么加密码
26-03-03
