In this post , we are going to explain how can you recover the data of a table from the past timestamp with FLASHBACK on
Recover data of table from FLASHBACK
In this post , we are going to explain how can you recover the data of a table from the past timestamp with FLASHBACK on
Top "ForeGround Wait Events" from AWR history
This post describe the SQL to fetch "Top 5 Fore-Ground Wait Events" from history of Oracle database which can be used to analyze the performance of database while a defined time interval.
Top SQL by "Physical Reads" from AWR history
This post describe the SQL to fetch TOP SQL by Physical Reads from Historical per AWR Snapshots from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
Top SQL by "Elapsed Time" reads from AWR history
This post describe the SQL to fetch "TOP SQL by Elapsed Time" from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
Segmentation Fault During Duplicate From Active Database
Scope:
This post explains the solution to resolve the SEGMENT FAULT error message while Duplicate database from source using RMAN Duplicate method.
Symptoms:
channel ORA_DISK_1: starting datafile copy
copying current control file
Oracle instance started
This post explains the solution to resolve the SEGMENT FAULT error message while Duplicate database from source using RMAN Duplicate method.
Symptoms:
channel ORA_DISK_1: starting datafile copy
copying current control file
Oracle instance started
Drop PDB (Pluggable database) from RAC CDB (Container Database) in Oracle 12c
Scope:
This post explains the easy steps to remove the Plugabble database from RAC Container database.
This post explains the easy steps to remove the Plugabble database from RAC Container database.
How to restart Oracle 12c Database with Pluggable Database (PDBs)
Purpose: This post explains the method to shutdown and restart the Oracle 12c Database with PDB
Steps:
Steps:
- Connect to root container CDB$root
- Stop (all/one by one) pluggable database/s
Apply PSU patch in RAC database with physical standby database in place
Scope:
This post explains steps to "Apply PSU patch" on database with Physical standby.
This post explains steps to "Apply PSU patch" on database with Physical standby.
How to find bind variable name and value of a SQL Id
Scope:
Some times it is required by a DBA to find explain plan of a query which might be responsible for bad performance of your database.
Top SQL by Logical reads from AWR history
Scope:
This blog shared method to fetch TOP sqls from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
This blog shared method to fetch TOP sqls from history of Oracle database which can be used to analyse the performance of database while a defined time interval.
ORA-01110: data file 1 while duplicate database from physical standby
Scope: While duplicating database from standby database, you might be getting below error message as recovery is required for datafile 1.
ORA 2020 too many database links in use
Scope: While selecting data with DBLink (Database Link) produces error ORA-02020 instead providing output from source database.
Duplicate database from Physical standby database as target
Subscribe to:
Posts (Atom)