-
编辑 删除
ORA-02062 错误
错误：ORA-02062: distributed recovery received DBID 238844f6, expected 8176bd16解释：ORA-02062 distributed recovery received DBID string, expected stringCause: A database link at a coordinator no long...
-
编辑 删除
开启oracle归档
1、修改归档参数 archive log list;alter system set log_archive_dest_1='location=/data/archivelog' scope=both; alter system set log_archive_dest_2='location=/data2/archivelog' scope=both; alter system set log_archive_format='archive_%t_%s_%r.arc' scope=spfile; 或者create pfile from spfile;在init${ORACLE_SID}.ora文件中增加：*.log_archive_dest_1='location=/data/archivelog' *.log_archive_format='archive_%t_%s_%r.arc' 也可以使用log_archive_dest参数。 2、关闭数据库 shutdown immedia
-
编辑 删除
10G, US7ASCII字符集转换为ZHS16GBK
操作过程如下：1、导出export NLS_LANG=AMERICAN_AMERICA.US7ASCIIexp 命令2、编辑DMP文件（ultraedit）修改第一行：2,3字节（0001）为0354修改第四行：3,4字节（0001）为03543、导入export NLS_LANG=AMERICAN_AMERI...
-
编辑 删除
update导致的redo日志问题
Wed Apr 13 21:26:48 2011ARCH: Connecting to console port...FAL[server, ARC0]: Complete FAL noexpedite archive (thread 1 sequence 52849 destination bfcaitong)Wed Apr 13 22:59:32 2011Thread 1 cannot...
