Archive files - backup.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Archive files - backup.

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I have taken the hotbackup of the 2 tablespaces I have.I intend to do this once in a week and during the remaining days want to take the arch file backup.
    I have enabled archiver log (in the init.ora) . However there are no arch files created in the %orahome%db%arch directory.

    Does it mean that the arch files are not getting created ?

    Please advice me how to take the arch file backup, alternatively.

    Badrinath

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    Logs are archived only when the current log switches.
    Check the Alert log to see that the logs are switching.
    Or do following on sql/plus to force a switch --

    alter system witch logfile;

    - Rajeev

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    First, you have to make sure your database is in archivelog mode:
    select log_mode from v$database;

    If the value is "ARCHIVE", then you are in archive log mode. If not, you have to shutdown your database and bring it up in exclusive mode. Then, issue
    alter database archivelog
    Shutdown, and restart your database.

    Next, force a log switch.
    alter system switch logfile

    Then, look in v$archived_log to see if you have archived anything.
    select name, to_char(completion_time, 'mm/dd/yyyy hh24:mi:ss') comptime
    from v$archived_log
    order by completion_time

    This will give you the name of the file that was archived. Go to your OS and see if that file is there.
    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."

  4. #4
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    Also make sure that parameter LOG_ARCHIVE_START is set to TRUE in init.ora. Then archiver will automatically archive rhe file once the log switch occurs.

    Baliga

  5. #5
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Apart from Archiving enabling in Init.ora, you need to issue
    Alter Database Archivelog;

    Then it starts creating the Archive logs
    Thanks
    Kishore Kumar

  6. #6
    Join Date
    Jan 2001
    Posts
    642
    Thank You all, It's working
    Badrinath

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