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;
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:
Post a Comment