Step by Step - Create Oracle Standby DB

[Former Member]

Dear all,

<BR>I am tring to create oracle Standby DB by brtools.

<BR>The steps is :

<BR><BR>1. Mount Standby DB /oracle/QAS to Primary DB /oracle/QASCP

<BR><BR>2. Copy Primary DB

<BR> On the Primary DB, use brtools-> 4.backup ... -> 3.Database Copy

<BR> backup device type = disk_standby

<BR> backup type = offline

<BR> new_db_home = /oracle/QASCP (initQAS.sap)

<BR><BR>3. Open Standby DB at standby mode (i am not sure the following path is correct)

<BR> On the Standby DB, user brtools-> 1.Startup... -> 1. Start up database

<BR> Database startup to-state = standby

<BR><BR>4. On the Primary DB, use the following command to copy offline redolog files to Standby DB

<BR> Mount Standby DB /oracle/QAS/oraarch to Primary DB /oracle/QAS/saparch

<BR> archive_copy_dir = /oracle/QAS/saparch (initQAS.sap)

<BR> brarchive -sd -d disk -f -w -u SYSTEM/password

<BR><BR>5. Apply Offline redolog

<BR> On the Standby DB,

<BR> brarchive -sd -d disk -f -m 10 -u system/password

<BR><BR>Now when Standby DB apply offline redolog file, the following errors occurs:

<BR><BR>ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

<BR>ORA-01152: file 1 was not restored from a sufficiently old backup

<BR>ORA-01110: data file 1: '/oracle/QAS/sapdata1/system_1/system.data1'

<BR><BR>I also check the data file SCN on the control file and data file header, and i find that the data file SCN on the data file header is bigger than the SCN on the control file.

<BR><BR>How should i solve this problem? Or the creating step is wrong?

<BR><BR>Can anyone give advices?

<BR><BR>Best Regards,

<BR>Wu

[former_member182034]

hi dear,

please check this link

cheers,

[Former Member]

Dear majamil,

My case is not the same as the link.

If i use the link case to solve my problem, my control file will not be standby control file.

Best Regards,

Wu

[former_member182034]

ok..

then dear you have to check following link

http://arjudba.blogspot.com/2008/05/ora-01547ora-01194ora-01589-during.html

http://arjudba.blogspot.com/2008/05/recovering-through-added-datafile-with.html

Regards,

majamil

[Former Member]

Dear majamil,

Both links are used for normal DB recovery scenario.

But my case is applying archive log on the standby DB.

So, both of soluiton are not suitable for me.

If i use the solution to solve the problem, i will not start DB at standby mode.

Best Regards,

Sean

[Former Member]

Hi,

There are several links available on internet to create and manage standby db.

Just google for the same.

In short,

1. You need to take database backup of source system including redologs, datafiles, archivelogs.

2. Restore it on Target system.

3. Generate standby control file on source system.

SQL> Alter database create standby controlfile as "/path/to/new_controlfile/control.dbf";

4. Copy standby controlfile to target system.

5. start target database in mount mode

SQL> startup mount;

Check the status..

Regards.

Rajesh Narkhede

[Former Member]

Hi Rajesh Narkhede,

Thanks for you suggestion.

After tracing log of brtools, i find that brtools create standby control file before backup database(brtools bug ?).

Now i will recopy data base from brtools like the step 2.

After finishing copy process, i will recreate the standby control file again and try the applying redo log to check if the procedures are correctly.

Best Regards,

Wu

[Former Member]

Dear all,

Thanks for help,

The problem is solved by recreating the standby profile after db copy.

Best Regards,

Wu