Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |


Online Oracle Training

Table of contents

DBA Fundamentals II -- Table of contents

Hands-On Oracle Fundamentals II - (User-Managed Backup and Recovery)


Hands-On 01 (Memory Space Allocation on the Fly)

Oracle Memory Structures; Using the V$SGA dictionary view; Fixed Size; Variable Size; Oracle Database Files; Database Size; Datafiles; Redo Buffers; Useful parameters and views to resize memory; SHARED_POOL_SIZE; LARGE_POOL_SIZE; JAVA_POOL_SIZE; DB_BLOCK_BUFFERS; BLOCK_SIZE; DB_CACHE_SIZE; SHARED_POOL_SIZE; LARGE_POOL_SIZE; DB_CACHE_SIZE; SHO PARAMETER; ALTER SYSTEM SET; BUFFER POOL; KEEP; RECYCLE; DEFAULT; DB_KEEP_CACHE_SIZE; DB_RECYCLE_CACHE_SIZE; HOST ERASE; DB_8K_CACHE_SIZE; Views



Hands-On 02 (Oracle Background Processes)

Oracle Background Processes; V$BGPROCESS; PMON; DBWn; ARC0; CKPT; SMON; RECO; Archive log configurations; ARCHIVE LOG LIST; DATABASE LOG MODE; The NOARCHIVELOG mode; The ARCHIVELOG mode


Hands-On 03 (Multiplexing the Control File)

Control Files; Using the V$CONTROLFILE view; Using the V$CONTROLFILE_RECORD_SECTION view; Multiplexing the Control File; Using the INIT.ORA file; Editing the INIT.ORA


Hands-On 04 (Configuring the Database Archive mode)

Configuring The Database Archive Mode; Setting the database to the ARCHIVELOG mode; Querying archive log information; Making a directory; Enabling the automatic archival process; Setting an archive destination; Using The Server Parameter File (SPFILE)


Hands-On 05 (Maintaining Redo Log files)

Redo Log Files; Using the V$LOG view; Archiving a current Online Redo log file; Checking a Online Redo log fileís Status; The INACTIVE status; The ACTIVE status; The CURRENT status; Dropping a Log file Group; Resizing a Redo Log file; Adding a Redo Log file; Managing an Online Redo log file with (OMF); Using the DB_CREATE_ONLINE_LOG_DEST parameter; Using the V$LOGFILE dictionary view; Checking the SEQUENCE# column; Using the V$ARCHIVED_LOG view


Hands-On 06 (Duplexing Archived Online Redo Log files)

Duplexing Archived Online Redo Log files; Setting an Oracle-Managed File destination; Setting a Redo Log Archive Duplex Destination; Querying all of the archive log destinations; Using the LOG_ARCHIVE_DUPLEX_DEST parameter; Using the V$ARCHIVE_DEST view; Using the V$ARCHIVED_LOG view; Checking the sequence archive number; Writing a procedure to generate some logs; Using the V$LOG_HISTORY view; FIRST_CHANGE#; NEXT_CHANGE#; De-activating the duplex archiving


Hands-On 07 (User-Managed COLD or OFFLINE backup)

Performing a User-Managed COLD or OFFLINE backup; Writing a script to perform a complete; COLD; or OFFLINE backups; Using the V$DATABASE view; The ARCHIVE modes; ARCHIVELOG mode; NOARCHIVELOG mode; Using the V$LOGFILE view; Using the V$DATAFILE view; Using the V$CONTROLFILE view; Setting a Control Command; SET ECHO; SET HEADING; SET FEEDBACK; SET PAGESIZE; SET ECHO ON; The password file and the Parameter file (PFILE)


Hands-On 08 (User-Managed HOT or ONLINE backup)

Performing a User-Managed Hot backup; Archiving the current Online Redo Log group; Backing-up a CONTROLFILE to a file or TRACE; Performing the HOT backup; Using the DBA_DATA_FILES dictionary view; Setting a tablespace into the backup mode


Hands-On 09 (User-Managed Tablespaces and Datafiles Backup)

Performing a tablespace and datafiles backup; Performing integrity checks; Using the V$DATAFILE view; Using the DBA_DATA_FILES dictionary view; Understanding the TOTAL PAGES FAILING values; Setting a tablespace while in the OFFLINE mode; The OFFLINE TEMPORARY option; The OFFLINE IMMEDIATE option; Setting a tablespace status


Hands-On 10 (User-Managed Tablespace Recovery)

Performing a tablespace recovery; Using the V$DATABASE view; Checking if a user has created any object; Using DBA_TABLESPACE view; Writing a procedure; HOST erase C:\ORACLE\ORA90\SCHOOL\USERS01.DBF; Permanently damaging datafiles; Restoring a datafiles of a USERS tablespace; Setting a tablespace status; Recovering a tablespace; Using the USER_TABLES view


Hands-On 11 (User-Managed Logical Backup and recovery)

Performing an Oracle Logical Backup and recovery; Using the EXP tool; Using the IMP tool; Dropping a table; Using the V$DATABASE view; Creating a table; Performing a logical backup; HOST EXP system/manager FILE=íxxí TABLES=(xx); Restoring a logical table


Hands-On 01 (RMAN-Managed user and repository)

Creating the RMAN user; Generating the RMAN objects; Creating the Recovery Manager Repository; Creating the RMAN tablespace; Granting privileges to the RMAN user; Granting the RECOVERY_CATALOG_OWNER to the RMAN user; Using the RMAN RCVCAT command; Using the DBA_OBJECTS dictionary view; Using the DBMS_RCVCAT package; Using the DBMS_RCVMAN package


Hands-On 02 (Use of the RMAN commands)

Connecting to the RMAN tool; Using the source and the target database commands; Registering a database; Synchronizing a catalog; Creating a snapshot of a controlfile; Backing up a database; Backing up a datafile; Backing up the current controlfile


Hands-On 03 (Configuration of the RMAN tool)

Configuring the RMAN retention policy; Excluding any tablespaces from a backup; Performing an image copy; Using the CONNECT CATALOG; Using the CONNECT TARGET; Performing an image copy of the data file; Using the NOCHECKSUM parameter; Performing an image copy of the current control file; Using a specific backup naming format


Hands-On 04 (Using the RMAN backup utility)

Performing a backup copy in a specific location; Performing a backup with formatting the backup fileís name; Backing-up database objects using the incremental syntax; Using the %T for the date; Using the %S for the backup set number; Using the %P for the piece number; Performing a RMAN backup of a tablespace and Incremental


Hands-On 05 (RMAN-Managed Tablespace Recovery)

Performing a tablespace recovery; Using the V$DATABASE view; Using the USER_TABLES; Writing a procedure; Modeling a media disk crash; Setting a datafile status using the RMAN tool; Restoring a datafile


Hands-On 06 (RMAN-Managed Complete Backup)

Performing a complete database backup; Using the LIST BACKUP command


Hands-On 07 (RMAN-Managed incomplete database recovery scenario)

Using the V$DATABASE view; Using the USER_TABLES view; Using the SET TIME command; Creating a scenario - before and after an incomplete recovery


Hands-On 08 (RMAN-Managed incomplete database recovery)

Performing an incomplete database recovery; Performing the database restore; Performing the recover procedures until a specified time; Opening a database using the RESETLOGS option; Checking to see if a table was recovered; Dropping a table


Hands-On 09 (RMAN-Managed the LIST and REPORT commands)

Performing the LIST and REPORT commands; Creating a RMAN script; Replacing a RMAN script; Deleting a RMAN script; Running a RMAN script; Connecting to the RMAN tool using the Recovery Catalog database; Listing all of the backup sets and the associated backup pieces; Listing all of the expired backup sets; Listing the backup of the data files for a tablespace; Listing a database incarnations registered in a database; Displaying objects that need a backup and a confirmed retention policy; Listing all of the backup sets and image copies that are OBSOLETE; Listing all of the schemas of the database that can be deleted


Hands-On 10 (Configuring a Listener using the Net Manager tool)

Adding a listener; Modifying a listener; Viewing a listener; Configuring a listener; Enabling a listenerís logging file; Enabling a listenerís tracing file; Disabling a listenerís logging file; Disabling a listenerís tracing file; Adding a listener's Location address


Hands-On 11 (Configuring a Service Name using the Net Manager tool)

Adding a service name; Modifying a service name; Configuring a service name; Testing a service name


Good Luck!


Web web site