# 43640
Chi
来自: Mexico
|
|
To: Eygle
Do you know that using impdp (import pump) with tables and table_exist_action options will let the system to create temp external table for loading.I run into this problem of "grand select on ET$04...to role" after the import.Because I have a trigger of my schema that will grant select on table or view to a role when the table or view was created under the schema.So in my alert log, I saw many job error and in the schema, i found many:
job next schedule failure brokenwhat
--- --------------------- ------ -------------------------
10356 19-OCT-07 11:18:523 N execute immediate 'grant select on ET$042F00620001 to READ_BAANDB'
How can I avoid this error?
From: Chi 2007.10.19 10:03
|
|
|
|
To: Chi
[COLOR=blue]你可以从创建对象的名称或用户去考虑,在Trigger里作一个判断,排除这类对象。[/COLOR]
From: eygle 2007.10.21 07:16
|
|
|
|
# 43636
小鱼
|
|
To: 盖老师
如果数据库没有做归档没有备份,要怎么样恢复介质?
SQL> recover database using backup controlfile;
ORA-00279: 更改 4700054483 (在 10/16/2007 15:15:40 生成) 对于线程
ORA-00289: 建议: D:\ORACLE\ORA92\RDBMS\ARC00591.001
ORA-00280: 更改 4700054483 对于线程 1 是按序列 # 591 进行的
对于这个序列 # 591 ,我可不可以修改它的值成# 590?如何可以,怎么修改?
From: 小鱼 2007.10.17 23:02
|
|
|
|
To: 小鱼
[COLOR=blue]当然不能了,590已经不再需要了,也就是说完成了检查点或者恢复了。[/COLOR]
From: eygle 2007.10.21 07:12
|
|
|
|
# 43635
sjl
|
|
To: eygle
谢谢您对我的问题(exp/imp之后,job的问题。)的答复!
还得麻烦问一下,导入/导出的哪些参数会影响到job。
我的导出脚本:
exp system/password owner=test rows=y indexes=n compress=n buffer=655360file=e:\test.dmp log=e:\test.log;
导入脚本:
imp \'sys/oracle as sysdba\' fromuser=TEST touser=TEST file=/test.dmp rows=ybuffer=4096000 log=/test.log
谢谢!
From: sjl 2007.10.17 19:28
|
|
|
|
To: sjl
[COLOR=blue]你的导出操作用test用户试试[/COLOR]
From: eygle 2007.10.21 07:11
|
|
|
|
# 43634
xiaofang
|
|
To: eygle
盖老师:
我们的问题问得太简单了吗,您怎么会选择性的回复,把我们给丢了呢,麻烦您
解答下我的疑惑好吗?谢过了
From: xiaofang 2007.10.17 07:57
|
|
|
|
To: xiaofang
[COLOR=blue]
1.Startup过程中要检查很多东西
我说的应该很清楚了,你还可以参考:
http://www.eygle.com/archives/2006/08/event_controlfile_datafile.html
2.那文章中有些观点是错误的
可是我没必要去指出。
[/COLOR]
From: eygle 2007.10.17 08:03
|
|
|
|
# 43633
limh
|
|
To: To eygle
请问32位的ORACLE 9I for windows 能否运行在 64 位的windows2003 上 ?
From: limh 2007.10.17 01:34
|
|
|
|
To: limh
[COLOR=blue]可以[/COLOR]
From: eygle 2007.10.17 05:49
|
|
|
|
# 43631
sjl
|
|
To: eygle
exp/imp之后,job的问题。
我采用按用户exp/imp之后,发现job的信息有些变化,如下:
SELECT JOB, LOG_USER, PRIV_USER, SCHEMA_USER FROM DBA_JOBS
原来的信息:
JOBLOG_USER PRIV_USER SCHEMA_USER
6TESTTEST TEST
导入后信息:
JOBLOG_USER PRIV_USER SCHEMA_USER
6systemsystem TEST
请问这种情况改如何解决?
谢谢!
From: sjl 2007.10.16 05:48
|
|
|
|
To: sjl
[COLOR=blue]这要看你exp/imp的参数是如何定义的[/COLOR]
From: eygle 2007.10.16 07:58
|
|
|
|
# 43629
小鱼
|
|
To: 盖老师
前一个问题的补充:
查看alert_sigma.log
Tue Oct 16 11:32:48 2007
ORA-1100 signalled during: alter database mount
...
Tue Oct 16 11:33:11 2007
alter database open
Tue Oct 16 11:33:11 2007
Beginning crash recovery of 1 threads
Tue Oct 16 11:33:11 2007
Started first pass scan
Tue Oct 16 11:33:12 2007
Completed first pass scan
9555 redo blocks read, 365 data blocks need recovery
Tue Oct 16 11:33:12 2007
Started recovery at
Thread 1: logseq 590, block 110964, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 590 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\SIGMA\REDO01.LOG
RECOVERY OF THREAD 1 STUCK AT BLOCK 252900 OF FILE 11
From: 小鱼 2007.10.15 22:19
|
|
|
|
|