datafile online/offline
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: datafile online/offline

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    hi folks,

    I have some basic doubts......

    1. How to find out whether a datafile is online or offline.
    status column of dba_data_files only lists whether
    availability.

    2. How to flush or clear online redo log files.

    regards
    sonia

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    1. select a.file_name, b.status
    from dba_data_files a, v$datafile b
    where a.file_id=b.file#;

    2. You can not flush or clear online redo log files but you can switch or archive them.

    Alter system switch logfile;
    Alter system archive log current;


    Sanjay

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In fact you can clear them...

    alter database clear logfile;

    Sanjay

  4. #4
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    Hi soniya

    I have query why u normally need to flush the redo logfiles ?

    Any syntax is
    alter database clear logfile group 1 ;


    bye
    viraj
    A Wise Man Knows How much he doesn't know !!!

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by virajvk
    I have query why u normally need to flush the redo logfiles ?
    You clear logfiles when you have lost a redo log file or when
    that file is corrupted. Then, this file is neglected and reinitialized. What Oracle does is the following: it recreates the file even if it did not exist (physically) and fills it with zeroes.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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