db_file_name_convert and log_file_name_convert is used to convert the File Locations of Datafiles, Online and Standby RedoLog Files of a Database to the correct Location on a Database created from this Database having a different File Structure. So it can be used for Physical Standby Databases and RMAN Duplicate/TSPITR-Operations. The general Setting is one Pair or […]
oracle
How to Identify the Last and Next Refresh Dates for a Materialized View
A Materialized View refresh synchronizes the MVIEW with it’s master table. In the case of updateable MVIEWs, changes from the MVIEW site are first propagated to master site if the refresh’s push_deferred_rpc parameter is TRUE. Then, changes are pulled from the master site. Pulling rows from master can be either performed using the mview log […]
What is spfile in Oracle Database
What is an SPFILE? A server parameter file (SPFILE) is a new feature introduced in Oracle9i. Initialization parameters stored in a server parameter file are persistent, in that any changes made to the parameters while an instance is running can persist across instance shutdown and startup. This eliminates the need to manually update initialization parameters […]
How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command
In this post, we will discuss about how to convert IMG Files to VDI, VMDK, VHD format for Oracle VirtualBox, Vmware and XenCenter. First We have to take Image from Linux System and It will take some time. 1. Open the windows cmd. Click Run -> cmd -> Enter 2. Notice that Windows open a […]
Oracle Interview Questions – oratab file
Oracle provides a mechanism for automatically setting the required OS variables. This approach relies on two files: oratab and oraenv. You can think of the entries in the oratab file as a registry of what databases are installed on a box and their corresponding Oracle home directories. The oratab file is automatically created for you […]
Oracle GoldenGate: GLOBALS Sample Parameter File
This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup in line with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. The GLOBALS file stores parameters that relate to the GoldenGate […]
Oracle GoldenGate: Replicat Sample Parameter File
This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Replicat Process The replicate process is the apply process within an Oracle […]
Oracle GoldenGate: Pump (Extract) Sample Parameter File
This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Pump (Extract) Process The data pump group is a secondary extract group […]
Oracle GoldenGate: Extract Sample Parameter File
This post provides sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Extract Process The extract process of Oracle GoldenGate is used to perform […]
Oracle GoldenGate: Manager Sample Parameter File
This post provides a sample example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication setup inline with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Manager Process The manager process is not the most talked about […]