DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: database read only

  1. #1
    Join Date
    Oct 2003
    Posts
    38

    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

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The schema owner has priv of insert/update/delete.
    How ever, for all other user, you can give select priv only.

    Tamil

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    startup the database in read only mode

  4. #4
    Join Date
    Oct 2003
    Posts
    38
    Do I need to give "Startup Read only" . If so How do I startup the database if needed to insert or update.
    Thanks,

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    startup mount
    alter database open read only

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  7. #7
    Join Date
    Oct 2003
    Posts
    38
    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

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the definition of a cold backup is with everything shut down.

    Do you mean can you simple copy the datafiles? I wouldnt try that

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width