Database Solutions

Oracle Data Migration with expdp and impdp For Oracle DBA data migration using Export Import is common activity in day to day activity. Either you need to migrate data from Different version of oracle or between two different platform like windows server o linux platform. Export import is used mostly but require complete downtime for the database migration. In this blog ,We will share the steps to migrate the database from one database to another database using export and import.  Below steps can be used for the same: 1) Create an empty database in target server and make sure database is in noarchive log mode.  Make sure that the parameter for the source and target databases are same.  Make list of application tablespace from source database to target database. You can get the DDL for all tablespaces in source databases using below command: SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN    DBMS_METADATA.set...

Oracle Flashback Database , Restore point and GUARANTEE Point Flashback Database is as name suggest allow you to revert or rewind database to a point in when restore point is created in database. Restore point is a pointer which point to a SCN or effectively a time in past in database. So if we flashback database to a restore point effectively , We are reverting it back to the a point in time. In other words, It a point in time revert backup of database like DB Ponit in time recovery.  There are two type of restore point 1) Normal Restore Point & 2) Guaranteed Restore Point.   The difference between these two is that guaranteed restore point allows you to flashback to the restore point regardless of the DB_FLASHBACK_RETENTION_TARGET initialization parameter. Using guaranteed restore points is always possible as long as you have enough space in the flash recovery area. Guaranteed restore point never age out like normal restore point. You must explicitly drop the guaranteed ...

Partial recovery of database using RMAN For oracle DBA ,Their could be situations where application team can request to restore partial database up to a point in Time.. (Means few application tablespace). In todays blog , We will discuss about how we can resolve such situation. Assumption is that we are doing partial database restore on the different server then production server. Below are the steps , We are going to follow for partial recovery: Step 1) Create pfile from spfile and make modifications as per the storage in New machine like the new disk group name etc. more inittedtdb.ora tedtdb.__db_cache_size=16240345088 tedtdb.__java_pool_size=67108864 tedtdb.__large_pool_size=67108864 tedtdb.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment tedtdb.__pga_aggregate_target=12884901888 tedtdb.__sga_target=19327352832 tedtdb.__shared_io_pool_size=0 tedtdb.__shared_pool_size=2415919104 tedtdb.__streams_pool_size=134217728 *._trace_files_public=TRUE *.audit_file_dest...

Oracle Block Corruption - Detection and Resolution Any kind of corruption in database can  lead to stand still operation of the organization and can cause sever impact to organisation. In this blog , We are going to discuss about Block Corruption of the oracle database. Block Corruption :  Oracle Block Corruption occurs due inconsistent block Header ,Footer ,Checksum or Structure. Depending on the kind of insistency ,We can divide corruption into Physical and Logical corruption. Physical Corruption is due to Bad header, header or footer mismatch ,Invalid Block checksum & misplaced block. Usually this kind of the block corruption are due to external reason and difficult to resolve by oracle utilities alone.  Logical Corruption is due to corrupt or invalid Block structure when block checksum is valid. This kind of the Corruption can be resolved by the Oracle Utilities. Detection of Block Corruption Whenever a corrupt block is read Oracle reports an error in the alert l...