س

س

̳ʹݿе

Լ 20

̳̰⣺

ڴͼԼغͲ鿴̵̳Ļͼ 棺Ϊ˲ͬʱĻͼٽʱӦʱܻȽϳ

ע⣬внÿͼϣӶغͲ鿴òصĻͼͨĻͼء

ʲô

һ߼ָѡݿʱعĿͨдд (WAW) ϵУ޸ĿĵͬһݣԼϵУ²ĿɾͬһֵϵһóΪɵִвԱ㽫Ӱݻָԭʼ״̬

б

ʼ̳֮ǰӦã

1.

ͨ Linux ϰװ Oracle ݿ 11g ̳װݿ⡣

2.

flatxn.zip ļѹĹĿ¼ wkdirС

б

Ի

ҪòԻΪ OBE ִ²裺

1.

Ŀ¼ SYS ûִ flatxn_archivelog.sh ű

./flatxn_archivelog.sh

ýűὫ HR û ARCHIVELOG ģʽ

2.

ʹ SQL*Plus SYS ûӵݿ⣬ flatxn_setup1.sql ű

sqlplus / as sysdba
@flatxn_setup1.sql


ýűݿ HR ûΪسע ALTER DATABASE GRANT

[Enter] ִнűһ

3.

ýű HR ûӵݿ⣬һ񣬸DzС

[Enter] ִнűһ

4.

ýűڶ񣬸ǸղŲС⽫һдд (WAW) ԡ»ɾѾ£˵ WAW ԡ

[Enter] ִнűһ

5.

ýű񣬸ǸУһѾǰһи¡˲һ WAW ԡ

[Enter] ִнűһ

5.

ýűĸ񣬸Ǹһ 1 вС˲һ WAW ԡ

[Enter] ִнűһ

6.

󣬽ű SYS ûӵݿ⣬л浵־Ҫһ浵־

[Enter] ˳ű

б

Ծдд (WAW) ԣζţ»ɾѾǰһ¡ڱУϣһ䵼´ĵ WAW ִ²裺

1.

URL ¼ҵݿƣ <hostname> Ϊָ

https://<hostname>:1158/em

2.

Ҫ¼ҵϸϢȻ󵥻 Login

User Name:sys
Password:oracle
:SYSDBA

3.

HR.REGIONS ĸģϣ鿴ıݡ Schema ѡҳ棬

Ȼ󵥻 Tables

4.

Ҫ鿴 HR ģʽûб Schema HRȻ󵥻 Go ť

5.

HR ʾȣѡ HR.REGIONS Ȼ Actions бѡ View Data Actions б Go ťԲ鿴 HR.REGIONS еݡ

6.

ڲ鿴ʱΪӦðɫеС OK

7.

صбѡ HR.REGIONS Ȼ Actions бѡ Flashback Transaction Actions Go ť

8.

IJѯָȷŵִдĵʱΡڱĬϵʱΣһСʱȻ󵥻 Next

ʾ Processing:Mining Transactions ڣͬʱΪʱδ־

9.

Flashback Transaction:Select Transaction ҳϣѡ 2 Transaction ID ӡ

10.

Select Transaction:Show Details ҳϣ鿴 UPDATE Ȼ󵥻 OK

11.

Next ʶ񣬲Ҫĸġ

ʾ Processing:Flashback Transaction

12.

Flashback Transaction:Show Dependencies ҳϣһ Transaction ID

13.

Show Dependencies:Details ҳϣ鿴ע⣬ûִκβ񡣻Ҫע⣬ #10 ĸ±Ϊ[exec=no]ζŲִΪһ󣬷ϵͳִ񡣵 OK

14.

Flashback Transaction:Show Dependencies ҳϣ Change Recovery Option

15.

Show Dependencies:Change Recovery Option ҳϣѡ CascadeҲ᳷ģȻ󵥻 OK

ʾ Processing:Flashback Transaction

16.

Flashback Transaction:Show Dependencies У Next

17.

ϸ鿴ϢȻ󵥻 Finish

18.

ѳɹִС OK

19.

Բ鿴 HR.REGIONS Ŀǰݡѡ HR.REGIONS Ȼ Actions бѡ View Data Go

20.

23 4 ȻΪStill called VenusΪ 2 4 ֮û WAW ԡ

б

ִ²

1.

SQL*Plus ỰУִ flatxn_cleanup1.sql ű

2.

ڣϣ flatxn_cleanup.sh رմ浵־ִ

./flatxn_cleanup.sh 

б

ڱ̳Уѧϰγ WAW Ե

б

ڸͼϿеĻͼ

 

 

 

寄送此页面
Printer View 打印机视图