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

Thread: checkpoint scn

  1. 08-26-2002, 01:15 AM #1
    Sonia
    Sonia is offline Senior Member
    Join Date
    Feb 2002
    Posts
    267
    HI FOLKS,
    What is the difference b/n checkpoint SCN and checkpoint counter

    reards
    sonia
    Reply With Quote Reply With Quote
  2. 08-26-2002, 05:35 AM #2
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    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---
    Reply With Quote Reply With Quote
  3. 08-26-2002, 05:40 AM #3
    Sonia
    Sonia is offline Senior Member
    Join Date
    Feb 2002
    Posts
    267
    Thanx tarry......

    Does differnt datafiles have different checkpoint counters ?

    Or should all be in sync....
    regards
    sonia
    Reply With Quote Reply With Quote
  4. 08-26-2002, 06:33 AM #4
    Mkhan
    Mkhan is offline Junior Member
    Join Date
    Aug 2002
    Posts
    2

    Yes

    Hi ,

    the all datafile should be sync excuding read only tablespce .

    reg
    Mohammed
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width