amolghadge
asked on
Oracle - read only Tablespace
What happens internally in Oracle .... when we put tablespace in read only mode ?
ASKER
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
* 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