-
database read only
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
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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!
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Originally posted by davey23uk
the definition of a cold backup is with everything shut down.
Except with RMAN where the DB instance must be mounted.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|