Hello,
How Can I make database read only ? Is there any other way to make database read only other than making all the tablespaces read only mode.
Thanks for your help
Printable View
Hello,
How Can I make database read only ? Is there any other way to make database read only other than making all the tablespaces read only mode.
Thanks for your help
The schema owner has priv of insert/update/delete.
How ever, for all other user, you can give select priv only.
Tamil
startup the database in read only mode
Do I need to give "Startup Read only" . If so How do I startup the database if needed to insert or update.
Thanks,
startup mount
alter database open read only
Check manuals for STARTUP (SQL*Plus) and ALTER DATABASE OPEN (SQL) commands.
http://download-west.oracle.com/docs...13.htm#1013862
http://download-west.oracle.com/docs...htm#SQLRF00802
I did put my database in read only and in no archivelog mode. I wanna take weekly cold back up.
Can I take coldback if my database in in read only mode .
Thanks
the definition of a cold backup is with everything shut down.
Do you mean can you simple copy the datafiles? I wouldnt try that
If you want to do (proper) cold backup your database won't be neither in read-only nor in read-write mode - it will be closed!
Except with RMAN where the DB instance must be mounted.Quote:
Originally posted by davey23uk
the definition of a cold backup is with everything shut down.