Loading...

We have seen 3 types of Standby Databases

  1. Physical Standby Database
  2. Logical Standby Database
  3. Snapshot Standby Database

To know more about it Oracle Dataguard

Oracle 11g comes with a new option : Oracle Active Data Guard.

Oracle Active Data Guard is an optional license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that extend basic Data Guard functionality. Oracle Active Data Guard allows us to use real time query the standby database.

Architecture :

Oracle Active Data Guard gives us read only access while applying redo. Redo streams are transmitted from primary database to standby database server , that is first written to standby redo log files and then redo are applied to Standby Database.

At Standby side we can see each committed transaction of primary database as soon as Standby Database is in sync with Primary Database.

Functionality we can use from Active Data Guard :

  • Real-Time Query – Offload read-only workloads to an up-to-date standby database
  • Automatic Block Repair – Automatic repair of physical corruption transparent to the user
  • Far Sync – Zero data loss protection across any distance
  • Standby Block Change Tracking – Enable incremental backups on an active standby
  • Active Data Guard Rolling Upgrade – Make it simple to reduce planned downtime
  • Global Database Services – Load balancing and service management across replicated databases.
  • Application Continuity – Make outages transparent to users.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Oracle Active Data Guard Overview & Architecture appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In the previous post, we convert Physical Standby to Snapshot Standby . In this post, we can convert Snapshot Standby to Physical Standby.

Prerequisites : Snapshot database is already exists

Primary Database Snapshot Standby database
mgr mgr

Step 1 : Check Primary Database Information :

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       PRIMARY

Step 2 : Check Snapshot Database Information :

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       SNAPSHOT STANDBY

Step 3 : Shut down standby database  :

SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Step 4 : Start standby database in mount state :

SQL> STARTUP MOUNT
ORACLE instance started.

Total System Global Area  392495104 bytes
Fixed Size		    2253584 bytes
Variable Size		  176164080 bytes
Database Buffers	  209715200 bytes
Redo Buffers		    4362240 bytes
Database mounted.
SQL>

Step 5 : Convert database to physical standby database :

SQL> ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

Database altered.

Step 6 : View information of physical standby database :

SQL>  SELECT NAME,OPEN_MODE,DATABASE_ROLE FROM V$DATABASE;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  MOUNTED	       PHYSICAL STANDBY

SQL>

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Converting a Snapshot Standby Database to a Physical Standby Database appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In the previous post, we can read about Snapshot Standby Overview. In this post, we can convert to Snapshot Standby.

Prerequisites :

Physical Standby Database is already created and synchronized with Primary Database .

Database Details :

Step 1: Check Primary database :

[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 27 15:09:14 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME	  OPEN_MODE
--------- --------------------
MGR	   READ WRITE

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	   READ WRITE	       PRIMARY

SQL> select max(sequence#) from v$thread;

MAX(SEQUENCE#)
--------------
	    56

Step 2 : Check Standby Database :

[oracle@test1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 27 15:10:33 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  MOUNTED	       PHYSICAL STANDBY

SQL> select max(sequence#) from v$thread;

MAX(SEQUENCE#)
--------------
	    56

Step 3 : Stop recovery.

SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.

Step 4 : Convert physical standby to snapshot standby using following command:

SQL> alter database convert to snapshot standby;                                               

Database altered.

SQL>

check alert log

alter database convert to snapshot standby
Starting background process RVWR
Fri Apr 27 16:44:30 2018
RVWR started with pid=35, OS id=14563 
Allocated 3981120 bytes in shared pool for flashback generation buffer
Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_04/27/2018 16:44:30
Killing 4 processes with pids 11523,11517,11519,11521 (all RFS) in order to disallow current and future RFS connections. Requested by OS process 11541
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
RESETLOGS after incomplete recovery UNTIL CHANGE 1216480
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Resetting resetlogs activation ID 1906664927 (0x71a565df)
Online log /u01/oracle/fast_recovery_area/STD_MGR/onlinelog/o1_mf_1_ffcscxwk_.log: Thread 1 Group 1 was previously cleared
Online log /u01/oracle/fast_recovery_area/STD_MGR/onlinelog/o1_mf_2_ffcsczdm_.log: Thread 1 Group 2 was previously cleared
Online log /u01/oracle/fast_recovery_area/STD_MGR/onlinelog/o1_mf_3_ffcsd0p0_.log: Thread 1 Group 3 was previously cleared
Standby became primary SCN: 1216478
Fri Apr 27 16:44:33 2018
Setting recovery target incarnation to 4
CONVERT TO SNAPSHOT STANDBY: Complete - Database mounted as snapshot standby
Completed: alter database convert to snapshot standby
Fri Apr 27 16:44:42 2018
ARC1: Becoming the 'no SRL' ARCH

View Snapshot Database Information :

Step 5 : Check role of snapshot database :

SQL> select name,open_mode,database_role from v$database;

NAME	  OPEN_MODE	       DATABASE_ROLE
--------- -------------------- ----------------
MGR	  READ WRITE	       SNAPSHOT STANDBY

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Converting a Physical Standby Database to a Snapshot Standby Database appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
We have already seen overview of snapshot standby database.
But while converting snapshot standby database few things we need to consider.
  1. Corruption of log files : As we already know snapshot database accepts redo log files from primary when it is converted to snapshot mode but it does not apply redo log to snapshot standby. So, if there is a corruption of redo log file at the standby database has occured , we can not discover it until snapshot standby database is converted back to physical standby database and managed recovery is started. If flashback log file is lost or corruption occured in that , it might prevent reverse conversion.[snapshot standby – physical standby].
  2. Time constraint in case of failover process : If in worst case if primary database crash while physical standby database is converted into a snapshot standby database , we need time to convert it to physical standby and then physical standby to PRIMARY role. And if there is lots of redo that needs to be applied it becomes lengthy process to convert snapshot standby to physical standby database.
Target Restrictions :
Snapshot standby database gives many benefits. But there are some restrictions when we want to activate snapshot standby database.
  1. When you are using Maximum Protection mode for your database and you want to use snapshot standby database , minimum 2 standby database must be configured for your primary database else you can  not convert your physical standby database to snapshot standby database.
  2. Snapshot standby database can not be a target of switchover process.
  3. Snapshot standby database can not be a target of a fast-start failover target.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Activating a Snapshot Standby Database:Issues and Cautions and Target Restriction appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Snapshot Standby Database :

We have already seen types of standby database in Data Guard. Oracle Dataguard

In this article we are going to see Snapshot Standby Database in deep.

In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database into a snapshot standby database.

When standby database is converted into a snapshot database , it receives redo data but , it does not apply that redo data from a primary database. The redo data is kept in a standby database server . Once snapshot standby database is converted back into a physical standby database , it discards all local updates done in a snapshot database and then applies redo data kept in a standby server.

Architecture : 

We can see in above diagram , every process that works in data guard , works fine here except MRP process. When database is converted from physical standby database to snapshot standby database , MRP process is on hold.

Redo are generated from primary and recorded to standby in archive log files.

As snapshot database is on fully update-able mode , we can do transactions on standby database.We can say snapshot database is cloned copy of primary database.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Snapshot Standby Databases: Overview & Architecture appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Today we are going to learn about “SQL Loader”. The journey of Oracle Database does not end here.  Let’s have look at the technical definition of SQL Loader.

what is SQL Loader?

The primary method for quickly populating Oracle tables with data from external files is called SQL*Loader. From its powerful data parsing engine that puts a little limitation on the format of the data in the datafile. SQL*Loader is invoked when you specify the sqlldr command or use the Enterprise Manager interface.

SQL*Loader is an integral feature of Oracle databases and is available in all configurations.

Follow these steps to perform SQL Loader

  1. Create a file and give it a name (Ex: data_1.txt)
  2. Insert some valuable data in it. Here we have insert the following things into data_1.txt

1, Anuradha

2, Priya

3, Jack

4, Himanshu

5, Jissy

6, Joel

  1. Create a SQL Loader control file and give it a name. Here we have create a control file which name is LOADER_1.CTL

load data infile ‘c:\data_1.txt’ into table info fields terminated by ‘,’ (id,name)

Now create a table in database

SQL>CREATE TABLE info_1(id number,name varchar(30)); [Under Scott user]

Run the sqlldr

C:\>sqlldr userid=scott/abc#23 CONTROL=c:\LOADER_1.CTL

Now, we can fetch the data from tables

SELECT * FROM info_1;

Thanks for giving valuable time to add new gems to Oracle’s treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post SQL Loader in Oracle appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Today we are going to have look at Role in Oracle database. It is the most important part of Oracle database. User Privileges and Roles is the most common task that is performed by Oracle DBA. With roles and privileges, we can easily point out which user has what responsibilities in databases.

Let’s start with roles in Oracle.

Creating a Role:

create role OracleHelp;

Assign Privilege to a role:

grant create session,create table to OracleHelp;

Assign More Privilege to the role:

SQL> Create table test(id number);

SQL> grant select,insert,update on test to OracleHelp;

Add Another Layer To The Heirarchy:

SQL> CREATE ROLE manager;

SQL> GRANT OracleHelp TO manager;

SQL> GRANT DELETE ON test TO manager;

Assigning Role to user:

GRANT OracleHelp TO scott;

GRANT manager TO Allen;

Granting System Priviledge:

GRANT CREATE SESSION to managee WITH ADMIN OPTION;

Revoke Role From a User:

REVOKE manager FROM Tallen;

Drop a Role:

DROP ROLE manager;

Obtaining Role Information:

  • DBA__ROLES
  • DBA_ROLES_PRIVS
  • ROLE_ROL_PRIVS
  • DBA_SYS_PRIVS
  • ROLE_SYS_PRIVS
  • ROLE_TAB_PRIVS
  • SESSION_ROLES

Thanks for giving valuable time to add new gems to Oracle’s treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Managing Role in Oracle appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

We are going to have look at another part of the Oracle database. Flashback is going to be the topic of our discussion of today. Let’s start with its introduction after that with its example.

Being DBA we have to make us familiar with Flashback technology. It is considered as a good feature of Oracle Database.

What is flashback technology? 

Let’s have a technical definition of flashback technology.

Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

We can perform multiple tasks with the help of flashback technology some of them are mention below:-

  • It performs queries that return past data
  • We can perform queries that return metadata that shows a detailed history of changes to the database.
  • Recover tables or rows to a previous point in time is the most beautiful feature of flashback technology.
  • We can see that it automatically track and archive transactional data changes.
  • It rolls back a transaction and its dependent transactions while the database remains online.

Before use flashback technology we have to set some location and parameters so Oracle Database can give us better solutions.

RVWR Background Process

A new RVWR background process is started when Flashback Database is enabled. It is similar to the LGWR (log writer) process. The new process writes Flashback Database data to the Flashback Database logs.

Enabling Flashback Database:

Make sure the database is in archive mode and FLASHBACK_ON Yes

SQL>SELECT flashback_on, log_mode FROM v$database;

Configure the recovery area(if necessary) by setting the two parameters:

  • db_recovery_file_dest
  • db_recovery_file_dest_size

Open the database in MONT mode and turn on the flashback feture:

SQL> STARTUP MOUNT;
SQL>ALTER DATABASE ARCHIVELOG; [If not in archive mode]
SQL> ALTER DATABASE FLASHBACK ON;
SQL> ALTER DATABASE OPEN;

Test Case

SQL> create table test_flashback(name varchar(30));
SQL> insert into test_flashback values('TEST BEFORE');
SQL> commit;
SQL> select to_char(sysdate,'dd-mm-yy hh24:mi:ss') from dual;
SQL> SELECT current_scn FROM v$database;
SQL> insert into test_flashback values('TEST AFTER');
SQL> commit;
SQL> select * from test_flashback;
SQL> drop table test_flashback;
SQL> shutdown immediate;
SQL> startup mount;
SQL> FLASHBACK DATABASE to timestamp to_timestamp('16-05-2018 13:59:45', 'DD-MM-YYYY HH24:MI:SS');
OR
SQL> FLASHBACK DATABASE TO SCN 3726625;

SELECT current_scn FROM v$database;
SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> SELECT * FROM test_flashback;

Another Example:

SQL> conn Oraclehelp/Oraclehelp
SQL> create table test_flash(id number);
SQL> commit;
SQL> drop table test_flash;
SQL> flashback table test_flash to before drop;
SQL> select * from test_flash;

Thanks for giving valuable time to add new gems to Oracle’s treasure.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Flashback in Oracle appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I wrote two OCM exams back to back because I want to write 2-days OCM 12C exam but there was no schedule in India for 2-days OCM 12C exam, So first, I wrote 2-days OCM 11G on 9th & 10th April and then I wrote an exam of OCM 12C Upgrade on 23rd April in India, After 18 long days, the result was out. Now officially I’ve successfully passed 12C OCM, Oracle Database 12c Certified Master. It was almost more than 15 months that I’ve been preparing for this exam but actual preparation started almost 6 years back when I started my DBA career.

The Exam contains 4 skillsets which you have to complete in 1-Days. To earn this certification you need to get overall 59.17% marks.

  • Minimum Skill-set wise Passing Scores:
    • General Database and Network Administration, and Backup Strategy: 55.56%
    • Data and Performance Management: 31.74%
    • Data Guard: 43.39% 
    • Grid Infrastructure and RAC: 44.28%

This was the result of the journey: Oracle Certified Master 12c

After earning this certificate, I achieved all level of certification in Oracle.

  • Oracle Certified Master OCM
  • OCM Cloud & OCM MAA
  • Oracle Certified Professional OCP
  • Oracle Certified Expert OCE
  • Oracle Certified Specialist OCS
  • Oracle Certified Associate OCA

To earn OCM credentials, we need to complete following steps

Step 1: Candidate must be OCM 11g

Step 2: Candidate must pass the OCM exam

Step 3:  Submit Fulfillment Kit Request

As per Oracle OCM website below is the exam environment for 12c OCM

  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0  64 bit
  • Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4

How to prepare for the exam?

How to register the exam?

If you want to enroll exam, please click on below link.

Exam Number:12COCMU

Exam Title: Oracle Database 12c Certified Master Upgrade Exam

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:12COCMU

Note: This exam has not conducted by Pearson, so we need to check the OCM Schedule from the below link.

View A Worldwide OCM Schedule

Below are the Exam Details related to scoring and pricing ( which may vary as per country)?

Special Thanks

Joel Perez is an Oracle OCM and ACED who gave an opportunity to write with him and motivating me to learn new things.  I’m very thankful to him as this was the kick off for my studies.

I am also thankful OracleHelp Team.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post OCM 12C Journey appeared first on ORACLE-HELP.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In Previous article we have seen Primary Database Preparation for Data Guard Configuration.

In this article we will see Oracle Net Configuration on Primary and Standby.

Step 1 : Configure tnsnames.ora file at Production.

[oracle@test1 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TESTDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb)(UR=A)
    )
  )

STD_TESTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)(UR=A)
    )
  )
[oracle@test1 ~]$

Here we can see two net services. TESTDB for Primary Database Connection and STD_TESTDB for standby database configuration.

Step 2 : We need to add static entry for standby database in listener.ora file at standby side.

[oracle@localhost admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
SID_LIST_LISTENER=
	(SID_LIST=
		(SID_DESC=
		   (ORACLE_HOME=/u01/oracle/product/11.2.0/db_1)
		(SID_NAME=testdb)
	)
)
ADR_BASE_LISTENER = /u01/oracle

Step 3 : Add net service entry in tnsnames.ora at standby side for Primary and Standby Database.

[oracle@localhost admin]$ cat tnsnames.ora 
testdb=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)(UR=A)
    )
  )

STD_TESTDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testdb)(UR=A)
    )
  )
[oracle@localhost admin]$

Step 4 : Start listener at standby side.

[oracle@localhost admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-APR-2018 23:14:29

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Starting /u01/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                21-APR-2018 23:14:30
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "testdb" has 1 instance(s).
  Instance "testdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost admin]$

Step 5: Check tnsping for standby and primary from both side.

Primary Database :

[oracle@test1 admin]$ tnsping testdb

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-APR-2018 23:18:38

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testdb)(UR=A)))
OK (0 msec)
[oracle@test1 admin]$ tnsping std_testdb

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-APR-2018 23:18:45

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testdb)(UR=A)))
OK (10 msec)
[oracle@test1 admin]$

Standby Database.

[oracle@localhost admin]$ tnsping std_testdb

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-APR-2018 23:19:22

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testdb)(UR=A)))
OK (0 msec)
[oracle@localhost admin]$ tnsping testdb

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 21-APR-2018 23:20:20

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.16)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = testdb)(UR=A)))
OK (10 msec)
[oracle@localhost admin]$

In next articles we will see creating standby database using different methods.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

The post Oracle Net Configuration for Data Guard appeared first on ORACLE-HELP.

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview