Home » RDBMS Server » Backup & Recovery » SCN on Read only Tablespace (Oracle 9i.0.2, Windows. )
SCN on Read only Tablespace [message #474637] Tue, 07 September 2010 14:57 Go to next message
muktha_22
Messages: 356
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 Go to previous messageGo to next message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
muktha_22
Messages: 356
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.
Re: SCN sync with relocated physical files [message #474641 is a reply to message #474640] Tue, 07 September 2010 15:44 Go to previous message
Michel Cadot
Messages: 57611
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) No. Check your init.ora,you will find NO file location (but control files).
2) When?

Regards
Michel
Previous Topic: Logon to Target & Catalog DB.
Next Topic: Backup Archivelog with standby
Goto Forum:
  


Current Time: Fri Apr 18 13:26:19 CDT 2014

Total time taken to generate the page: 0.06825 seconds