+ Reply to Thread
Results 1 to 10 of 10
  1. 10-13-2003 02:53 PM #1
    prince_jr
    prince_jr is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 10-13-2003 03:04 PM #2
    tamilselvan
    tamilselvan is offline Moderator
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    The schema owner has priv of insert/update/delete.
    How ever, for all other user, you can give select priv only.

    Tamil
    Reply With Quote Reply With Quote
  3. 10-13-2003 03:20 PM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    startup the database in read only mode
    Reply With Quote Reply With Quote
  4. 10-13-2003 03:34 PM #4
    prince_jr
    prince_jr is offline Junior Member
    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,
    Reply With Quote Reply With Quote
  5. 10-13-2003 04:10 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    startup mount
    alter database open read only
    Reply With Quote Reply With Quote
  6. 10-13-2003 04:12 PM #6
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  7. 10-15-2003 04:07 PM #7
    prince_jr
    prince_jr is offline Junior Member
    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
    Reply With Quote Reply With Quote
  8. 10-15-2003 05:07 PM #8
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    the definition of a cold backup is with everything shut down.

    Do you mean can you simple copy the datafiles? I wouldnt try that
    Reply With Quote Reply With Quote
  9. 10-15-2003 05:09 PM #9
    jmodic
    jmodic is offline Super Moderator
    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?
    Reply With Quote Reply With Quote
  10. 10-16-2003 06:06 AM #10
    julian
    julian is offline Senior Advisor
    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
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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