• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

oracle

How to set the db_file_name_convert and log_file_name_convert parameters

by admin

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 […]

Filed Under: oracle

How to Identify the Last and Next Refresh Dates for a Materialized View

by admin

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 […]

Filed Under: oracle

What is spfile in Oracle Database

by admin

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 […]

Filed Under: oracle

How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command

by admin

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 […]

Filed Under: oracle, VMware

Oracle Interview Questions – oratab file

by admin

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 […]

Filed Under: Interview Questions, oracle

Oracle GoldenGate: GLOBALS Sample Parameter File

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Replicat Sample Parameter File

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Pump (Extract) Sample Parameter File

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Extract Sample Parameter File

by admin

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 […]

Filed Under: GoldenGate, oracle

Oracle GoldenGate: Manager Sample Parameter File

by admin

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 […]

Filed Under: GoldenGate, oracle

Next Page »

Primary Sidebar

Recent Posts

  • raw: command not found
  • raw Command Examples in Linux
  • rankmirrors Command Examples in Linux
  • radeontop: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright