|
Hands-On
Oracle Fundamentals II-CD#02
Table of contents:
|
Click
here for case study |
Hands-On
Oracle Fundamentals II-CD#02
(RMAN-Managed
Backup and Recovery along with Network Configurations)
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
Commands:
CREATE TABLESPACE
CREATE USER
GRANT
DOS> rman RCVCAT
RMAN>
CREATE CATALOG;
RMAN>
exit;
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
Commands:
DOS>
CATALOG TARGET
RMAN> register database;
RMAN>
resync catalog;
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO
RMAN> BACKUP DATAFILE
RMAN>
BACKUP CURRENT CONTROLFILE;
RMAN>
exit;
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
Commands:
COPY
DATAFILE TO ‘xxx’ NOCHECKSUM;
HOST
MKDIR
DOS>
RMAN
RMAN> CONNECT CATALOG
RMAN> CONNECT TARGET
RMAN> CONFIGURE RETENTION POLICY
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE
RMAN> COPY DATAFILE
RMAN> COPY CURRENT CONTROLFILE
RMAN> exit
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
Performing
RMAN backup of a tablespace
Incremental
Performing
a RMAN backup of a tablespace
Incremental
Commands:
DOS>
RMAN
RMAN> CONNECT CATALOG
RMAN> CONNECT TARGET
RMAN> BACKUP DATAFILE
RMAN> BACKUP TABLESPACE
RMAN> BACKUP INCREMENTAL
RMAN>
exit
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
Commands:
ALTER TABLESPACE
HOST ERASE
DOS> RMAN
RMAN> CONNECT CATALOG
RMAN> CONNECT TARGET
RMAN> SQL 'ALTER DATABASE DATAFILE OFFLINE';
RMAN> RESTORE DATAFILE
RMAN> RECOVER DATAFILE
RMAN> SQL 'ALTER DATABASE DATAFILE ONLINE';
RMAN>
SQL 'ALTER TABLESPACE ONLINE';
RMAN> exit
DROP TABLE
Hands-On
06 (RMAN-Managed
Complete Backup)
Performing
a complete database backup
Using
the LIST BACKUP command
Commands:
DOS>
rman CATALOG
RMAN> BACKUP DATABASE
RMAN> LIST BACKUP;
RMAN> exit;
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
Commands:
DROP TABLE
SET TIME ON
SET TIME OFF
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
Commands:
RMAN> CONNECT CATALOG
RMAN> CONNECT TARGET
RMAN>
SHUTDOWN IMMEDIATE;
RMAN>
STARTUP MOUNT;
RMAN>
OPEN RESETLOGS DATABASE;
DROP
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
Commands:
RMAN> CONNECT CATALOG
RMAN> CONNECT TARGET
RMAN>
LIST BACKUP;
RMAN> LIST EXPIRED BACKUPSET;
RMAN> LIST BACKUP
RMAN>
LIST INCARNATION OF DATABASE;
RMAN>
REPORT NEED BACKUP;
RMAN>
REPORT OBSOLETE;
RMAN>
REPORT SCHEMA;
RMAN> RUN
RMAN> REPLACE SCRIPT
RMAN> DELETE SCRIPT
RMAN>
exit;
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 |