No question at this time
DBA Top 10
1 M. Cadot 22600
2 A. Kavsek 15200
3 M. Hidayathullah ... 11000
4 B. Vroman 8100
5 P. Wisse 6000
6 T. Boles 5200
7 J. Schnackenberg 3300
8 G. Lambregts 2200
8 P. Knibbs 2200
8 K. Pagadala 2200
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48017
Total active users1850
Act. users last 24h5
Act. users last hour0
Registered user hits last week339
Registered user hits last month1183
Go up

oracle architecture
Next thread: difference between LAST_ANALYZED of dba_tables and STATS_UPDATE_TIME column of dba_tab_stats_history
Prev thread: Need to Migrate database from windows server to Solaris 11

Message Score Author Date
Hi experts, Need some clarifications on the sce...... akshay rai Apr 18, 2017, 07:22
Rollforward applies only on blocks that have an ...... Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts Michel Cadot Apr 18, 2017, 07:39
Thanks a lot:)... akshay rai Apr 18, 2017, 08:06

Follow up by mail Click here


Subject: oracle architecture
Author: akshay rai, India
Date: Apr 18, 2017, 07:22, 123 days ago
Message: Hi experts,

Need some clarifications on the scenario given below,

Consider a scenario where a committed data is being written to the data blocks by the DBwr. Lets say at this point the instance crashes. Now as a part of instance recovery, all the entries in the online redo logs will be rolled forward and all the uncommitted data will be rolled back.

During rollforward, Since some of the committed data was already written to the data blocks by the DBWr, Shouldn't the database through some error like unique constraints or something.( I know it doesnt and rollforward does happen smoothly) . All i wanna know is how exactly it is done.

thanks in advance




Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle architecture
Author: Michel Cadot, France
Date: Apr 18, 2017, 07:39, 123 days ago
Score:   Score: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 PtsScore: 700 Pts
Message:
Rollforward applies only on blocks that have an SCN lower than the SCN in the redo record currently applied.
So if during rollforward Oracle encounters for a data file block with an SCN greater or equal to the SCN in the redo record it just skips it as it knows the job is already done.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: oracle architecture
Author: akshay rai, India
Date: Apr 18, 2017, 08:06, 123 days ago
Message: Thanks a lot:)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here