Exclude and Include Option in both EXPDP and IMPDP

EXCLUDE and INCLUDE options are really use full in DATAPUMP.


expdp scott/tiger@testdb directory=test dumpfile=isptool_scott.dmp logfile=isptool_scott.log exclude=TABLE:\"='BONUS'\"


impdp scott/tiger@testdb directory=test dumpfile=isptool_scott.dmp logfile=isptool_test_impdp.log include=TABLE:\"='DEPT'\"



Cheers!!!

ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

ora-12528: TNS:Listener: All Appropriate instances are blocking new connections

Got this Error.

This error means Database instance are not started or Starting.You need to start database server.If your database server is already starting.You have to wait till the database open.

Connect directly to Oracle



command:-

export oracle_sid=testdb

sqlplus sys as sysdba
password:XXXXX

SQL>select status from v$instance;

we can see the current status from Database from above query.

Cheers!!!!

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x7C81BD02]

ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x7C81BD02] [] [] [] []
Current SQL information unavailable - no SGA.

It`s a OS dependent error.You can contact oracle support for more details and patches.

Also

Also check these memory parameters.


1) Increase SGA_MAX_SIZE and SGA_TARGET so that you can accommodate following pools.

2) Restart the instance.

3) Increase INIT.ORA memory parameters and make sure following pools are set to recommended value i.e. 200M.

a) SHARED_POOL_SIZE

b) JAVA_POOL_SIZE

c) STREAMS_POOL_SIZE


Cheers!!!

ORA-01123: cannot start online backup; media recovery not enabled.

alter tablespace users begin backup;

ORA-01123: cannot start online backup; media recovery not enabled.

Check whether the database in archive log by SYS user

SQL> ARCHIVE LOG LIST;

Database is in non archive mode

We need to change archive mode

SQL>shutdown immediate;

SQL>startup mount;

SQL>alter database archivelog;

SQL>Alter database open;

then you can BEGIN BACKUP command

Cheers!!!

ORA-19809: limit exceeded for recovery files

RMAN-03002: failure of backup plus archivelog command at 07/04/2011 10:58:39
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 1530219520 bytes disk space from 4039114752 limit

Got this error.

You need to increase your flashback recovery area by

SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=4G scope=both;

Also you can delete old backup from recovery area.


Cheers!!!

KILL UNNECESSARY SESSION

You want to kill unnecessary session in oracle.
check this



SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;


You will get sid,serial# from v$session view.

Cheers!!!

ora-12638 credential retrieval failed

ora-12638 credential retrieval failed


got this error?

sometimes you will get that error from oracle client

at that time you need to change SQLNET AUTHENTICATION service on SQLNET.ORA file



SQLNET.AUTHENTICATION_SERVICES = (NTS)

TO

SQLNET.AUTHENTICATION_SERVICES = (NONE)

Cheers!!!