Oracle 10g standby configuration - Restoring primary backup to Standby DB.

[former_member607029]

Hi experts,

This is my first time configuring a Standby (Data Guard) scenario for our Oracle data base. The platform used is Solaris 10 with Oracle 10g.

After reviewing a lot of documents and tutorials regarding this matter still have some doubts on how to get this scenario finally configured.

Basically I would like some confirmations regarding the following point. We have the new db already installed in our disaster recovery site and the next step I need to do is to perform an offline backup from our primary data base and then transfer that backup to our standby database. Iu2019m currently stuck in this steps since Iu2019m not completely sure on how proceed with this specific step. According to the following link http://help.sap.com/saphelp_nw04s/helpdata/en/08/5744b84ae611d1894f0000e829fbbd/content.htm , the following steps are necessary:

1. Take a backup (online or offline) of the data files of the production database

2. Create a control file at the production site to be used at the standby site, by entering the following command:

alter database create standby controlfile as <filename>

3. Archive the current online redo log of the production database, by entering the following command:

alter system archive log current

4. Transfer the backed up data files, the control file and all archived redo log files to the standby site.

Regarding the above step u201C4u201D... Could someone please detail me what all the data files are? As per SAP System Copy guide in its section u201CRestoring Database Files on the Target Systemu201D the following is indicated...and I think these are the files to transfers to the standby db.

Files/oracle/<DBSID>/sapdata<x>

All files/oracle/<DBSID>/origlog<x>

All files/oracle/<DBSID>/mirrlog<x>

Is my assumption correct?

Please let me know which the correct steps are and if any other process is applicable or advisable over the above mentioned....let me know.

Regards

[mohammed_anish]

Hi,

As far as cold backup of database is concerned, backup of the folders you have mentioned is enough.

Hope you have created a parameter file for the standby database and changed the primary parameter file as part of preparation of primary database.

Here is a sample entry you have to have on standby parameter file apart from other entries..

db_unique_name='STANDBY'

fal_client='STANDBY'

fal_server='PRIMARY'

log_archive_config='DG_CONFIG=(PRIMARY,STANDBY)'

Also browse through the following threads...it may help..

Regards,

Anish

[Former Member]

Hi,

At the first step, be sure that both sites are at the same patch level.

Follow the main steps, in order to restore primary to standby and start the log shipment, below;

1) create the password file and copy to the standby server

2) configure spfile, tnsnames.ora and sqlnet.ora on both sites

3) restore datafiles "sapdata*" and "oraarch" directories into the standby site.

4) create control.sql and execute at the standby site

5) create controlfile on primary site and copy to the standby site

6) apply offline redolog files at the standby site,

7) execute "ALTER DATABASE MOUNT STANDBY DATABASE;"

😎 start and stop listener processes at the both sites

9) execute "ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_<X>=ENABLE SCOPE=BOTH;"

10) execute "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;"

Additionally, read the document very carefully, below;

http://download.oracle.com/docs/cd/B14117_01/server.101/b10823.pdf

Best regards,

Orkun Gedik

[Former Member]

I haven't read the whole process but for point 4 -

All the datafiles are in /oracle/SID/sapdata* directories. The SAP 'data' is contained in these files and these are the major files which are 'backed' up when we run the online/offline full backup. Restore process restores majorly these files on the target, along with some other things like controlfile etc.

All files/oracle/<DBSID>/origlog<x> and All files/oracle/<DBSID>/mirrlog<x> are not datafiles.

Thanks