1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Archive mode

Discussion in 'Server Administration and Options' started by kimipatel, Sep 25, 2012.

  1. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    Hi,

    I installed Ora 10g. N i have created 1 database. How to make my database in Archive mode? Which command or path i should write. For Example my database name is test1.
    Database created in F drive.. Should any one tell me?

    Thanks.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You cannot simply put a database into archivelog mode without some serious preparation -- you will need an archivelog location and space to write the logs. You will also need a job to backup the archivelogs and delete those that have been backed up to keep space clear for new logs. You will need enough storage to provide 2 to 3 days of database operation in the event the backup job fails. Only then can you put your database into archivelog mode.

    I will not give such instructions until you have reported back comopletion of the above steps.
     
  3. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    OK. As you said. I know I have enough space in my location. N i know i have to deleted old Archive log. I doesn't have large database. I want to do just for Practice. So can you tell me Steps?
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Certainly and if your database stops processing data because the destination is full I did warn you.

    You will need to set log_archive_dest_1 to the directory where you want the logs written, for example:

    alter system set log_archive_dest_1='c:\i_should_listen_to_others';

    To verify this is set:

    show parameter dest_1

    You will now need to enable that destination:

    alter system set log_archive_dest_state_1=enable;

    You now need to shutdown your databse:

    shutdown immediate

    Start it in mount mode:

    startup mount

    Change the log mode:

    alter database archivelog;

    Shutdown the database and restart it:

    shutdown immediate
    startup

    The database is now in archivelog mode.
     
  5. kimipatel

    kimipatel Active Member

    Messages:
    53
    Likes Received:
    1
    Trophy Points:
    140
    I will keep in mind. Thanks.
     
  6. deeplydrink

    deeplydrink Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    1.use alter command to set the arch dest location

    alter system set log_archive_dest_1='location='/path'' scope=spfile

    reboot the instance

    2.shutdown instance and bring the instance to mount stage

    3.alter database archivelog

    4.alter database open
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You really should get into the habit of enabling the archivelog destination. Simply because the default setting is enable doesn't mean it will actually work without being set. I have had as many successes as failures when I didn't explicitly enable the destination.