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

Thread: Non-archive mode to archive mode

  1. #1
    Join Date
    Sep 2003
    Location
    Washington DC area
    Posts
    12

    Cool Non-archive mode to archive mode

    Morning, I was able to get the same admin account that loaded the database on the server. Once log in, I restarted the services, logged in to OEM and started the process again(changing from Non-archive to archive mode). At this point I make the change in OEM to Archive Log Mode to turn on the Archive utility so the rollback segment utility can work proprely. Again, once the database in shutdown and the startup process begins The TNS is not recogized unless the service are turned off and then on again. This just get me back to were I started from. A database in Non-archive mode. Please advise.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I'm not sure about what you wrote, but in order to put a database in archivelog mode you need to specify the right parameters in your init file, and shutdown the database and then startup in mount mode and enter the following command, "ALTER DATABASE ARCHIVELOG;" Then open the database. I inlcuded a link on putting a database in archivelog mode. Tahiti.oracle.com is always a good place to look for Oracle information.

    http://download.oracle.com/docs/cd/B...redo.htm#14904

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    ...also don't forget to revise your backup/recovery strategy. Chances are your initial strategy was relying on cold backup; I suppose your business requirements are now asking for point-in-time recovery... otherwise please let me know why you are moving from noarchivelog to archivelog.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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