Mir Sayeed Hassan – Oracle Blog

ORACLE DBA – ACTIVITY CHECKLISTon DAILY/WEEKLY/MONTHLY/NIGHTLY

Aim:

This activity checklist is for Oracle DBA to perform the complete health check report of production databases on Daily/Weekly/Monthly basis as per the requirement.

DAILY CHECKLIST

1. Read more..

How to reopen the expired db account without changing the password

Consider you have an expired db account & you need to recover this acccount at any cost as per your client request, Yes its possible to recover it, Find the below scenario tested in our env

Create a test user in database & try to expire this user & recover...
Read more..

How to export schema with Parallel method by using expdp

[oracle@testdb dump_bkp]$ expdp system directory=dump_bkp dumpfile=expdp%U-`date '+%d%m%Y_%H%M%S'`.dmp logfile=expdp-`date '+%d%m%Y_%H%M%S'`.log schemas=mir PARALLEL=2

Export: Release 11.2.0.4.0 - Production on Sat Oct 13 15:25:00 2018

Copyright (c) 1982, 2011, Oracle and/or... 
Read more..			

Switchover in Realtime Production database in Oracle 11gR2

=================
PRIMARY DATABASE
=================

Pre-requisite

SQL> select INSTANCE_NAME,VERSION,STATUS from V$instance;
 
INSTANCE_NAME VERSION STATUS
 ----------------... 
Read more..			

Rename a schema in Oracle Database 11gR2

Find the schema name to rename with user#

SQL> select user#,NAME from SYS.user$ WHERE NAME='TEST';

USER# NAME
 ---------- ------------------------------
 208 MIR

Now modify the schema name “MIR” to “SAYEED” as shown below

SYNTAX:

SQL> UPDATE USER$ SET... 
Read more..			

ORA-16139: media recovery required in Oracle Database 11gR2

The Ora-16139 error occur while performing the physical standby database during switchover from physical standby database to primary database in Oracle database 11gR2(11.2.0.4)

Check the status of standby db

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
... 
Read more..