Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

教えてください(update)

872206Jun 29 2011 — edited Jun 29 2011
oracle10gR2

下記のようなことをupdate1文で行ないたいのですが
教えていただけませんでしょうか?

id,name,no
------------
1,xxx,0
2,yyy,0
3,xxx,0
4,aaa,0
5,bbb,0
6,ccc,0
7,xxx,0
8,yyy,0
9,xxx,0

というテーブルがあったとすると
name=xxxxのレコードをid順に、noを1,2,・・・と更新するというものです。

期待結果
id,name,no
------------
1,xxx,1
2,yyy,0
3,xxx,2
4,aaa,0
5,bbb,0
6,ccc,0
7,xxx,3
8,yyy,0
9,xxx,4

分かりにくくて申し訳ありませんがお願い致します。
This post has been answered by hatahata on Jun 29 2011
Jump to Answer

Comments

Pavan Kumar

Hi,

1. Do you have orapwd<ORACLE_SID> password in sync on primary and standby ?

2. Do you hosted static listener on standby node with Ur=A ?

3. Please execute same from source server and verify instead of executing from target server

Is this production server ?

I didn't stressed on the parameters - hope you have verified them

- Pavan Kumar N

JuanM

In addition to @"Pavan Kumar" answer,

Try to validate the steps posted here by Kamran Bakhshandeh

https://www.pythian.com/blog/duplicate-from-active-database-using-rman-step-by-step/

and validate if some step are missing.

AJ

Pavan Kumar skrev:

Hi,

1. Do you have orapwd<ORACLE_SID> password in sync on primary and standby ?

2. Do you hosted static listener on standby node with Ur=A ?

3. Please execute same from source server and verify instead of executing from target server

Is this production server ?

I didn't stressed on the parameters - hope you have verified them

- Pavan Kumar N

Ref point 2: You actually need to have the instance statically registered with the listener on both primary and standby for active duplicate to work.

AJ

Pavan Kumar

That's what my point is and asked for the same directly, perhaps only required on standby node - not on primary. Since standby instance can't be registered nomount phase.

Hemant K Chitale

Both Oracle_Homes must have the same Password file (the file name would be different).

Both Oracle_Homes must have tnsnames.ora entries pointing to each other.

Hemant K Chitale

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 27 2011
Added on Jun 29 2011
3 comments
411 views