archival & no archival issues
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: archival & no archival issues

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    Thumbs up

    I shut my database down immediate
    I changed my database from Archive mode to noarchive mode by commenting
    these parameters:

    #log_archive_start = true
    #log_archive_dest = /11/oracle02/TESTDB/archive
    #log_archive_duplex_dest = /oracle_direct/TESTD/archive
    #log_archive_format = "arch%S.arc"

    After I start the database as sys.

    I later tried to connect using a username that has dba priveledges.
    For 30 minutes, I could not connect. But If I connect as sys, no problem.
    Has anyone ever experienced this problem? What's going on?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    did you switch your database to noarchivelog mode?

    http://technet.oracle.com/docs/produ...e3.htm#2049046

    Most likely, your logfiles need archiving.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    I think that you forgot to put the database in NOARCHIVE MODE using : alter database noarchivelog
    (!!! : the database must be mounted not opened).

    Hope this helps

  4. #4
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    If you want to switch your database to archive mode , you can not just change your parameter file . (type archive log list , it will show you which mode your database is)

  5. #5
    Join Date
    Oct 2001
    Posts
    83
    Hello,

    I have forgotten to give you a way to see if the DB is in ARCHIVELOG or NOARVHIVELOG Mode. launch :

    select * from v$database;


    Hope this helps

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