• Is there a way to start the data guard observer and be able to get the shell prompt back and close the current window without aborting/exiting the data guard observer?
    Post By: admin

Oracle documentation has not mentioned such methods but the following command will allow you to start the data guard broker and getting the prompt back without exiting the data guard broker:

dgmgrl sys/password@connectIdentifier "START OBSERVER FILE=oemdbobs.dat;" &

The above command will start the observer and give the prompt back without exiting the observer.

NOTE you can also use logfile option for the dgmgrl command to create a logfile.

 

  • Can we disable FORCE logging on the primary database in data guard configuration?
    Post By: admin

NO, it is one of the pre-requisites of the Data Guard Configuration that FORCE logging must be enabled on the primary database. If you disable the FORCE logging on the primary database then you can have corrupted data in the standby databases. Please refer Oracle Support note 290161.1

  • We have a logical standby database running on Oracle 10gR2 and we are also taking backups of Logical Standby database. What will happen in this situation where we restore the Logical Standby database from the backups? Will Logical Standby database automat
    Post By: admin

Logical standby will automatically synchronize with the primary database. Please note that the foreign archived logs that arrived between the Point-in-time recovery target time and the current time will have to be re-fetched by the logical standby again, although they may have already existed on-disk at the logical standby database.

  • How to configure the Oracle Database for High Availability using the Veritas Cluster Oracle HA agent?
    Post By: admin

  • How to manually switchover from the Oracle Real Application Cluster 10g primary database to physical standby database?
    Post By: admin

Follow the steps given below to complete the switchover:

  • Shutdown all the database instances on your primary site except one database instance.
  • Shutdown all the database instances on physical standby site except the apply instance. In case you are using single instance physical standby site then that will be your apply instance. You should have only one database instance running on each cluster before the switchover.
  • Execute the following statement on SQL PLUS on the existing primary database to covert the primary database to standby role..
		SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY WITH SESSION SHUTDOWN;
  • Issue the following statement on the standby site to switch the standby database to the primary database.
		SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
  • After successful completion of previous step, execute the following statements on old primary database.
		SQL> SHUTDOWN IMMEDIATE;
		SQL> STARTUP MOUNT; 
  • After successful completion of the step 5, execute the following statement to open the new primary database.
		SQL> ALTER DATABASE OPEN;

 

  • What are terms MTTF and MTTR stand for when we talk about High Availability of the databases (well any IT system)?
    Post By: admin

MTTF(mean-time-to-failure) is the average time that a IT system runs without failing after it has been setup or repaired, whereas MTTR (mean-time-to-repair) is the average time needed to repair a failed IT system.