Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    8

    Unanswered: circular logging vs archive logging

    I am using circular logging and I perform a load. Will the database be in copy / backup pending?

    I am using archive logging enables and I perform a load. Will the database be in copy / backup pending?

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I don't think it matters what logging mode the database uses.

    PS. Is this some kind of an interview question?

  3. #3
    Join Date
    Aug 2004
    Posts
    138
    in circular logging, the tablepaces will not be placed in backup pending

    in archival mode, you have to specify 'copy yes use tsm' or 'nonrecoverable' at the end of load statement to avoid backup pending state

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •