-
SQL> select file#,status,bytes from v$datafile;
FILE# STATUS BYTES
---------- ------- ----------
1 SYSTEM 734003200
2 ONLINE 629145600
3 ONLINE 681574400
4 ONLINE 5242880
-
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>
-
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
-
You should try putting the database into archive log mode and setting up rman backups.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|