eygle.com   eygle.com
eygle.com  
 
留言簿 - Oracle Life - Powered by Eygle.com
eygle.com 我要留言
唯书有色,艳于西子 唯文有华,秀于百卉
昵称
内容 页: 1 - << < 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 > >> - 404
# 43536
anycall2010
To: eygle
　　看了您＜深入浅出＞有一个基于ＳＣＮ恢复数据，如果在进行基于ＳＣＮ进行不完全恢复的时候，如果某些数据是ＯＦＦＬＩＮＥ的，那么进行完ＳＣＮ恢复后，对这些ＯＦＦＬＩＮＥ的数据会不会有影响？
From: anycall2010
2007.09.04 09:31
To: anycall2010
　　[COLOR=blue]如果做完全恢复没问题；如果是不完全恢复，resetlogs打开就有问题了。[/COLOR]
From: eygle
2007.09.05 18:49
版主选项: 回复 编辑
# 43535
Chi


来自: Mexico

To: Eygle
　　I recently created a MV on Test machine (AIX 5.3L, Oracle 10g R2).The MV was created based on outer join of 2 tables.None of the column elements of the 2 tables has any constraint relationship with those of any other table in the schema.I also have MV log on both master tables and index of the MV and the refresh is set up by NEXT schedule daily. However I noticed that every time the MV was refresh, it generated a message in the alert log as "Join columns of outer join with table TTPPPC235201 have no uniqueness constraints".I search many places on line, including the metalink, and could not find any thing about this.I do not think this is an error.What do You think?All the tables of the schema does no have any elements constraint.

PS.How is felling being a father?lots diapers!!
From: Chi
2007.09.04 09:21
版主选项: 回复 编辑
# 43533
Jennny
To: All
　　猎头招聘：—美500强Global R&D Center 招数据库开发, base 上海
美国500强公司，下设四大块业务领域，在上海设立了全球研发中心，现在正在招数据库开发、管理方面的人才，用于开发汽车诊断软件，从junior到supervisor的职位都有，熟悉Oracl，SQL，英语好，因为要和美国总部联系，并有出国培训机会，合适者待遇优厚。

有意向者可通过以下方式联系能得到更多信息

邮箱： jenny.shao@echelon-cn.com
电话： 51001620*809
—— Jenny 邵

From: Jennny
2007.09.03 22:33
版主选项: 回复 编辑
# 43532
libing


来自: xj

To:
　　25-3月 -2007 15:27:25 * (CONNECT_DATA=(SID=TFYB)(SERVER=DEDICATED)(CID=(PROGRAM=D:\Hisys6.0\hisys60.exe)(HOST=ZYJS2)(USER=LNB))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.30)(PORT=1632)) * establish * TFYB * 12560
TNS-12560: TNS: 协议适配器错误
 TNS-00517: 丢失连接
  32-bit Windows Error: 54: Unknown error
 TNS-12500: TNS：监听器未能启动专用的服务器进程
  TNS-12547: TNS：丢失连接
 TNS-12560: TNS: 协议适配器错误
  TNS-00517: 丢失连接
 32-bit Windows Error: 54: Unknown error
25-3月 -2007 17:23:18 * (CONNECT_DATA=(SID=tfyb)(SERVER=DEDICATED)(CID=(PROGRAM=E:\Hisys6.0\hisys60.exe)(HOST=MZJS1)(USER=lnb))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1892)) * establish * tfyb * 12500
TNS-12500: TNS：监听器未能启动专用的服务器进程
 TNS-12560: TNS: 协议适配器错误
关键问题次错误是偶尔出现。比如业务比较繁忙是，我真心的希望盖国强大师
你看次问题 谢谢

From: libing
2007.09.03 20:59
To: libing
　　[COLOR=blue]
12500，通常是你的服务器资源耗尽（一般是内存），使得服务器无法启动Dedicated的进程，你检查一下监听器的日志，里面应该有错误记录的。
[/COLOR]
From: eygle
2007.09.04 07:25
版主选项: 回复 编辑
# 43530
Julia
To: Vera
　　Miss you too~~ Be good!
From: Julia
2007.08.31 23:15
版主选项: 回复 编辑
# 43529
vera
To: 盖。。盖。。。盖盖盖老师
　　咦。。。太久不来。。。落伍了。。。
几时都改称为盖老师了。。。

julia i miss u~
From: vera
2007.08.31 08:27
版主选项: 回复 编辑
# 43528
Julia
To: Alice
　　谢谢Alice，嘿嘿
From: Julia
2007.08.30 19:46
版主选项: 回复 编辑
# 43527
hwq
To: eygle
　　加上了
但是
执行到这
import done in ZHS16GBK character set and AL16UTF16 NCHAR character setSegmentation fault

就退出来了


不知道 11g到9i可不可以导数据？
From: hwq
2007.08.30 02:06
版主选项: 回复 编辑
# 43526
ryan
To: 盖老师
　　您好！
 请教个NBU备份oracle DB的问题。子job备份成功，但父job报错，以前备份好的，就这几天出现的。rman输出牟糠謑og是：
..
channel dev2: starting piece 1 at 29-AUG-07
channel dev1: finished piece 1 at 29-AUG-07
piece handle=df19435_1_631898274 comment=API Version 2.0,MMS Version 5.0.0.0
channel dev1: backup set complete, elapsed time: 03:08:37
channel dev2: finished piece 1 at 29-AUG-07
piece handle=df19436_1_631898274 comment=API Version 2.0,MMS Version 5.0.0.0
channel dev2: backup set complete, elapsed time: 03:21:13
Finished backup at 29-AUG-07

Starting Control File and SPFILE Autobackup at 29-AUG-07
released channel: dev1
released channel: dev2
RMAN-00571: ===============================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ====
RMAN-00571: ================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on dev1 channel at 08/29/2007 18:39:15
ORA-19580: backup conversation not active

Recovery Manager complete.

From: ryan
2007.08.30 01:17
To: ryan
　　[COLOR=blue]自动备份出错了，看看你的自动备份难道不在缺省目录?[/COLOR]
From: eygle
2007.09.02 20:41
版主选项: 回复 编辑
# 43525
alice
To: eygle&julia
　　今天得知亲爱的宝宝enmo诞生，迟来的祝福给你们和ＢＢ．
尤其是julia好伟大啊，好佩服你的坚强．
祝你们这三口之家永远开心快乐！幸福永驻！
From: alice
2007.08.29 23:07
To: alice
　　[COLOR=blue]谢谢：）[/COLOR]
From: eygle
2007.08.30 01:01
版主选项: 回复 编辑
页: 1 - << < 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 > >> - 404
我要留言
Copyright © 2003~2012 eygle.com All Rights Reserved.
Powered by: www.eygle.com