/*
|| HyperBac Listings
||
|| Demonstrates how HyperBac can be used to:
|| - Compress RMAN image copy backups
|| - Compress RMAN backup sets efficiently
|| - Encrypt RMAN backup sets and image copy backups
|| - Compress DataPump Export dumpsets
|| - Encrypt DataPump Export dumpsets
||
|| Author: Jim Czuprynski
||
|| Usage Notes:
|| This script is provided to demonstrate various features of the HyperBac
|| third-party utility as it interacts with an Oracle 10g database. It should
|| be carefully proofread before executing it against any existing Oracle
|| database to insure that no potential damage can occur.
*/

/* 
|| Listing 1: Creating a set of baseline RMAN image copy backups
*/

RMAN> RUN {
    BACKUP AS COPY DATABASE;
}

Starting backup at 08-03-2007 07:56:40
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=131 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
output filename=/u03/flash_recovery_area/SAMPLE/datafile/o1_mf_system_3c4nrs7h_.dbf tag=TAG20070803T075640 recid=20 stamp=629625420
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
output filename=/u03/flash_recovery_area/SAMPLE/datafile/o1_mf_sysaux_3c4nsldw_.dbf tag=TAG20070803T075640 recid=21 stamp=629625437
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
output filename=/u03/flash_recovery_area/SAMPLE/datafile/o1_mf_example_3c4nt1jd_.dbf tag=TAG20070803T075640 recid=22 stamp=629625446
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
output filename=/u03/flash_recovery_area/SAMPLE/datafile/o1_mf_undotbs1_3c4nt8o7_.dbf tag=TAG20070803T075640 recid=23 stamp=629625450
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
output filename=/u03/flash_recovery_area/SAMPLE/datafile/o1_mf_users_3c4ntcr3_.dbf tag=TAG20070803T075640 recid=24 stamp=629625451
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u03/flash_recovery_area/SAMPLE/controlfile/o1_mf_TAG20070803T075640_3c4ntdw9_.ctl tag=TAG20070803T075640 recid=25 stamp=629625453
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 07:57:35
channel ORA_DISK_1: finished piece 1 at 08-03-2007 07:57:36
piece handle=/u03/flash_recovery_area/SAMPLE/backupset/2007_08_03/o1_mf_nnsnf_TAG20070803T075640_3c4nth7n_.bkp tag=TAG20070803T075640 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 08-03-2007 07:57:36

/* 
|| Listing 2: Creating a baseline RMAN backup set (without compression)
*/

RMAN> RUN {
    BACKUP AS BACKUPSET DATABASE;
}

Starting backup at 08-03-2007 08:05:47
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:05:47
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:06:22
piece handle=/u03/flash_recovery_area/SAMPLE/backupset/2007_08_03/o1_mf_nnndf_TAG20070803T080547_3c4o9vwf_.bkp tag=TAG20070803T080547 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:06:24
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:06:25
piece handle=/u03/flash_recovery_area/SAMPLE/backupset/2007_08_03/o1_mf_ncsnf_TAG20070803T080547_3c4oc0c2_.bkp tag=TAG20070803T080547 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-03-2007 08:06:25

/* 
|| Listing 3: Creating a baseline RMAN compressed backup set
*/

RMAN> RUN {
    BACKUP AS COMPRESSED BACKUPSET DATABASE;
}

Starting backup at 08-03-2007 08:08:36
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:08:36
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:09:31
piece handle=/u03/flash_recovery_area/SAMPLE/backupset/2007_08_03/o1_mf_nnndf_TAG20070803T080836_3c4oh4l4_.bkp tag=TAG20070803T080836 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:09:32
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:09:33
piece handle=/u03/flash_recovery_area/SAMPLE/backupset/2007_08_03/o1_mf_ncsnf_TAG20070803T080836_3c4ojww6_.bkp tag=TAG20070803T080836 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 08-03-2007 08:09:33

/* 
|| Listing 4: Creating a RMAN Backup Set Compressed Using HyperBac
*/

RMAN> RUN {
    BACKUP AS BACKUPSET DATABASE
    FORMAT '/u03/HyperBac/%U.hbc';
}

Starting backup at 08-03-2007 08:07:10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:07:11
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:07:46
piece handle=/u03/HyperBac/1hioel5f_1_1.hbc tag=TAG20070803T080711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:07:47
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:07:48
piece handle=/u03/HyperBac/1iioel6i_1_1.hbc tag=TAG20070803T080711 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 08-03-2007 08:07:48

/* 
|| Listing 5: Creating a Compressed Backup Set that is compressed
||            even further using HyperBac compression
*/

RMAN> RUN {
    BACKUP AS COMPRESSED BACKUPSET DATABASE
    FORMAT '/u03/HyperBac/%U.hbc';
}

Starting backup at 08-03-2007 08:19:55
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:19:55
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:20:50
piece handle=/u03/HyperBac/1lioeltb_1_1.hbc tag=TAG20070803T081955 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 08:20:52
channel ORA_DISK_1: finished piece 1 at 08-03-2007 08:20:53
piece handle=/u03/HyperBac/1mioelv2_1_1.hbc tag=TAG20070803T081955 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-03-2007 08:20:53

/* 
|| Listing 6: Creating RMAN image copy backups using HyperBac
*/

RUN {
    BACKUP AS COPY DATABASE
    FORMAT '/u03/HyperBac/%U.hbc';
}

Starting backup at 08-03-2007 07:44:53
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=146 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-SYSTEM_FNO-1_11ioejrm.hbc tag=TAG20070803T074453 recid=14 stamp=629624711
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-SYSAUX_FNO-3_12ioejsf.hbc tag=TAG20070803T074453 recid=15 stamp=629624728
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-EXAMPLE_FNO-5_13ioejsu.hbc tag=TAG20070803T074453 recid=16 stamp=629624737
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-UNDOTBS1_FNO-2_14ioejt5.hbc tag=TAG20070803T074453 recid=17 stamp=629624743
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-USERS_FNO-4_15ioejt8.hbc tag=TAG20070803T074453 recid=18 stamp=629624745
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u03/HyperBac/cf_D-SAMPLE_id-3679897004_16ioejt9.hbc tag=TAG20070803T074453 recid=19 stamp=629624746
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-03-2007 07:45:48
channel ORA_DISK_1: finished piece 1 at 08-03-2007 07:45:49
piece handle=/u03/HyperBac/17ioejta_1_1.hbc tag=TAG20070803T074453 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 08-03-2007 07:45:49

/* 
|| Listing 7: Creating Encrypted Backup Sets Using HyperBac
*/

RMAN> RUN {
    BACKUP AS BACKUPSET DATABASE
    FORMAT '/u03/HyperBac/%U.hbe';
}
Starting backup at 08-07-2007 23:05:30
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
input datafile fno=00006 name=/u02/app/oracle/oradata/sample/altperm01.dbf
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-07-2007 23:05:32
channel ORA_DISK_1: finished piece 1 at 08-07-2007 23:06:07
piece handle=/u03/HyperBac/1oioqr9r_1_1.hbe tag=TAG20070807T230531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-07-2007 23:06:07
channel ORA_DISK_1: finished piece 1 at 08-07-2007 23:06:08
piece handle=/u03/HyperBac/1pioqrav_1_1.hbe tag=TAG20070807T230531 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-07-2007 23:06:08

/* 
|| Listing 8: Creating Encrypted Image Copy Backups Using HyperBac
*/

RMAN> RUN {
    BACKUP AS COPY DATABASE
    FORMAT '/u03/HyperBac/%U.hbe';
}

Starting backup at 08-07-2007 23:06:44
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u02/app/oracle/oradata/sample/system01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-SYSTEM_FNO-1_1qioqrc4.hbe tag=TAG20070807T230644 recid=26 stamp=630025623
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u02/app/oracle/oradata/sample/sysaux01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-SYSAUX_FNO-3_1rioqrct.hbe tag=TAG20070807T230644 recid=27 stamp=630025638
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/u02/app/oracle/oradata/sample/example01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-EXAMPLE_FNO-5_1sioqrdc.hbe tag=TAG20070807T230644 recid=28 stamp=630025648
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u02/app/oracle/oradata/sample/undotbs01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-UNDOTBS1_FNO-2_1tioqrdj.hbe tag=TAG20070807T230644 recid=29 stamp=630025653
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=/u02/app/oracle/oradata/sample/altperm01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-ALTPERM_FNO-6_1uioqrdm.hbe tag=TAG20070807T230644 recid=30 stamp=630025655
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u02/app/oracle/oradata/sample/users01.dbf
output filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-USERS_FNO-4_1vioqrdn.hbe tag=TAG20070807T230644 recid=31 stamp=630025656
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u03/HyperBac/cf_D-SAMPLE_id-3679897004_20ioqrdp.hbe tag=TAG20070807T230644 recid=32 stamp=630025657
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-07-2007 23:07:38
channel ORA_DISK_1: finished piece 1 at 08-07-2007 23:07:39
piece handle=/u03/HyperBac/21ioqrdq_1_1.hbe tag=TAG20070807T230644 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-07-2007 23:07:39

/* 
|| Listing 9: Recovering a Tablespace from HyperBac-Encrypted Backups
*/

RMAN> RESTORE PREVIEW DATAFILE 5;


Starting restore at 08-16-2007 23:31:31
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=149 devtype=DISK


List of Datafile Copies
Key     File S Completion Time     Ckp SCN    Ckp Time            Name
------- ---- - ------------------- ---------- ------------------- ----
28      5    A 08-07-2007 23:07:28 643104     08-07-2007 23:07:24 /u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-EXAMPLE_FNO-5_1sioqrdc.hbe
using channel ORA_DISK_1

List of Archived Log Copies
Key     Thrd Seq     S Low Time            Name
------- ---- ------- - ------------------- ----
37      1    21      A 08-07-2007 01:08:33 /u03/flash_recovery_area/SAMPLE/archivelog/2007_08_16/o1_mf_1_21_3d8n16gx_.arc
Media recovery start SCN is 643104
Recovery must be done beyond SCN 643104 to clear data files fuzziness
Finished restore at 08-16-2007 23:31:33

RMAN> sql 'alter tablespace example offline';
sql statement: alter tablespace example offline

RMAN> RUN {
2> RESTORE TABLESPACE EXAMPLE;
3> RESTORE TABLESPACE EXAMPLE;
4> }

Starting restore at 08-16-2007 23:37:19
using channel ORA_DISK_1

channel ORA_DISK_1: restoring datafile 00005
input datafile copy recid=28 stamp=630025648 filename=/u03/HyperBac/data_D-SAMPLE_I-3679897004_TS-EXAMPLE_FNO-5_1sioqrdc.hbe
destination for restore of datafile 00005: /u02/app/oracle/oradata/sample/example01.dbf
channel ORA_DISK_1: copied datafile copy of datafile 00005
output filename=/u02/app/oracle/oradata/sample/example01.dbf recid=33 stamp=630805044
Finished restore at 08-16-2007 23:37:26

Starting recover at 08-16-2007 23:37:26
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 08-16-2007 23:37:30

RMAN> sql 'alter tablespace example online';
sql statement: alter tablespace example online

/* 
|| Listing 10: Creating a Baseline DataPump Export Dumpset
*/

>> Parameter file used to invoke DataPump Export:

################################################################
# DataPump Export Parameter File: FullDBExport.dpectl
# Version: 10.2.0.1.0
# Purpose: Creates a DataPump export of the entire database
# Author: Jim Czuprynski, Fujitsu Consulting
################################################################
JOB_NAME=FullDBExport
DIRECTORY=DPDIR1
DUMPFILE=DPDIR1:FullDBExport_%U.dmp
LOGFILE=DPDIR1:FullDBExport.explog
FULL=Y
FILESIZE=128M

>> Results:

Export: Release 10.2.0.1.0 - Production on Monday, 06 August, 2007 23:50:04

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."FULLDBEXPORT":  system/******** parfile=FullDBExport.dpectl
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39139: Data Pump does not support XMLSchema objects. TABLE_DATA:"OE"."PURCHASEORDER" will be skipped.
Total estimation using BLOCKS method: 59.68 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
...
... lines removed for sake of brevity
...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SH"."CUSTOMERS"                            9.850 MB   55500 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS"           695.9 KB    4500 rows
. . exported "OE"."PRODUCT_DESCRIPTIONS"                 2.379 MB    8640 rows
. . exported "SH"."SALES":"SALES_Q4_2001"                2.257 MB   69749 rows
. . exported "SH"."SALES":"SALES_Q1_1999"                2.070 MB   64186 rows
. . exported "SH"."SALES":"SALES_Q3_2001"                2.129 MB   65769 rows
. . exported "SH"."SALES":"SALES_Q1_2000"                2.011 MB   62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001"                1.964 MB   60608 rows
. . exported "SH"."SALES":"SALES_Q2_2001"                2.050 MB   63292 rows
. . exported "SH"."SALES":"SALES_Q3_1999"                2.166 MB   67138 rows
. . exported "SH"."SALES":"SALES_Q4_1999"                2.014 MB   62388 rows
. . exported "SH"."SALES":"SALES_Q2_2000"                1.801 MB   55515 rows
. . exported "SH"."SALES":"SALES_Q3_2000"                1.909 MB   58950 rows
. . exported "SH"."SALES":"SALES_Q4_1998"                1.581 MB   48874 rows
. . exported "SH"."SALES":"SALES_Q4_2000"                1.813 MB   55984 rows
. . exported "SH"."SALES":"SALES_Q2_1999"                1.753 MB   54233 rows
. . exported "SH"."SALES":"SALES_Q1_1998"                1.412 MB   43687 rows
. . exported "SH"."SALES":"SALES_Q3_1998"                1.633 MB   50515 rows
...
... lines removed for sake of brevity
...
. . exported "TSMSYS"."SRS$"                                 0 KB       0 rows
Master table "SYSTEM"."FULLDBEXPORT" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.FULLDBEXPORT is:
  /u02/exports/FullDBExport_01.dmp
Job "SYSTEM"."FULLDBEXPORT" completed with 1 error(s) at 23:54:19

/* 
|| Listing 11: Creating Compressed DataPump Export Dumpsets Using HyperBac
*/

>> Parameter file used to invoke DataPump Export:

################################################################
# DataPump Export Parameter File: FullDBExport.dpectl
# Version: 10.2.0.1.0
# Purpose: Creates a DataPump export of the entire database
# Author: Jim Czuprynski, Fujitsu Consulting
################################################################
JOB_NAME=FullDBExport
DIRECTORY=DPDIR1
DUMPFILE=DPDIR1:FullDBExport_%U.hbc
LOGFILE=DPDIR1:FullDBExport.explog
FULL=Y
FILESIZE=128M

>> Results:

Export: Release 10.2.0.1.0 - Production on Tuesday, 07 August, 2007 0:59:46

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."FULLDBEXPORT":  system/******** parfile=FullDBExport.dpectl
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39139: Data Pump does not support XMLSchema objects. TABLE_DATA:"OE"."PURCHASEORDER" will be skipped.
Total estimation using BLOCKS method: 59.62 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW
...
... lines removed for sake of brevity
...
Processing object type DATABASE_EXPORT/SCHEMA/JOB
Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SH"."CUSTOMERS"                            9.850 MB   55500 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS"           695.9 KB    4500 rows
. . exported "OE"."PRODUCT_DESCRIPTIONS"                 2.379 MB    8640 rows
. . exported "SH"."SALES":"SALES_Q4_2001"                2.257 MB   69749 rows
. . exported "SH"."SALES":"SALES_Q1_1999"                2.070 MB   64186 rows
. . exported "SH"."SALES":"SALES_Q3_2001"                2.129 MB   65769 rows
. . exported "SH"."SALES":"SALES_Q1_2000"                2.011 MB   62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001"                1.964 MB   60608 rows
. . exported "SH"."SALES":"SALES_Q2_2001"                2.050 MB   63292 rows
. . exported "SH"."SALES":"SALES_Q3_1999"                2.166 MB   67138 rows
. . exported "SH"."SALES":"SALES_Q4_1999"                2.014 MB   62388 rows
. . exported "SH"."SALES":"SALES_Q2_2000"                1.801 MB   55515 rows
. . exported "SH"."SALES":"SALES_Q3_2000"                1.909 MB   58950 rows
. . exported "SH"."SALES":"SALES_Q4_1998"                1.581 MB   48874 rows
. . exported "SH"."SALES":"SALES_Q4_2000"                1.813 MB   55984 rows
. . exported "SH"."SALES":"SALES_Q2_1999"                1.753 MB   54233 rows
. . exported "SH"."SALES":"SALES_Q1_1998"                1.412 MB   43687 rows
. . exported "SH"."SALES":"SALES_Q3_1998"                1.633 MB   50515 rows
. . exported "PM"."ONLINE_MEDIA"                         39.24 KB       9 rows
...
... lines removed for sake of brevity
...
. . exported "TSMSYS"."SRS$"                                 0 KB       0 rows
Master table "SYSTEM"."FULLDBEXPORT" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.FULLDBEXPORT is:
  /u02/exports/FullDBExport_01.hbc
Job "SYSTEM"."FULLDBEXPORT" completed with 1 error(s) at 01:02:06

/* 
|| Listing 12: Creating Encrypted DataPump Export Dumpsets Using HyperBac
*/

>> Parameter file used to invoke DataPump Export:

################################################################
# DataPump Export Parameter File: FullDBExport.dpectl
# Version: 10.2.0.1.0
# Purpose: Creates a DataPump export of the entire database
# Author: Jim Czuprynski, Fujitsu Consulting
################################################################
JOB_NAME=FullDBExport
DIRECTORY=DPDIR1
DUMPFILE=DPDIR1:FullDBExport_%U.hbe
LOGFILE=DPDIR1:FullDBExport.explog
FULL=Y
FILESIZE=128M

>> Results:

Export: Release 10.2.0.1.0 - Production on Tuesday, 07 August, 2007 1:07:53

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."FULLDBEXPORT":  system/******** parfile=FullDBExport.dpectl
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39139: Data Pump does not support XMLSchema objects. TABLE_DATA:"OE"."PURCHASEORDER" will be skipped.
Total estimation using BLOCKS method: 59.62 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
...
... lines removed for sake of brevity
...
Processing object type DATABASE_EXPORT/SCHEMA/DIMENSION
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SH"."CUSTOMERS"                            9.850 MB   55500 rows
. . exported "SH"."SUPPLEMENTARY_DEMOGRAPHICS"           695.9 KB    4500 rows
. . exported "OE"."PRODUCT_DESCRIPTIONS"                 2.379 MB    8640 rows
. . exported "SH"."SALES":"SALES_Q4_2001"                2.257 MB   69749 rows
. . exported "SH"."SALES":"SALES_Q1_1999"                2.070 MB   64186 rows
. . exported "SH"."SALES":"SALES_Q3_2001"                2.129 MB   65769 rows
. . exported "SH"."SALES":"SALES_Q1_2000"                2.011 MB   62197 rows
. . exported "SH"."SALES":"SALES_Q1_2001"                1.964 MB   60608 rows
. . exported "SH"."SALES":"SALES_Q2_2001"                2.050 MB   63292 rows
. . exported "SH"."SALES":"SALES_Q3_1999"                2.166 MB   67138 rows
. . exported "SH"."SALES":"SALES_Q4_1999"                2.014 MB   62388 rows
. . exported "SH"."SALES":"SALES_Q2_2000"                1.801 MB   55515 rows
. . exported "SH"."SALES":"SALES_Q3_2000"                1.909 MB   58950 rows
. . exported "SH"."SALES":"SALES_Q4_1998"                1.581 MB   48874 rows
. . exported "SH"."SALES":"SALES_Q4_2000"                1.813 MB   55984 rows
. . exported "SH"."SALES":"SALES_Q2_1999"                1.753 MB   54233 rows
. . exported "SH"."SALES":"SALES_Q1_1998"                1.412 MB   43687 rows
. . exported "SH"."SALES":"SALES_Q3_1998"                1.633 MB   50515 rows
...
... lines removed for sake of brevity
...
. . exported "TSMSYS"."SRS$"                                 0 KB       0 rows
Master table "SYSTEM"."FULLDBEXPORT" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.FULLDBEXPORT is:
  /u02/exports/FullDBExport_01.hbe
Job "SYSTEM"."FULLDBEXPORT" completed with 1 error(s) at 01:09:57

/* 
|| Listing 13: Re-Importing a HyperBac-Filtered DataPump Export Dumpset
*/

>> Parameter file used to invoke DataPump Import:

################################################################
# DataPump Import Parameter File: PartialDBImport.dpictl
# Version: 10.2.0.1.0
# Purpose: Performs a DataPump Import operation that only reloads
#          one table, but transforms it to a different schema
# Author: Jim Czuprynski, Fujitsu Consulting
################################################################
JOB_NAME=IMPJOB01
DIRECTORY=DPDIR1
DUMPFILE=DPDIR1:FullDBExport_%U.hbe
LOGFILE=DPDIR1:IMPJOB01.implog
TABLES='SH.PRODUCTS'
REMAP_SCHEMA='SH:HR'

>> Results:

Import: Release 10.2.0.1.0 - Production on Thursday, 16 August, 2007 23:24:40

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."IMPJOB01" successfully loaded/unloaded
Starting "SYSTEM"."IMPJOB01":  system/******** parfile=PartialDBImport.dpictl 
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
. . imported "HR"."PRODUCTS"                             24.09 KB      72 rows
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."IMPJOB01" successfully completed at 23:27:46