LESSON # 11:

You will learn:

About the Extended Composite Partitioning with an example

More ...

LESSON # 12:

You will learn:

About a table compression on your database

Example of an Oracle table compression

More ...

LESSON # 13:

You will learn:

How to create an Oracle standby database using RMAN

How to add or change the INIT parameters file on your primary database

How to add standby redo log files on your primary database

How to modify your tnsnames.ora on your primary and standby servers

How to modify your listener on your primary and standby servers

How to use RMAN to duplicate the standby database with its primary database

How to use the DUPLICATE command

More ...

LESSON # 14:

You will learn:

More about the Oracle Management Agent (OMA)

How to install it using CD, download or OMS

How to start the EM agent

How to stop the EM agent

More ...

LESSON # 15:

You will learn:

More about the Oracle Management Service (OMS)

How to use the opmnctl statement to start and stop all components

How to use the emctl statement to start all and stop components

How to get to it

More ...

LESSON # 16:

You will learn:

About password case sensitivity

How to revert password case insensitivity. If you had been using previous release of Oracle databases, you could type or enter your password with no case sensitivity. Now to prevent any future failed login, you should know how to revert case insensitivity.

More ...

LESSON # 17:

You will learn:

What the LogMinor restrictions are

How to use the Oracle LogMinor utility

How to enable LogMinor

How to start LogMinor

How to retrieve data

How to stop LogMinor

More ...

LESSON # 18:

You will learn:

How to change the SYSMAN user password for the Grid Control

How to change the password in the database

How to change the password in the Enterprise Manager Configuration file

More ...

LESSON # 19:

You will learn:

How to compress and uncompressed an Oracle exported dump file in UNIX or LINUX

How to compress when you use the exp command

How to un-compress when you use the imp command

More ...

LESSON # 20:

You will learn:

How to create a data guard database

What to be changed on the INIT primary parameter file

What to be changed on the listener.ora and tnsnames.ora files

More ...

LESSON # 21:

You will learn:

How to create and configure data guard broker (dgmgrl)

How to add primary and standby databases to the configuration file

How to switchover

How to failover

What the difference between switchover and failover is

How to enable flashback

How to remove your configuration file

How to show and edit your configuration file

How to start an observer

More ...