Primary database Steps
1. Confirm your primary database instance where you wanted to perform the activity
SQL> select name from v$database;
NAME
---------
TRANPRD
Data Guard / Standby: ORA-01624: log %s needed for crash recovery of instance %s (thread %s)
Error Description:
Drop redo log group in data guard database is giving following error.
SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-01624: log 1 needed for crash recovery of instance TRANPRD_STANDBY (thread 1)
ORA-00312: online log 1 thread 1:
Fix DGMGRL: Warning: ORA-16826: apply service state is inconsistent with the DelayMins property
Error Description:
Show configuration command shows following warning in DGMGRL.
DGMGRL> show configuration
Configuration - PRDCONFIG
Protection Mode: MaxAvailability
Databases:
May 1st 2013: New IRCTC Train Advance Ticket Reservation Booking Period (ARP) is 60 Days
Ministry of Railways has been changed / revised their Advance Reservation
Period (ARP) to 60 days from May 1, 2013. It was 120 days till April 30,
2013. One way it is good because majority of the travelers cannot plan their
travel in advance of 4months. It will help for the genuine / frequent travelers.
How to Find out / Identify the list of Schema / Users Available Inside a expdp data pump .dmp dumpfile
This is also another interesting
question. Suppose if you get a dump from the source database and you are not
aware of the users/schemas present in the dump. If you wanted to see the list
of schemas/users present in the dump file, you can use this method to find out
the same.
Step 1. Import the dump with sqlfile option.
How to Identify / Check / Find out Oracle .dmp dumpfile is Taken Using Exp / Expdp – Data Pump
It is a common
question or doubt which arises when you get a dump file from the source
database without knowing how it is exported. It might be taken using either
conventional exp utility or data pump expdp. If you have the log file along
with the dump file, it is very easy to identify the utility. You just need to
tail the log file and you can identify as mentioned below.
Oracle 11gR2: Truncate Drop Storage Vs Drop All Storage Clauses
Drop Storage clause
is to deallocate all space from the deleted rows from the table except the
space allocated by the MINEXTENTS parameter in the table. This deallocated
space will move to free space category and it can be used for the other objects
in the tablespace. So in this drop storage clause there would be some space
which is equal to the MINEXTENTS used for the table after
the truncate command execution.
Subscribe to:
Posts (Atom)
