2 Replies Latest reply: Dec 10, 2012 8:53 AM by 838209 RSS

    Creating Standby database in OEM 10g

    838209
      DB = Oracle 10.2.0.4
      OS = Solaris 10 Sparc

      I am trying to create a physical standby database using the add standby database option within OEM 10g. This is something we have done numerous times before on 10g and 11g db's without a single issue, but for some reason, this time after selecting my RMAN backup location and staging area location , I am getting the following error when I click Next:

      RMAN Backup Location - The specified RMAN backup is invalid. Could not identify controlfile from the backup

      It is the latest backup (using RMAN catalog) from the previous evening and includes datafiles and control file.
      Here is the output for List backup:

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      1741586 7.70G DISK 00:03:26 06-DEC-12
      BP Key: 1741590 Status: AVAILABLE Compressed: NO Tag: TAG20121206T220033
      Piece Name: /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4811_1.bus

      List of Archived Logs in backup set 1741586
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 20013 7974703107 04-DEC-12 7974865046 04-DEC-12
      1 20014 7974865046 04-DEC-12 7975209322 05-DEC-12
      1 20015 7975209322 05-DEC-12 7975792781 05-DEC-12
      1 20016 7975792781 05-DEC-12 7975841363 05-DEC-12
      1 20017 7975841363 05-DEC-12 7976016507 05-DEC-12
      1 20018 7976016507 05-DEC-12 7976577946 06-DEC-12
      1 20019 7976577946 06-DEC-12 7976685352 06-DEC-12
      1 20020 7976685352 06-DEC-12 7976816259 06-DEC-12
      1 20021 7976816259 06-DEC-12 7976884597 06-DEC-12
      1 20022 7976884597 06-DEC-12 7977236969 06-DEC-12
      1 20023 7977236969 06-DEC-12 7978009499 06-DEC-12
      1 20024 7978009499 06-DEC-12 7978784609 06-DEC-12
      1 20025 7978784609 06-DEC-12 7979558556 06-DEC-12
      1 20026 7979558556 06-DEC-12 7980614921 06-DEC-12
      1 20027 7980614921 06-DEC-12 7981238045 06-DEC-12
      1 20028 7981238045 06-DEC-12 7981890156 06-DEC-12
      1 20029 7981890156 06-DEC-12 7982119933 06-DEC-12
      1 20030 7982119933 06-DEC-12 7982775834 06-DEC-12
      1 20031 7982775834 06-DEC-12 7983388279 06-DEC-12

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      1741587 Full 214.09G DISK 01:15:15 06-DEC-12
      List of Datafiles in backup set 1741587
      File LV Type Ckp SCN Ckp Time Name
      ---- -- ---- ---------- --------- ----
      1 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/system01.dbf
      2 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/undotbs01.dbf
      3 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/sysaux01.dbf
      4 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_indexes01.dbf
      5 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_indexes02.dbf
      6 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_indexes03.dbf
      7 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_tables01.dbf
      8 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_tables02.dbf
      9 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/large_tables03.dbf
      10 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_tables01.dbf
      11 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_tables02.dbf
      12 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_tables03.dbf
      13 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_tables04.dbf
      14 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/medium_tables01.dbf
      15 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/medium_tables02.dbf
      16 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/medium_tables03.dbf
      17 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_indexes01.dbf
      18 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/medium_indexes01.dbf
      19 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/tools01.dbf
      20 Full 7983402310 06-DEC-12 /oracle/oradata/care/carelive/data/small_indexes02.dbf

      Backup Set Copy #1 of backup set 1741587
      Device Type Elapsed Time Completion Time Compressed Tag
      ----------- ------------ --------------- ---------- ---
      DISK 01:15:15 06-DEC-12 NO TAG20121206T220415

      List of Backup Pieces for backup set 1741587 Copy #1
      BP Key Pc# Status Piece Name
      ------- --- ----------- ----------
      1741591 1 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_1.bus
      1741592 2 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_2.bus
      1741593 3 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_3.bus
      1741594 4 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_4.bus
      1741595 5 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_5.bus
      1741596 6 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_6.bus
      1741597 7 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_7.bus
      1741598 8 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_8.bus
      1741599 9 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_9.bus
      1741600 10 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_10.bus
      1741601 11 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_11.bus
      1741602 12 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_12.bus
      1741603 13 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_13.bus
      1741604 14 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_14.bus
      1741605 15 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_15.bus
      1741606 16 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_16.bus
      1741607 17 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_17.bus
      1741608 18 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_18.bus
      1741609 19 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_19.bus
      1741610 20 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_20.bus
      1741611 21 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_21.bus
      1741612 22 AVAILABLE /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4812_22.bus

      BS Key Size Device Type Elapsed Time Completion Time
      ------- ---------- ----------- ------------ ---------------
      1741658 104.19M DISK 00:00:04 06-DEC-12
      BP Key: 1741679 Status: AVAILABLE Compressed: NO Tag: TAG20121206T231939
      Piece Name: /carebackup/oradata/CARELIVE/carelive/backup/df_CARELIVE_4813_1.bus

      List of Archived Logs in backup set 1741658
      Thrd Seq Low SCN Low Time Next SCN Next Time
      ---- ------- ---------- --------- ---------- ---------
      1 20032 7983388279 06-DEC-12 7983637536 06-DEC-12

      BS Key Type LV Size Device Type Elapsed Time Completion Time
      ------- ---- -- ---------- ----------- ------------ ---------------
      1741702 Full 7.33M DISK 00:00:02 06-DEC-12
      BP Key: 1741704 Status: AVAILABLE Compressed: NO Tag: TAG20121206T231950
      Piece Name: /carebackup/oradata/CARELIVE/carelive/backup/ctlc-3640364239-20121206-00
      Control File Included: Ckp SCN: 7983638867 Ckp time: 06-DEC-12
      SPFILE Included: Modification time: 06-DEC-12


      The only difference between creating a standby for this db and others we have created is that the file system the backups are stored on is on a non-global zone shared via nfs mount.
      I know that when I try and share that filesystem with other servers I get the message:
      share_nfs: Cannot share filesystems in non-global zones
      If the /backup filesystem is not shared with any other servers would OEM be able to read from that NGZ? The filesystem is available to connect to using ssh from other locations, but not sure how OEM handles this part of the process.
      Any advice would be great.

      Regards,
      JP
        • 1. Re: Creating Standby database in OEM 10g
          Osama_Mustafa
          Check the below link
          http://docs.oracle.com/cd/B14117_01/server.101/b10822/gui.htm
          • 2. Re: Creating Standby database in OEM 10g
            838209
            Thanks for the reply and the useful link. I had followed the instructions when creating the standby database, although under database options there is a difference between the OEM version we are using and the version shown, whereby the 'RMAN backup location' option has been replaced with 'working directory location'.

            Just found the following and am guessing this is the issue.
            NFS mounts established within a zone are local to that zone. The mounts cannot be accessed from other zones, including the global zone.

            I suspect I will need to copy the backup pieces onto the local server in order to create the standby database using OEM. Not something I was expecting to have to do as copying will take a long time due to the size of the backup, but unless anyone else can shed any light on the reason for the initial error
            RMAN Backup Location - The specified RMAN backup is invalid. Could not identify controlfile from the backup
            then I guess this is the only way forward.

            Regards,
            JP