Below are some of the frequently used Physical Standby Data Guard related SQL queries 1) Basic information of database (primary or standby) SQL> SELECT DATABASE_ROLE,…
6 CommentsAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Below is basic diagram of Data Guard Physical Standby Database: PHYSICAL STANDBY DATA FLOW Let us understand how the data flows in data guard…
5 CommentsOracle is tightening up security around Java. Java is one of the most wildly exploited piece of software by viruses and malware bots. Code signing…
2 CommentsOracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data. Data Guard provides a comprehensive set of services that create, maintain,…
6 CommentsSome of the Oracle Data Guard related questions are listed below. Q 1 What is data guard in simple language? A 1 Your…
60 CommentsRMAN performs backup and recovery tasks on the databases and automates administration of the backup strategies. It greatly simplifies backing up, restoring, and recovering database files.…
11 CommentsEvery Oracle Database has a control file as one of its important file. It is a small binary file that records the physical structure of the database.
The control file includes:
– Database name
– Names and locations of associated datafiles and redo log files
– The timestamp of the database creation
– The current log sequence number
– Checkpoint information
To work with RMAN, you must configure several things, which can be default backup type (disk or tape), the number of channels you want to use, and the degree of parallelism.
When you are testing it on your personal system, you probably can get by with RMAN’s default configuration settings. However, for production jobs involving sophisticated backup strategies, you need to customize RMAN’s configuration settings to fulfill all your requirement. You can configure different backup retention policies, for example, for different databases.
Leave a CommentYou can grant a user restricted access to the base recovery catalog by granting that user read/write access only to that user’s RMAN metadata, also…
1 Comment