| SCN on Read only Tablespace [message #474637] |
Tue, 07 September 2010 14:57  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi,
Need a clarifications on a logical SCN synchronization.
1) How the oracle locates the files in the same locations at Restore.
2) What is the relationship between the current SCN and the location of other physical files (which has not the current SCN no's file)?
3) As the oracle needs to check the current SCN with the control file and datafiles at the time of recovery. What if I drop a read only Tablespace (which has old SCN no)?
4) or oracle will check all the old and new SCN no before turn the database up?
Thanks in advance
|
|
|
|
| Re: SCN on Read only Tablespace [message #474638 is a reply to message #474637] |
Tue, 07 September 2010 15:02  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1) What does this mean? They are at the same location is this not sufficient to locate them?
2) No one
3) Read only status is also in the header of the datafile
4) Don't understand the question
It should be better the whole stuff you try to understand, your questions are cryptic.
Regards
Michel
[Updated on: Tue, 07 September 2010 15:05] Report message to a moderator |
|
|
|
| Re: SCN sync with relocated physical files [message #474640 is a reply to message #474638] |
Tue, 07 September 2010 15:40 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi Michel,
Share your views on the below statements.
1) I hope there is no relationship of the physical file location and the SCN of that physical files. Because the physical files locations are mentioned in the init parameter files.
2) Will the oracle checks SCN with all the datafile and the control file for the latest SCN only or every old SCN, which happened in that physical files?
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
