BLOCK CHANGE TRACKING
BLOCK CHANGE TRACKING Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all…
Read MoreHOW TO RESOLVE ORA-04031: UNABLE TO ALLOCATE 11513896 BYTES OF SHARED MEMORY (“LARGE POOL”,”LARGE POOL”,”CTWR DBA BUFFER”)
Step1: We want to ensure the block change tracking is enabled in our database or not by using the below sql statement. i.e, SQL> select filename,status from v$block_change_tracking; FILENAME ——————————————————————————–…
Read MoreORACLE GOLDEN GATE ERROR OGG-00868
In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…
Read MoreHOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…
Read MoreORACLE OS WATCHER
ORACLE OS WATCHER What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance…
Read MoreORACLE TRACE FILE ANALYZER UPGRADE TO 21.1.2
TRACE FILE ANALYZER UPGRADE TO 21.1.2 Oracle Trace file Analyzer provides a number of diagnostic tools in single bundle, making it easy to gather diagnostic information about oracle database and…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER
EXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreSCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING CURRENTLY
SCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read MoreDATABASE INCARNATION
In this tutorial we are going to learn about Database incarnation. I have mentioned below about incarnation and its different types of incarnation falls. Then follow below example for how…
Read MoreEXPORT DP AND IMPORT DP IN SCHEMAS PARAMETER USING PARFILE
EXPORT DP AND IMPORT DP IN SCHEMAS PARAMETER USING PARFILE In this tutorial we are going to learn about how to do export and import datapump using schemas parameter DESCRIPTION: A schema export is specified using the schemas parameter. This is the default export mode. If you have the DATAPUMP_EXP_FULL_DATABASE role, then you can specify a list of schemas, optionally including the schema definitions themselves and also system privilege grants to those schemas. If you do not have the DATAPUMP_EXP_FULL_DATABASE role, then you can export only your own schema. The sys schema cannot be used as a source schema for export jobs. [oracle@oracle ~]$ expdp directory=parexp dumpfile=schema.dmp logfile=schema.log schemas=lockdown Export: Release 12.2.0.1.0 – Production on Tue Sep 22 08:08:55 2020 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Username: lockdown/dba1 Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production Starting “LOCKDOWN”.”SYS_EXPORT_SCHEMA_04″: lockdown/******** directory=parexp dumpfile=schema.dmp logfile=schema.log schemas=lockdown Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA…
Read More