Oracle | Linux | Cook Book

  Create all folders: mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ mkdir -m2750 /folder/path/ init parameters: *.audit_file_dest='/audit/file/path/' *.audit_sys_operations=TRUE *.audit_trail='DB_EXTENDED' *.compatible='compatible_parameter_as_per_your_env' *.control_files='/folder/path/goes/here/control01.ctl','/folder/path/goes/here/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='TGT_DB_NAME' *.db_recovery_file_dest_size=214748364800 *.diagnostic_dest='folder/path' *.global_names=FALSE *.local_listener='listener_name' *.log_archive_dest='/archived/redo/location' *.log_archive_format='%%ORACLE_SID%%_ARC%s_%R.%T' *.open_cursors=300 *.processes=2210 *.remote_login_passwordfile='EXCLUSIVE' *.sga_max_size=3G *.sga_target=2G *.pga_aggregate_target=1G *.undo_tablespace=...

  How to export[EXPDP] just Package: =================================== Create PARFILE ============== $ cat > new_tmp.par USERID="/ as sysdba" SCHEMAS=SPSE INCLUDE=PACKAGE:"IN ('SPSE_ER_BOND_REPORT')" COMPRESSION=ALL CLUSTER=N DUMPFILE=CFRAEXPORTS:tmp_new_expdp_10.dmp NOLOGFILE=Y Execute EXPDP using PARFILE =========================== $ expdp parfile=/exports1/cfrabackup/new_tmp.par Export: Release 11.2.0.4.0 - Production on Wed Sep 13 14:36:05 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options FLASHBACK automatically enabled to preserve database integrity. Starting "SYS"."SYS_EXPORT_SCHEMA_02":  /******** AS SYSDBA parfile=/exports1/cfrabackup/new_tmp.par Estimate in progress usin...