Oracle Managing Oracle Storage | Managing Database Storage Structure | Oracle DBA Training

Oracle Managing Oracle Storage | Managing Database Storage Structure | Oracle DBA Training Oracle tablespaces and allocation types.
Small file (default) and big file tablespaces.
Create datafiles with fixed size and auto extend option.
Temporary tablespaces and temporary tablespace groups.
Control files.
Managing Undo Data
Explain DML and undo data generation
How to add data files to undo tablespaces.
Configure undo retention.
Understand Oracle database read consistency
An Oracle database is made up of physical and logical structures.
Physical structures are visible in the operating system.
An example of a physical structure is an operating system file that stores data on a disk.
Logical structures are defined and known to the Oracle Database server, but are not known to the operating system.
An example of a logical structure is a tablespace.

Select Redo Log Groups in the Storage menu.
The Redo Log Groups page lists the redo log groups that have been configured for your database.
A value of Current in the Status column indicates the group that is currently being written to.
If the redo log groups are multiplexed, more than one member is shown for the group.
3. Click ORCL to return to the Database Home page.

Select Archive Logs in the Storage menu.
The Archive Logs page is displayed.
If your database is not in ARCHIVELOG mode, you will not have any archived redo log files.
Click ORCL to return to the Database Home page.
The online redo log files contain entries that are used to recover transactions in the event of an instance failure.
To ensure that redo entries are not lost in the event of a disk drive failure, redo log files should be multiplexed so that each group has multiple members.
To multiplex the redo log file, perform these steps:
Select “Redo Log Groups” in the Storage menu.
Select the first redo log group and click “Add Member.”
Visit www.theskillpedia.com for Online Training on this technology
oracle database architecture,oracle database,oracle database (software),oracle database tutorial,database storage structures,oracle,database,oracle storage structure,oracle logical data structures,storage structure,oracle tutorial,database storage structure,oracle database files,storage structures in oracle,storage structure of oracle,oracle db – storage structure,managing database storage structure,tutorial on oracle logical database structure