- 博客(4)
- 收藏
- 关注
原创 个别控制文件丢失的恢复
一般控制文件有 3 个 COPY,这在 init.ora 中已经指定位置。现模拟删除其中一个: rm /u01/oradata/control_PLAY_01.ctl这时, alert.log 中不会报错。试图关闭数据库:SQL> shutdown immediate;ORA-00210: cannot open the specified control fileOR
2012-03-20 03:36:34 229
原创 RMAN Backup 学习
先学了浅浅的一点点: 可以直接运行:rmanconnect target /;RUN{CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u03/backups/%d/bkup_%d_%T_%t_%p_piece' MAXPIECESIZE 3072m;CONFIGURE CONTROLFILE AUTOBACKUP ON;
2012-03-15 05:31:29 267
原创 PL/SQL编程笔记
1. select sysdate from dual@dblink今天需要用到一个远程DB的系统时间,发现如果用 select sysdate from dual@dblink into var_time, 返回的是本地数据库的时间。解决方法:参见 metalink https://support.oracle.com/CSP/main/article?cmd=show&type=NO
2012-03-08 04:27:56 207
原创 Upgrading Cognos from 8.4 to 10.1
Upgrading Cognos from 8.4 to 10.1 Step 1 If you are new to migration.Be sure that you understand each and every option under the Export tab.Usually most developer have only migrated reports fr
2012-03-08 04:26:41 293
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人