3 Replies Latest reply: Jun 3, 2014 1:23 AM by sherkhan RSS

    Rebuild physical standby database

    976127

      Hi All,

       

      I need to re build physical standby database now. Yesterday switchover activity got  failed and need to bring standby db in read write mode. So at this moment we have 2 primary database.

      My db version is Oracle 10.2.0.1.0 in windows 2003 64bit.

       

      I have daily RMAN backup running in production db. I already copied the backup &  want to restore in standby db but getting below errors.

       

      Microsoft Windows [Version 5.2.3790]
      (C) Copyright 1985-2003 Microsoft Corp.

      C:\Documents and Settings\kumarim>set oracle_sid=eamdr

      C:\Documents and Settings\kumarim>rman target /

      Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 30 12:24:20 2014

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      connected to target database (not started)

      RMAN> startup nomount;

      Oracle instance started

      Total System Global Area    4294967296 bytes

      Fixed Size                     2009792 bytes
      Variable Size               2852128064 bytes
      Database Buffers            1426063360 bytes
      Redo Buffers                  14766080 bytes

      RMAN> restore standby controlfile from 'D:\Controlfile_bak\O1_MF_NCNNF_TAG201405
      30T122011_9RJ1QWF0_.BKP';

      Starting restore at 30-MAY-14
      using target database control file instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=156 devtype=DISK

      channel ORA_DISK_1: restoring control file
      channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
      output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL01.CTL
      output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL02.CTL
      output filename=D:\MAXIMODATA\ORADATA\MAXPROD\CONTROL03.CTL
      Finished restore at 30-MAY-14

      sql statement: alter database mount standby database
      released channel: ORA_DISK_1

      RMAN> run
      2> {
      3> ALLOCATE CHANNEL c1 DEVICE TYPE DISK ;
      4> restore database;
      5> }

      allocated channel: c1
      channel c1: sid=123 devtype=DISK

      Starting restore at 30-MAY-14
      Starting implicit crosscheck backup at 30-MAY-14
      Crosschecked 10 objects
      Finished implicit crosscheck backup at 30-MAY-14

      Starting implicit crosscheck copy at 30-MAY-14
      Crosschecked 5 objects
      Finished implicit crosscheck copy at 30-MAY-14

      searching for all files in the recovery area
      cataloging files...
      cataloging done

      List of Cataloged Files
      =======================
      File Name: D:\MAXIMODATA\FLASH_RECOVERY_AREA\EAMDR\2014_01_22\O1_MF_NCNNF_TAG201
      40122T121230_9FYK9HDD_.BKP
      File Name: D:\MAXIMODATA\FLASH_RECOVERY_AREA\EAMDR\O1_MF_NCNNF_TAG20140122T12123
      0_9FYK9HDD_.BKP


      creating datafile fno=1 name=D:\MAXIMODATA\ORADATA\MAXPROD\SYSTEM01.DBF
      released channel: c1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of restore command at 05/30/2014 12:29:51
      ORA-01180: can not create datafile 1
      ORA-01110: data file 1: 'D:\MAXIMODATA\ORADATA\MAXPROD\SYSTEM01.DBF'

      RMAN>

       

       

      1.Do I need to delete existing data files  or it will overwrite?

      2.After restoration , do I need to create standby logfiles?

      3.can you please share me steps how to rebuild physical standby using RMAN backup?

       

      Can anyone advice me on this issue?

       

      Thanks,

      Meena

       

       

       


        • 1. Re: Rebuild physical standby database
          Hemant K Chitale

          Have you checked the datafile path on the standby ?  Is it / should it be the same as in Production ?  The RESTORE command seems to be attempting the same path as production.  Check if you have a windows service running.

           

          You will need to recreate the standby redo logs as you've got a new controlfile and recreated the standby database instance.

           

          Rebuilding a standby is done in the same way as creating a standby in the first place.

           

           

          Hemant K Chitale

          • 2. Re: Rebuild physical standby database
            Renu-Oracle

            Hi Meena,

             

            You need to check the directory structure at standby,location D:\MAXIMODATA\ORADATA\MAXPROD wxist at standby?

             

            You may have to set newname for datafile before restore.

             

            Thanks,

            Renu

            • 3. Re: Rebuild physical standby database
              sherkhan

              Hi,

               

              First check do you have D:\ driver in your database server/system. if yes create folder like

               

              D:\MAXIMODATA\ORADATA\

              and try to restore database again.


              if you don't have D:\ drive then you need to use set newname


              create folder c:\MAXIMODATA\ORADATA\


              set newname for datafile 1 to  c:\MAXIMODATA\ORADATA\system.dbf  ==> you has to set newname for all datafiles.


              Regards,

              Sher