question

OraLearner avatar image
OraLearner asked

How does one create a standby database?

Can anybody explain to me how I can create a standby database in Oracle? Thank you.

oracledatabase
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OracleApprender avatar image
OracleApprender answered

While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!!

On your standby database, issue the following commands: ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'filename'; ALTER DATABASE MOUNT STANDBY DATABASE; RECOVER STANDBY DATABASE;

On systems prior to Oracle 8i, write a job to copy archived redo log files from the primary database to the standby system, and apply the redo log files to the standby database (pipe it). Remember the database is recovering and will prompt you for the next log file to apply.

Oracle 8i onwards provide an "Automated Standby Database" feature, which will send archived, log files to the remote site via NET8, and apply then to the standby database. When one needs to activate the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for the answer.
0 Likes 0 ·
murali 1 avatar image
murali 1 answered

if u want to configure standby dataguard i.e first to take the backup of primary database(u take backup like cold,hot,rman backup). and also take the backup of pfile and also standby controlfile .then after you will check the oracle net connection from primary and standby why means in primary the business data shifted from primary to standby .

then you will copy the fullbackup,pfile and standby controlfile. after wared you have change the pfile parameter like db_name,controlfile,fal_server,fal_client,standby_management like this some paremeter. after that you put primary database in maximum performanace mode . in stand by side you have to open with startup nomount and then it check the pfile of standby side and alter database mount standby database. then you have to put the standby database in recovey mode. then primary data shifted to the standby side

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.