checkpoint scn
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: checkpoint scn

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    HI FOLKS,
    What is the difference b/n checkpoint SCN and checkpoint counter

    reards
    sonia

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Checkpoint counter gets updated even when the checkpoint info in the file header is frozen, during a hot backup.
    So for instance if you replace a current datafile with a recent backup, oracle will yell at you.
    That's the practical aspect.
    for def'n check doc's.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Feb 2002
    Posts
    267
    Thanx tarry......

    Does differnt datafiles have different checkpoint counters ?

    Or should all be in sync....
    regards
    sonia

  4. #4
    Join Date
    Aug 2002
    Posts
    2

    Yes

    Hi ,

    the all datafile should be sync excuding read only tablespce .

    reg
    Mohammed

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