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

Thread: Alter System Check Datafiles

  1. #1
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133

    Alter System Check Datafiles

    Hi team list,

    What is the purpose of "ALTER SYSTEM CHECK DATAFILES" command and when to use it?
    I have tried something like below :

    SQL>alter database datafile '/u01/oradata/TBSTEST/test_02.dbf' offline ;

    Database altered.

    SQL>alter system check datafiles ;

    System altered.

    So even there is no alert file created from this command.

    Your inputs are appreciated

    TIA
    Giani

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    CHECK DATAFILES
    In a distributed database system, such as an Oracle Parallel Server environment,
    this clause updates an instance’s SGA from the database control file to reflect
    information on all online datafiles.
    Your instance should have the database open.
    GLOBAL Specify GLOBAL to perform this synchronization for all instances
    that have opened the database. This is the default.
    LOCAL Specify LOCAL to perform this synchronization only for the local
    instance.
    -nagarjuna

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