/*
|| 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