In Oracle database, a tablespace is a logical storage container that is used to store data objects, such as tables, indexes, and partitions. It is a way to organize and manage the physical disk space used by the database. Each tablespace consists of one or more data files, which are the actual physical files on […]
SQL Query To Find The Space Utilization of Tablespaces In Oracle Read More »
This article will discuss how to modify the SCAN name in Oracle RAC. There are situations when changing the SCAN name is necessary due to application requirements or migration/upgradation. Recently we came across such a situation where it’s necessary to change the SCAN name and below are the steps followed for modification of SCAN configuration.
This article is about ORA-10873: file 1 needs to be either taken out of backup mode or media recovered. Cause This is may be due to database went down while database is in backup mode. Error in the alert log Errors in file F:ORACLEPRODUCTDIAGdiagrdbmsbwdbbwdbtracebwdb_ora_1268.trc: ORA-10873: file 1 needs to be either taken out of backup
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered Read More »
Through this article, we will learn to drop a whole database in Oracle manually with commands. We can also use the DBCA utility to drop a whole database but this is not in scope for today’s discussion. Steps to follow for dropping a database Please follow the below steps to drop a database successfully. Please
How To Drop A Database In Oracle | How To Drop Oracle Database Manually Read More »
This is the most common error we can get after operating system (OS) patching and during start of our cluster services. Steps to Recover the Error We need to follow the below steps to rectify the error and start the cluster services.
If we want to change the port of the scan listener we can do it through the below-mentioned steps. We will change it from default 1521 to 1531. Checking present configuration $ srvctl config scan_listener SCAN Listeners for network 1: Registration invited nodes: Registration invited subnets: Endpoints: TCP:1521 SCAN Listener LISTENER_SCAN1 exists SCAN Listener is
RMAN is a backup and recovery manager supplied for Oracle databases created by the Oracle Corporation. It provides database backup, restores, and recovery capabilities addressing high availability and disaster recovery concerns. RMAN can also help in-migration from on-prem to cloud. Below are some of the basic RMAN commands, useful for daily usage. RMAN show all
Post applying the database patch sometimes you may get below error in the alert log or RMAN prompt. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.05.00.00 in TARGET database is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.05.00.00 in TARGET database is not current Recent Changes The above-mentioned errors were reported post applying the database patch. Cause Might be that these
From 12C onwards Oracle has introduced a new way of rolling forward a physical standby database by using recover from service commands. There could be a scenario where we need to roll forward a standby database from an archive log gap where the standby lags behind the primary. Our aim is to remain the standby
Rolling Forward Physical Standby Database Using Recover From Service Command Read More »
Below queries can be helpful to find details regarding temp tablespace usage. Temp segment usage per session SELECT S.sid || ‘,’ || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module, P.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace, COUNT(*) statements FROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P WHERE T.session_addr = S.saddr AND
