No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
finding checkpoint# in controlfile - vs autobackup checkpoint_change#
| Message |
Score |
Author |
Date |
   Hi all,
1) Done a checkpoint to make sure all c...... |
|
sze jie koh |
Aug 09, 2015, 22:34 |
|
Why did you start a new thread for the questions...... |
|
Michel Cadot |
Aug 10, 2015, 08:33 |
| Hi Michel,
It has always been you and maybe jus...... |
|
sze jie koh |
Aug 10, 2015, 11:18 |
|
>>> <i> While the thread here is asking about ho...... |
|
Michel Cadot |
Aug 10, 2015, 11:55 |
| Hi Michel,
It is indeed a misunderstanding then...... |
|
sze jie koh |
Aug 10, 2015, 19:31 |
| Subject: |
finding checkpoint# in controlfile - vs autobackup checkpoint_change# |
| Author: |
sze jie koh, Singapore |
| Date: |
Aug 09, 2015, 22:34, 2854 days ago |
| Os info: |
Linux64 |
| Oracle info: |
11gR2 |
| Message: |
Hi all,
1) Done a checkpoint to make sure all checkpoint_change# scn are in sync.
select null, null, checkpoint_change#,null from v$database
union all
select file#, name, checkpoint_change# , last_Change# from v$datafile;
4095405
1 +DATA/orcl/datafile/system.268.884148927 4095405
2 +DATA/orcl/datafile/sysaux.269.884149053 4095405
3 +DATA/orcl/datafile/undotbs1.270.884149167 4095405
4 +DATA/orcl/datafile/usernew1.dbf 4095405
5 +DATA/main/datafile/test.343.887323655 4095405
2)run a fulbackup and execute same query as above
select null, null, checkpoint_change#,null from v$database
union all
select file#, name, checkpoint_change# , last_Change# from v$datafile;
4095405
1 +DATA/orcl/datafile/system.268.884148927 4095581
2 +DATA/orcl/datafile/sysaux.269.884149053 4095581
3 +DATA/orcl/datafile/undotbs1.270.884149167 4095581
4 +DATA/orcl/datafile/usernew1.dbf 4095581
5 +DATA/main/datafile/test.343.887323655 4095581
q1) why does the checkpoint_change# in v$database remain the same and it's not the same as checkpoint_change# in v$datafile anymore after the backup ?
list backup;
...
Control File Included: Ckp SCN: 4095640
q2) why is the Ckp SCN in the autobackup even later then the checkpoint_change# in v$database ?
q3) how do i find the latest checkpoint_change# in the current controlfile then ?
Regards,
Noob
|
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: finding checkpoint# in controlfile - vs autobackup checkpoint_change# |
| Author: |
Michel Cadot, France |
| Date: |
Aug 10, 2015, 08:33, 2854 days ago |
| Message: |
Why did you start a new thread for the questions we were talking about?
I feel it as an insult towards me; it is like you say me "what you told is bullshit, I will talk with someone else".
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: finding checkpoint# in controlfile - vs autobackup checkpoint_change# |
| Author: |
sze jie koh, Singapore |
| Date: |
Aug 10, 2015, 11:18, 2854 days ago |
| Message: |
Hi Michel,
It has always been you and maybe just a few that are replying to my questions, so there is no need for me to try my luck to open another thread so as to get others to reply me in here. There will not be any others except the few regulars anyway.
I would never think that you reply is bullshit else i would not even come here. I have been here for years and i always respect your contribution and answers.
The two threads are related but is asking different questions.
The 1st thread earlier is asking what is the use of checkpoint#_change in v$database
While the thread here is asking about how do we find the current checkpoint_change# in controlfile vs autobackup CkpSCN.
I thought it would always be good to separate questions that are different even though they are related.
====================================
In any case, i apologize for the misunderstanding and you can delete the thread over here if needed.
Lastly, i hope you understand that it has never occur to me at all that "what you told is bullshit, I will talk with someone else". because the reason i am posting here is actually hoping that you (mainly) and maybe the few of the rest here is able to see and get your advices.
I am not sure why have to think and put it that way.
Regards,
Noob
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: finding checkpoint# in controlfile - vs autobackup checkpoint_change# |
| Author: |
Michel Cadot, France |
| Date: |
Aug 10, 2015, 11:55, 2854 days ago |
| Message: |
>>> While the thread here is asking about how do we find the current checkpoint_change# in controlfile
I told you in the other thread that v$database.checkpoint_change# IS the value from the control file.
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: finding checkpoint# in controlfile - vs autobackup checkpoint_change# |
| Author: |
sze jie koh, Singapore |
| Date: |
Aug 10, 2015, 19:31, 2853 days ago |
| Message: |
Hi Michel,
It is indeed a misunderstanding then.
I posted this thread at Aug 09, 2015, 22:34, 20 hours ago - right immediately after the earlier thread but before your reply (on which v$database.checkpoint_change# IS the value from the control file.) @ Aug 09, 2015, 22:47, 20 hours ago
If I have see your reply on the controlfile checkpoint, i would have post the question differently.
Sorry for the misunderstanding.
Regards,
Noob |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|