Skip to Content
0
Former Member
Aug 09, 2010 at 06:48 AM

Step by Step - Create Oracle Standby DB

97 Views

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