How to create Physical standby in Oracle

Creating a Physical standby database in oracle requires certain pre-requite to be fulfilled. And creation will be based on scenario and environment you are in!

Pre-requistes -

1. Determine how much disk space will be required.
2. Create same mount points on DR as that of Primary databases.
3. Additional Backup space will be required on both side ie primary as well as standby.
4. Get port opening done between both the servers Primary and Standby database.(Contact with your Network team and Firewall team for more details)
5. Version of Oracle home and grid home installed on standby database should match with Primary database.
6. Primary database in force logging mode and archivelog mode.
7. Listener is configured and running on both servers - Primary and Standby.
8. The Platform/OS of the Standby Database server is the same as the Primary Site
9. We can have hetrogenous standby database depending upon the combination.

Basic Steps for creating a standby database - Click here

1. Backup the primary database including archives.
2. Making the backup available for the standby creation process.
3. Creating the Parameter file & directories if not available on the standby database server.
4. Prepare RMAN standby script.
5. Execute the RMAN script.
6. Additional steps to enable Data guard

Here are scenarios I came across and have tried it.

How To Create Physical Standby On Normal File System on New Host for ASM Primary
How To Create Physical Standby On ASM file system on New Host for ASM Primary
How To Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE
How To Create Physical Standby using 12c Feature