Oracle Database Commands and Practical Examples

HOME

  • Home
  • RMAN
  • PATCHING
  • UPGRADE
  • RAC
  • EXPDP
  • Oracle Cloud
  • MS SQL
  • POSTGRES SQL
  • PHP XAMPP
  • AWS
  • DATAGUARD
  • DATABASE TROUBLESHOOTING
  • PERFORMANCE TUNNING
  • SIEMENS PLM
  • Basic German Language
  • MATLAB
  • MULTITENANT CDB
  • GOLDENGATE
  • SCRIPTS
  • OEM 13c
  • Self Learn

Monday, 5 August 2019

EXPDP Examples

Expdp - AWR dump example awrextr.sql

OCI - Moving Data from Autonomous Databases to on Premises database using impdp

OCI- Moving data to Autonomous database using expdp -impdp

expdp and impdp examples commands

expdp-impdp  - Cross Platform Migration using Transport Tablespace using Expdp | Impdp backup


expdp error fails DETERMINE_FATAL_ERROR with ORA-01157: cannot identify/lock data file 202 - see DBWR trace file

IMPDP Error ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_SCHEMA_01 for user SYS ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1616 ORA-39062: error creating master process DM00 ORA-31613: Master process DM00 failed during startup.

https://varunyadav27.blogspot.com/2020/03/expdp-master-table-error-ora-31633.html

expdp - permission error ORA-31693, ORA-31617

IMPDP Error : RAC Environment Fails With Errors ORA-29913 ORA-31640 ORA-19505 ORA-27037

Impdp Example using remap_schema and remap_tablespace parameter

Impdp example using attach increase parallel from 10 to 17

Expdp - Par file examples




Posted by varun yadav at 19:19
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • ASM (5)
  • AWR (4)
  • Change OCR vote disk Location (1)
  • Crontab (12)
  • Database Error (2)
  • Dataguard (17)
  • EXPDP (6)
  • MSSQL Server (11)
  • Multitenant (28)
  • OCI (21)
  • OEM13c (8)
  • OS Troubleshooting (8)
  • One nodeRAC Relocation (1)
  • Oracle Database (5)
  • PSU OJVM (1)
  • Patching (10)
  • Performance Tunning (34)
  • RAC (27)
  • RMAN (25)
  • Relocate Rac service to preferred instance. (1)
  • SELF (6)
  • Scale down to RAC 1 node (1)
  • Upgrade (2)

Wikipedia

Search results



Translate

Search This Blog

Counter date 21 july2020

Flag Counter

Total Pageviews

Blog Archive

  • ►  2022 (31)
    • ►  December 2022 (3)
    • ►  October 2022 (17)
    • ►  May 2022 (6)
    • ►  March 2022 (1)
    • ►  February 2022 (4)
  • ►  2021 (84)
    • ►  December 2021 (9)
    • ►  November 2021 (4)
    • ►  October 2021 (7)
    • ►  September 2021 (1)
    • ►  August 2021 (4)
    • ►  July 2021 (2)
    • ►  June 2021 (14)
    • ►  May 2021 (8)
    • ►  April 2021 (15)
    • ►  March 2021 (7)
    • ►  January 2021 (13)
  • ►  2020 (136)
    • ►  December 2020 (4)
    • ►  November 2020 (13)
    • ►  October 2020 (8)
    • ►  September 2020 (2)
    • ►  August 2020 (24)
    • ►  July 2020 (9)
    • ►  June 2020 (4)
    • ►  May 2020 (32)
    • ►  April 2020 (15)
    • ►  March 2020 (18)
    • ►  February 2020 (7)
  • ▼  2019 (180)
    • ►  December 2019 (18)
    • ►  November 2019 (11)
    • ►  October 2019 (7)
    • ►  September 2019 (5)
    • ▼  August 2019 (56)
      • PT - Displaying Execution Plan using SQL Developer
      • Interview Questions
      • RAC : Node connectivity check failed (PRVG-11138, ...
      • PT - Displaying Execution Plan using dbms_xplan.di...
      • PT - Execution Plan using EXPLAIN PLAN FOR Command
      • PT- Enable plustrace for Autotrace schema
      • PT - Usage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY...
      • RMAN - Restore the SPFILE from AUTOBACKUP on RAC 2...
      • Error : ORA-01919: role 'PLUSTRACE' does not exist
      • RMAN - Recovery Senario ORA-26040: Data block was...
      • RMAN - Restore spfile from memory on RAC 12.1.0.2.0
      • RMAN - Restore spfile from memory on RAC 12.1.0.2....
      • RAC - Rconfig convert single instance to 2 node RA...
      • RAC - WARNING: failed to online diskgroup resource...
      • Creating a persistent File System on an OEL 6.7 Vi...
      • AWS - Create RDS Oracle database instance
      • AWS - Install oracle software and database on EC2 ...
      • AWS - Add swap Volume on EC2 Instance
      • AWS -EBS Volume creation for EC2
      • RMAN - Recovering Tables using RMAN RECOVER Comman...
      • RMAN - Performing Tablespace Point-in-Time Recover...
      • AWS - Private DNS host configuration
      • RMAN - Performing database point-in-time recovery ...
      • RMAN - Recovery of datafiles using Image copy meth...
      • AWS - Adding secondary IP Address
      • AWS - Changing host name on EC2 machine OEL 7.6
      • Rman complete Recovery of datafile 12.1.0.2.0
      • AWS : Elastic IP Allocation
      • AWS - Pre Oracle configuration setting
      • AWS - Launch EC2 Instance
      • AWS Examples
      • Performance Tunning
      • RAC Examples
      • Database Examples
      • Dataguard
      • PHP Xampp Example
      • Scripts Examples
      • Patching Examples
      • EXPDP Examples
      • Rman Backup and Recovery Examples
      • DB ID Check Using RMAN database open 12.1.0.2.0
      • Recovery of Database in non Archivelog mode -- Mou...
      • Complete recovery of a user tablespace loss RAC -...
      • Complete recovery of the entire database in ARCHIV...
      • PRCR-1079 : Failed to start resource ora.rac.db CR...
      • RMAN 12c 12.1.0.2.0 - Restore database preview and...
      • Rman Validate Database| Tablespace | Datafile com...
      • RAC 12c R1 Automatic | Manual and NORESTART Manage...
      • RAC 12c R1 Automatic | Manual and NORESTART Manage...
      • RAC 12c R1 Automatic | Manual and NORESTART Manage...
      • RMAN -Auto-login Software Keystore -TDE
      • ORA-19914: unable to encrypt backup ORA-28365: wal...
      • Using RMAN Transparent-mode Encrypted Backups -Manual
      • RMAN - Configuring setup Transparent Data Encryption
      • Found Error : TNS-12560: TNS:protocol adapter erro...
      • Rman Catalog script for Tablespace backup
    • ►  July 2019 (24)
    • ►  June 2019 (29)
    • ►  May 2019 (19)
    • ►  April 2019 (1)
    • ►  January 2019 (10)
  • ►  2012 (5)
    • ►  December 2012 (1)
    • ►  September 2012 (3)
    • ►  June 2012 (1)

live traffic feed

Website Online Counter
Awesome Inc. theme. Powered by Blogger.