-
编辑 删除
Enable/disable listener logging
if you found listener.log, that hung. you stop and start but it's down time. so, you can force listener logging off and on #lsnrctl lsnrctl> set log_status off lsnrctl> set log_status on ...
-
编辑 删除
表空间时间点恢复练习
表空间时间点(TSPITR)恢复步骤1: alter tablespace test read only;SQL> select * from test.t_date1; C1 C2---------- ------------------- 714924 2006-12-21 13:34:36 715098 2006-12-21 13:35:39 ...
-
编辑 删除
Error of Install on linux
[oracle@myredhat Disk1]$ ./runInstallerYou do nothave permission to write to the inventory /oraInventory. Installation cannot continue.:Permission denied检查/etc/orainst.loc文件[root@redhat etc]# ca...
-
编辑 删除
Rman练习-创建恢复目录
1. 准备目录数据库2. 创建恢复管理器目录3. 注册prod数据库4. 为恢复目录同步控制文件1. 准备目录数据库 create tablespace cattbs datafile 'C:oracleoradatatestdbcattbs01.dbf' size 50m extent management ...
-
编辑 删除
热备份下不完全恢复
热备份下基于时间的恢复......SQL> select * 2 from test.t_date1; C1 C2---------- ------------------- 491369 2006-12-18 15:45:49 111 2006-12-18 15:52:21 492946 2006-12-18 15:55:54 ...
-
编辑 删除
exp auto date file
%date:~4,4% 取年%date:~9,2% 取月 %date:~12,2% 取日%time:~0,2% 小时%time:~3,2% 分钟%time:~6,2% 秒%date:~4,4% 取年%date:~9,2% 取月 %date:~12,2% 取日%time:~0,2% 小时%time:~3,2% 分钟%time:~6,2% 秒eg:exp u...
-
编辑 删除
冷备份脚本
共有两个文件back_cold.bat和back_cold.sql,通过定时任务来调用back_cold.batbat:set day=%date:~0,10%cd e:dbdatamd %day%sqlplus /nolog @e:dbdataback_cold.sql %day%sql:Rem db cold backup;conn sys/oracle as ...
-
编辑 删除
遭遇600-[qmxiUnpPacked2]
今天在删除一用户时系统报600错误:ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []打开trc文件一片茫然,经过查找得到关于此错误的一些信息:ORA-600 [qmxiUnpPacked2] ...
-
编辑 删除
Redhat as4下安装oracle817
结合多篇安装文档,在Redhat as4下安装oracle817版本跨度较大，但限于手头资源，只能如此了1. soft list compat-egcs-6.2-1.1.2.16.i386.rpm compat-egcs-c++-6.2-1.1.2.16.i386.rpm compat-egcs-objc-6.2-1.1.2.1...
