DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Oracle Database Installation

  1. #11
    Join Date
    Feb 2014
    Posts
    11
    SQL> select file#,status,bytes from v$datafile;

    FILE# STATUS BYTES
    ---------- ------- ----------
    1 SYSTEM 734003200
    2 ONLINE 629145600
    3 ONLINE 681574400
    4 ONLINE 5242880

  2. #12
    Join Date
    Feb 2014
    Posts
    11
    SQL> show parameter background

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    background_core_dump string partial
    background_dump_dest string e:\opt\oracle\apps\diag\rdbms\
    dev1\dev1\trace
    SQL>

  3. #13
    Join Date
    Feb 2014
    Posts
    11
    All the file system in the database are located at E:\opt\oracle\apps\oradata\dev1
    3 Online Redologs are of 51201kb
    Below are the size of other datafiles.

    SQL> select file_name,bytes,status from dba_data_files;

    FILE_NAME
    --------------------------------------------------------------------------------
    ----------------------------------------------------------------------
    BYTES STATUS
    ---------- ---------
    E:\OPT\ORACLE\APPS\ORADATA\DEV1\SYSTEM01.DBF
    734003200 AVAILABLE

    E:\OPT\ORACLE\APPS\ORADATA\DEV1\SYSAUX01.DBF
    629145600 AVAILABLE

    E:\OPT\ORACLE\APPS\ORADATA\DEV1\UNDOTBS01.DBF
    681574400 AVAILABLE

    E:\OPT\ORACLE\APPS\ORADATA\DEV1\USERS01.DBF
    5242880 AVAILABLE

  4. #14
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should try putting the database into archive log mode and setting up rman backups.

  5. #15
    Join Date
    Feb 2014
    Posts
    11
    Ya, I will do this and let you know if facing any issues with RMAN

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