3 Replies Latest reply: Nov 13, 2013 3:09 AM by CKPT RSS

    Error in creating Standby database

    $phinx19

      OS:AIX

      DB:10.2.0.4

       

      Hi ALL,

      I am facing a problem when I am trying to create a standby database. I am stuck when I am trying to restore the database. Following are the steps that I am following at a high level

       

      1. Edited the pfile on both the databases correctly

      2. Took the database backup from the primary using rman

      >backup database plus archivelog;

      3. backed up the controlfile as standby controlfile

      >backup current controlfile for standby format '/path';

      4.transfered the database backup and also passwordfile, initfile.

      5.mounted the standby database instance using the newly edited file.

      6.restored the controlfile from backup and mounted the database

      >alter database mount standby database;

      7.catalog start with '/path';

       

      8. But when I am doing the restore database command I am facing the following error

       

       

      RMAN> restore database;

       

      Starting restore at 09-NOV-13

      using channel ORA_DISK_1

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of restore command at 11/09/2013 17:47:57

      RMAN-06026: some targets not found - aborting restore

      RMAN-06023: no backup or copy of datafile 4 found to restore

      RMAN-06023: no backup or copy of datafile 3 found to restore

      RMAN-06023: no backup or copy of datafile 2 found to restore

      RMAN-06023: no backup or copy of datafile 1 found to restore

      Kindly suggest

      I am aware the there are other ways of doing this like duplicate database and all.

       

      Regards,

      Sphinx