Sunday, 16 March 2014

Various Components of Physical database structure?

What are the various Components of Physical database structure?


The various components of Physical database structure are CRD files

Control files     i.e. for example /u01/oracle/app/oradata/pavan/tntt/control.ctl
Redo log files i.e. for example /u01/oracle/app/oradata/pavan/tntt/redo01.log
                                             /u01/oracle/app/oradata/pavan/tntt/redo02.log
Data files        i.e. for example /u01/oracle/app/oradata/pavan/tntt/system01.dbf
                                        /u01/oracle/app/oradata/pavan/tntt/sysaux01.dbf
                                        /u01/oracle/app/oradata/pavan/tntt/undotbs01.dbf
                                        /u01/oracle/app/oradata/pavan/tntt/users01.dbf



To know these paths use the following commands/queries in sql prompt:
select FILE_NAME from dba_data_files;
show parameter control_files;

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...