I have to setup a data guard (including Primary and 1 standby database) for Production DB. DB version 18.104.22.168 on RHL 6.
I know each and everything regarding single instance database installation/creation with asm,rman backups,etc everything I need. I do not know how I would create PHYSICAL STANDBY DATABASE (on another host).
which Oracle software installation option or which database creation (dbca) option?
How I would link that Standby database to the Primary database?
How to test that Standby DB is setup perfectly (archived logs shipped properly)?
How to setup Data Guard Broker setup to manage it?.
Normally, we have few DG setups and have separate machine for GRID CONTROL to manage them. But unfortunately, I have not setup any DG setup with GRID CONTROL, Agents. How to setup this GC, agents, etc?
I would highly appreciate if you could guide me in these regards plus any official document link or particular Oracle Support note id for the guidelines, so that I feel confidence to setup a complete Data Guard setup.
Bundle of thanks.
No. DBCA is use to create a new database.
Standby Database is not a new database, it's a replica of your production database.
oracle should be installed on the server where you want to create standby database.
for your reference i am giving you one more links.
This is different method.
chose which ever you find appropriate
ASM Instance through Grid Control should be setup first on Standb DB first, right?
The links describe as backup location or storage as local disk (Not with ASM). I wounder scp command would work from Primary to Standby while copying everything.
I have a test single instance db. I was thinking, If I install software only option on the same machine and create a Standby Database just for the testing purpose, as I have little time for preparation. What do you suggest?