Oracle - read only Tablespace

What happens  internally in Oracle   .... when we put tablespace in read only mode ?
LVL 1
amolghadgeAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>1) While bringing up the database--> will not there be a inconsistency in SCN of these files compared to others ?
no, because the tablespace is marked as readonly and that with the SCN in question in the control file. no issues

2) answered by 1. when recovering, oracle knows when the tablespace got into readonly mode, and will not need to restore anything on these tablespaces after that SCN.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well:
* all queries on that tablespace don't need to get any locks
* the data files don't get updated with the SCN any longer
* updates are not allowed on such a tablespace
0
 
amolghadgeAuthor Commented:
Considering  the second point :- the data files don't get updated with the SCN any longer .

At this point of time I  bring down the database and take a backup .

1) While bringing up the database--> will not there be a inconsistency in SCN of these files compared to others ?


2) What if I am using this backup and recovering on later dates using archivelogs ?






0
 
MohanKNairCommented:
The following links may give some info

Riddles of Read-Only Tablespace
http://www.orafaq.com/papers/readonly.doc

The benefits and drawbacks of having read-only tablespaces as well as several recovery scenarios
http://www.fors.com/orasupp/rdbms/dba/33402_1.HTM

Oracle Features for the Data Warehouse
http://www.remote-dba.net/tp_Oracle_read-only_tablespace.htm

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.