De-configure MRP in Standby
On Source, as Oracle user: On Target, as Oracle user: Hope it helped !! 🙂
Month: October 2022
RollForward Standby Database using rman service
Overview: As we are already aware that the rolling forward an physical standby database via an incremental SCN based backup method is one of the easiest way of getting your standby database with lag into sync with the primary database.The lag can be due to missing archives on the primary which haven’t been shipped or applied on the standby. In 12c, this procedure has been dramatically simplified. You can use the RECOVER … FROM SERVICE command to synchronize the physical standby database with primary database. … Read more
GGSCI Command for GoldenGate
INFO INFO MANAGER Provides details of the Manager process INFO MGR Also provides details of the Manager process STATUS MANAGER This command also display the info of manager REFRESH REFRESH MANAGER Reloads from the Manager Parameter file REFRESH MGR Reloads from the Manager Parameter file SEND SEND MANAGER CHILDSTATUS Displays status of processes, started by … Read more
Recover Block Corruption
What is a data block corruption? Data block corruptions occur whenever data is not in its expected state. The block may have contents that are not internally consistent, or it may have been altered to be unrecognizable as part of the Oracle Database format. Some data block corruptions are relatively minor, affecting only a single … Read more
RMAN Recovery Catalog in Oracle
RMAN recovery catalog is separate DB/ Server and which will save only the details of your backups in terms of metadata of the backup. Whenever you trigger the backup, RMAN will Update the information in the control file. Your control files can store the backup details for the last 30 days only which is the … Read more
ROWNUM Pseudocolumn
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row returned by the query), in the ordered sequence of rows specified in the … Read more
How to fix ‘ORA-01000 maximum open cursors exceeded’ issue in Oracle database
OPEN_CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors. It is important to set the value of OPEN_CURSORS high enough to prevent your application from running out of open cursors. The number … Read more