Category Uncategorized

Expdp / ORA-39065 / ORA-01403


expdp DIRECTORY=DATA_PUMP_DIR DUMPFILE=xxxxxxxxxxxxxxxxxx….. Username: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and Real Application Testing options ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01403: no data found ORA-39097: Data […]

ORACLE 11G EXPDP AND IMPDP FEATURE


COMPRESSION parameter in expdpOne of the big issues with Data Pump was that the dumpfile couldn’t be compressed while getting created. In Oracle Database 11g, Data Pump can compress the dumpfiles while creating them by using parameter COMPRESSION in the expdp command line. The parameter has three options: METDATA_ONLY – only the metadata is compressed, […]

ORA-00376 : file 43 cannot be read at this time


connect to Oracle AS SYSDBA sqlplus / as sysdba SQL> select * from v$recover_file; FILE# status 43 OFFLINE SQL> recover datafile 43; ORA-00279: change 271477927444 generated at 15/11/2013 10:30:46 needed for thread 1 ORA-00289: suggestion : /export/a01/oradata/ANARTEST/arch/arch_1_170675_526120954.arcORA-00280: change 271477927444 for thread 1 is in sequence #170675 Specify log: {=suggested filename AUTO CANCEL} AUTO ORA-00308: cannot […]

Data Guard / RMAN’ s archivelog deletion policy.


ARCHIVELOG DELETION POLICY FOR PHYSICAL STANDBY DATABASES. SQL> set pagesize 9999SQL> set linesize 120SQL> select * from v$flash_recovery_area_usage;FILE_TYPE         PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES——————– —————— ————————- —————CONTROL FILE                  0             0        0REDO LOG                   4.02             0        4ARCHIVED LOG              42.51             […]

RMAN Restoration and Recovery


RMAN> list backup summary;List of Backups===============Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag——- — — – ———– ————— ——- ——- ———- —9 B A A DISK 30-MAR-07 1 1 NO TAG20070330T09201610 B F A DISK 30-MAR-07 1 1 NO TAG20070330T09214811 B A A DISK 30-MAR-07 1 1 NO TAG20070330T09254712 B F […]

How to restore an RMAN backup from TAG


SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup mount;ORACLE instance started.Total System Global Area 608174080 bytesFixed Size 2085840 bytesVariable Size 381684784 bytesDatabase Buffers 218103808 bytesRedo Buffers 6299648 bytesDatabase mounted.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64 bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[oracle@dbhost oracle]$ rman […]

Renaming SYSTEM datafiles of Oracle Database


SQL> alter tablespace system offline; alter tablespace system offline * ERROR at line 1: ORA-01541: system tablespace cannot be brought offline; shut down if necessary Renaming datafiles of SYSTEM tablespace:- 1. Shut down the database SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. 2. Start the database in mount mode : SQL> […]

Opatch PSU Oracle Solaris on SPARC (64-bit)


bash-3.00$ cd $ORACLE_HOME -bash-3.00$ mv OPatch OPatch.OLD -bash-3.00$ cp p6880880_112000_Solaris86-64.zip /u01/app/oracle/product/11.2.0/db_1/ -bash-3.00$ unzip p6880880_112000_Solaris86-64.zip -bash-3.00$ opatch version /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch: whereis: not found Invoking OPatch 11.2.0.1.6 OPatch Version: 11.2.0.1.6 OPatch succeeded. -bash-3.00$ -bash-3.00$ export PATH=$PATH:/usr/ucb -bash-3.00$ opatch version Invoking OPatch 11.2.0.1.6 OPatch Version: 11.2.0.1.6 OPatch succeeded. -bash-3.00$ 2- Download the patch number 9952216 and unzip the file: […]

opatch: whereis: not found


while invoking Opatch: version 11.2.1.1.6opatch apply/ora_backup/u0001/patches/OPatch/OPatch/opatch: whereis: not foundfix:>export PATH=$PATH:/usr/ucb>/ora_backup/u0001/patches/OPatch/OPatch/opatch applyInvoking OPatch 11.2.0.1.6