Posted by Mir Sayeed Hassan on September 4th, 2018
How to exclude Single or Multiple tables from schema by using from EXPDP
Include Single table from schema
[oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=mir04sep18.dmp logfile=mir04sep18.log schemas=mir include=TABLE:"IN('T1')"
Export: Release 11.2.0.4.0 - Production on Tue Sep 4 11:16:31 2018
Copyright...
Read more..
Posted in Datapump (Expdp/Impdp) | Comments Off on How to exclude Single or Multiple tables from schema by using from EXPDP
Posted by Mir Sayeed Hassan on July 25th, 2018
Script to Delete Log Files in Oracle Database by using the Crontab Job
The given script is tested in our test env
The logfiles are deleTrace File i.e (,trc,.trm) , Audit File (.aud), Listener log (.trc,.trm) & .xml files
In order to manage space in better way, the best practice is to clear the logs files from the database as...
Read more..
Posted in DBA Scripts | Comments Off on Script to Delete Log Files in Oracle Database by using the Crontab Job
Posted by Mir Sayeed Hassan on July 15th, 2018
ORA-16072: a minimum of one standby database destination is required
This error occurs in one of our production database after restore & recover in a database open stage
SQL> startup mount
ORACLE instance started.
Total System Global Area 396726272 bytes
Fixed Size 2253504 bytes
Variable Size 318770496 bytes
...
Read more..
Posted in ORA-Error | Comments Off on ORA-16072: a minimum of one standby database destination is required
Posted by Mir Sayeed Hassan on July 7th, 2018
ORA-01156: recovery or flashback in progress may need access to files
[oracle@primdb onlinelog]$ !sq
sqlplus / as sysdba
SQL> alter database drop standby logfile group 1;
alter database drop standby logfile group 1
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files
Solution:
Posted in ORA-Error | Comments Off on ORA-01156: recovery or flashback in progress may need access to files
Posted by Mir Sayeed Hassan on June 18th, 2018
Find the user failed login attempts in Oracle database 11gR2
The user is created with the default profile set in database & the FAILED_LOGIN_ATTEMPTS set to 10, In this case if you exceed the more than 10 failed login attempts, then your account will be locked
Now verify the user with number of failed login attempts in database, We can find out this...
Read more..
Posted in DBA Administration | Comments Off on Find the user failed login attempts in Oracle database 11gR2
Posted by Mir Sayeed Hassan on June 17th, 2018
Script to verify the database for Primary & standby
[oracle@Prim-DB ~]$ cd /home/oracle/scripts/
[oracle@Prim-DB scripts]$ vi dblogsummary.sql
!df -h
!free
!uptime
!last reboot
set linesize 500
col host_name format a40;
select INST_ID,instance_name,STARTUP_TIME,status,archiver from gv$instance;
select name,log_mode,protection_mode,...
Read more..
Posted in DBA Scripts | Comments Off on Script to verify the database for Primary & standby
