0
Login/Register

Uncategorized

  • Home
  • Uncategorized
Shape Image One

Change Protection Mode in Oracle 12C Dataguard

Change Protection Mode in Oracle 12C Dataguard Primary SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE—— ————- ————- ——————–OPEN prim PRIMARY MAXIMUM PERFORMANCEStandby SideSQL> select status,instance_name,database_role,protection_mode from v$database,v$instance; STATUS INSTANCE_NAME DATABASE_ROLE PROTECTION_MODE—— ————- ————- ——————–OPEN stand STANDBY MAXIMUM PERFORMANCEVerify Online logfile on PrimarySQL> select group#,bytes/1024/1024 from v$log; GROUP# BYTES/1024/1024—— ——————1 502 503 50Verify Online

Switchover in Oracle 12C Dataguard

Switchover in Oracle 12C Dataguard In this blog, We will try to understand how to perform switchover activity. Switchover activity will change the role of database. Precheck for SwitchoverALTER SESSION SET nls_date_format=’DD-MON-YYYY HH24:MI:SS’;SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;SQL> select dest_name,status,error from v$archive_dest where dest_name=’LOG_ARCHIVE_DEST_2′; DEST_NAME ——————————————————————————– STATUS ERROR ——— —————————————————————– LOG_ARCHIVE_DEST_2

Oracle Dataguard Important Command

Oracle Dataguard Important Command In this blog, We will look some important oracle dataguard command.Following command will be useful for dataguard administration Check the Dataguard database status on primary and standby select status,instance_name,database_role,protection_mode from v$database,v$instance; Query to apply redo log on standby. Following command useful for real time apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE

How to convert Snapshot Standby Database to Physical Standby Database-Oracle Dataguard

How to convert Snapshot Standby Database to Physical Standby Database-Oracle Dataguard On Standby Server In this blog, We will see how to convert physical standby database to snapshot standby database. On that, we can do all types of testing or can be used as a development database (which is an exact replication of production ).

Convert Physical Standby database to Active Dataguard

Convert Physical Standby database to Active Dataguard Active dataguard means, the standby database is open with read only mode, even when redo logs are getting applied in real time. Below are the benefit of using active dataguard. Standby database to Active DataguardNOTE – To use active dataguard, you need additional license from oracle1. Cancel the

Oracle RAC DBA Interview Questions

Oracle RAC DBA Interview Questions

Oracle DBA Interview Questions

Oracle DBA Interview Questions What are the different responsibilities of a Oracle DBA? Answer: Oracle DBA is the database administrator who performs all administrative tasks. Administrative tasks include:1 .User-level administration i.e. creates users, remove existing users or modifies user permissions.2 .Maintains database security.3 .Manages database storage & objects.4 .Tunes performance of a database.5. Performs backups &

Oracle 19C Dataguard installation using Active Duplicate Method

📦 Oracle 19C Dataguard installation using Active Duplicate Method In this blog , we will learn about the oracle 12c dataguard installation using active duplicate method. We are using oracle enterprise linux as database server PRIMARY STANDBY Hostname : node1.hireready.org node2.hireready.org IP 192.168.56.50 192.168.56.60 DB Unique Name node1 node1 We are assuming that primary database

Upgrade 12.2.0.1 to 19c Oracle Database Manually

📄 pgrade from 12.2.0.1 to 19 Assume that , 12c Already Installed Steps to upgrade Database ======================== 0. Check Compatibility Before Upgrading Oracle Database 1. Environment PRE-UPGRADE TASKS2. Backup3. Run preupgrade script4. View Preupgrade log5. Minimum tablespace sizes for upgrade6. Update INITIALIZATION PARAMETERS7. Gather DICTIONARY STATS8. Purge Recyclebin9. Refresh MVs10. Run preupgrade_fixups.sql11. Verify archive log

ASM Installation

ASM Installation ASM on vmware workstation   Prerequisites:- Step 1: Set up Oracle Database Server on VMware Workstation using( OEL) Linux 7.6 OS Platform? Step 2: Connect to OEL 7.6 server via putty and install the below packages 1  yum -y install -y oracle-database-preinstall-19c 1 yum -y install oracleasm* 1 yum -y install kmod-oracleasm* Add below OS