1 2 Previous Next 27 Replies Latest reply: Oct 25, 2010 4:43 PM by 808135 Go to original post RSS
      • 15. Re: Problems with cloning database using image copies
        660550
        Going down the duplication route:

        I have my target database open and my auxiliary in nomount:

        I have a password file set on my auxiliary.

        This is what I get when I run on the target server:
        [oracle@abcacct datafile]$ rman target /
        
        Recovery Manager: Release 10.2.0.4.0 - Production on Tue Sep 23 14:52:52 2008
        
        Copyright (c) 1982, 2007, Oracle.  All rights reserved.
        
        connected to target database: DTDB (DBID=737336313)
        
        RMAN> connect auxiliary sys/********@dtdb_dtdbdev
        
        RMAN-00571: ===========================================================
        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
        RMAN-00571: ===========================================================
        RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
        I run RMAN on the auxiliary server and it cannot find the files that reside on the target:
        channel ORA_AUX_DISK_1: restoring datafile 00001
        input datafile copy recid=3228 stamp=665806217 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_system_4280pwz6_.dbf
        destination for restore of datafile 00001: /u02/app/oracle/oradata/dtdbdev/system01.dbf
        channel ORA_AUX_DISK_2: restoring datafile 00002
        input datafile copy recid=3229 stamp=665806288 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_undotbs1_4280lcv0_.dbf
        destination for restore of datafile 00002: /u02/app/oracle/oradata/dtdbdev/undotbs01.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_system_4280pwz6_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_system_4280pwz6_.dbf)
        ORA-19601: output file is datafile 1 (/u02/app/oracle/oradata/dtdbdev/system01.dbf
        channel ORA_AUX_DISK_1: restoring datafile 00003
        input datafile copy recid=3227 stamp=665805928 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_sysaux_4280t6nm_.dbf
        destination for restore of datafile 00003: /u02/app/oracle/oradata/dtdbdev/sysaux01.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_undotbs1_4280lcv0_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_undotbs1_4280lcv0_.dbf)
        ORA-19601: output file is datafile 2 (/u02/app/oracle/oradata/dtdbdev/undotbs01.dbf
        channel ORA_AUX_DISK_2: restoring datafile 00004
        input datafile copy recid=3232 stamp=665806493 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427yqtbq_.dbf
        destination for restore of datafile 00004: /u02/app/oracle/oradata/dtdbdev/users01.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_sysaux_4280t6nm_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_sysaux_4280t6nm_.dbf)
        ORA-19601: output file is datafile 3 (/u02/app/oracle/oradata/dtdbdev/sysaux01.dbf
        channel ORA_AUX_DISK_1: restoring datafile 00005
        input datafile copy recid=3225 stamp=665805640 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_example_4280w7gq_.dbf
        destination for restore of datafile 00005: /u02/app/oracle/oradata/dtdbdev/example01.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427yqtbq_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427yqtbq_.dbf)
        ORA-19601: output file is datafile 4 (/u02/app/oracle/oradata/dtdbdev/users01.dbf
        channel ORA_AUX_DISK_2: restoring datafile 00006
        input datafile copy recid=3231 stamp=665806493 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427xmzxp_.dbf
        destination for restore of datafile 00006: /u02/app/oracle/oradata/dtdbdev/users02.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_example_4280w7gq_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_example_4280w7gq_.dbf)
        ORA-19601: output file is datafile 5 (/u02/app/oracle/oradata/dtdbdev/example01.dbf
        channel ORA_AUX_DISK_1: restoring datafile 00007
        input datafile copy recid=3233 stamp=665806493 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427zvbsl_.dbf
        destination for restore of datafile 00007: /u02/app/oracle/oradata/dtdbdev/users03.dbf
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427xmzxp_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427xmzxp_.dbf)
        ORA-19601: output file is datafile 6 (/u02/app/oracle/oradata/dtdbdev/users02.dbf
        channel ORA_AUX_DISK_2: restoring datafile 00008
        input datafile copy recid=3230 stamp=665806317 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_451twydd_.dbf
        destination for restore of datafile 00008: /u02/app/oracle/oradata/dtdbdev/USERS04
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427zvbsl_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_427zvbsl_.dbf)
        ORA-19601: output file is datafile 7 (/u02/app/oracle/oradata/dtdbdev/users03.dbf
        channel ORA_AUX_DISK_1: restoring datafile 00009
        input datafile copy recid=3226 stamp=665805640 filename=/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_45kp9fxp_.dbf
        destination for restore of datafile 00009: /u02/app/oracle/oradata/dtdbdev/users05
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_451twydd_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_451twydd_.dbf)
        ORA-19601: output file is datafile 8 (/u02/app/oracle/oradata/dtdbdev/USERS04
        ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_45kp9fxp_.dbf"
        ORA-27037: unable to obtain file status
        Linux-x86_64 Error: 2: No such file or directory
        Additional information: 3
        ORA-19600: input file is datafile-copy 0 (/u01/app/oracle/flash_recovery_area/DEVPRIMARY/datafile/o1_mf_users_45kp9fxp_.dbf)
        ORA-19601: output file is datafile 9 (/u02/app/oracle/oradata/dtdbdev/users05
        failover to previous backup
        
        RMAN-00571: ===========================================================
        RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
        RMAN-00571: ===========================================================
        RMAN-03002: failure of Duplicate Db command at 09/23/2008 13:42:39
        RMAN-03015: error occurred in stored script Memory Script
        RMAN-06026: some targets not found - aborting restore
        RMAN-06023: no backup or copy of datafile 9 found to restore
        RMAN-06023: no backup or copy of datafile 8 found to restore
        RMAN-06023: no backup or copy of datafile 7 found to restore
        RMAN-06023: no backup or copy of datafile 6 found to restore
        RMAN-06023: no backup or copy of datafile 5 found to 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
        I need some sort of solution to get this database up and running on a separate server. Please help.

        Sincerely,
        Derek Knutsen
        • 16. Re: Problems with cloning database using image copies
          26741
          You have to make the backups available local to the host where you are duplicating the database to (auxiliary) (or make them available via NFS mount).


          See the "Restrictions and Usage Notes" section of the DUPLICATE documentation.
          http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta028.htm#RCMRF126
          or Task 6
          http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb004.htm#i1006596

          As for the connection to the AUXILIARY, check to see if you've configured a REMOTE_LOGIN_PASSWORDFILE.

          Hemant K Chitale
          http://hemantoracledba.blogspot.com
          • 17. Re: Problems with cloning database using image copies
            660550
            I will look at the links.

            I have setup a remote_login_passwordfile as exclusive on the auxiliary.

            Sincerely,
            Derek Knutsen

            Edited by: Derek Knutsen on Sep 24, 2008 6:14 AM
            • 18. Re: Problems with cloning database using image copies
              F.Munoz Alvarez
              Hi Derek,

              Is the problem solved?

              If not, please take a look on this Metalink Note:

              - Troubleshooting ORA-1031 Insufficient Privilege - Doc ID: Note:730067.1

              Cheers,

              Francisco Munoz Alvarez
              http://www.oraclenz.com
              • 19. Re: Problems with cloning database using image copies
                660550
                Thank you for the links guys.

                I can connect remotely if I have the database open. I cannot connect remotely (including within RMAN) if the database is in nomount, which is required for duplication.

                Sincerely,
                Derek Knutsen
                • 20. Re: Problems with cloning database using image copies
                  F.Munoz Alvarez
                  Hi Derek,

                  For your case follow the instructions in this Metalink Note:

                  - Creating a Duplicate Database on a New Host. - Doc ID: NOTE:388431.1

                  This note show you step by step how to duplicate your DB in a new server.

                  Cheers,

                  Francisco Munoz Alvarez
                  http://www.oraclenz.com
                  • 21. Re: Problems with cloning database using image copies
                    660550
                    Francisco,

                    Thank you for the documentation. I have a question about the backups on the auxiliary instance. We have two instances - 11G (on mount u01) and 10G (on mount point u02) - on the Auxiliary database. On the target the backups are stored in mount point u01. Do I need to put the backups in the u01 mount point on the auxiliary database? Is there a way to point RMAN to the u02 mount point for the backups?

                    Sincerely,
                    Derek Knutsen
                    • 22. Re: Problems with cloning database using image copies
                      660550
                      ARRG!!!!!!!

                      I got so close.

                      Then I ran back into this error:
                      Oracle Error: 
                      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
                      ORA-01194: file 1 needs more recovery to be consistent
                      ORA-01110: data file 1: '/u02/app/oracle/oradata/dtdbdev/system01.dbf'
                      
                      released channel: C1
                      RMAN-00571: ===========================================================
                      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                      RMAN-00571: ===========================================================
                      RMAN-03002: failure of Duplicate Db command at 09/24/2008 13:55:32
                      RMAN-03015: error occurred in stored script Memory Script
                      RMAN-06053: unable to perform media recovery because of missing log
                      RMAN-06025: no backup of log thread 1 seq 34798 lowscn 368367177 found to restore
                      RMAN-06025: no backup of log thread 1 seq 34797 lowscn 368356161 found to restore
                      RMAN-06025: no backup of log thread 1 seq 34796 lowscn 368344411 found to restore
                      RMAN-06025: no backup of log thread 1 seq 34795 lowscn 368342367 found to restore
                      RMAN-06025: no backup of log thread 1 seq 34794 lowscn 368340884 found to restore
                      All the backups / archive logs / etc are in the original directories on my aux box. The previous step (restore) worked fine.

                      I checked and these logs are in the proper directory in the Flash_recovery_area.

                      Here is my duplicate command:
                      RMAN> run {
                      2> set until time "to_date('Sep 19 2008 12:00:00','Mon DD YYYY HH24:MI:SS')";
                      3> allocate auxiliary channel C1 device type disk;
                      4> duplicate target database to DTDBDEV;
                      5> }
                      One step forward 2 back.

                      Sincerely,
                      Derek Knutsen
                      • 23. Re: Problems with cloning database using image copies
                        F.Munoz Alvarez
                        Hi,

                        Try now:

                        recover database using backup controlfile until cancel , and when the message requesting an archive appears, enter the right patch and name and press enter, repeat it until the last archive you have it, then enter cancel.

                        Cheers,

                        Francisco Munoz Alvarez
                        http://www.oraclenz.com
                        • 24. Re: Problems with cloning database using image copies
                          26741
                          Oracle couldn't find the backups of log sequences 34794 to 34798.

                          As you have copied them to the cloning (auxiliary) server, you can CATALOG them. Run the RMAN CATALOG command to "include" them in the controlfile for DTDBDEV so that you can issue the RECOVER DATABASE command.
                          • 25. Re: Problems with cloning database using image copies
                            660550
                            I have succeeded. Here are the steps I used:


                            # Follow the instructions in Metalink: NOTE:388431.1
                            # The backup directory structure should match the source structure
                            # If an archive log is needed and the duplicate process ends: issue: "recover database using backup controlfile until cancel"
                            # In a separate terminal navigate to the archivelog directory and issue: "find 'pwd' | sort" - this will list the files with the paths
                            # copy / paste all the files as a group. Oracle will run through the list.
                            # When the last archive has been sent - type Cancel
                            # Shutdown the database
                            # Startup Migrate
                            # @ORACLE_HOME/rdbms/admin/utlirp.sql
                            # Shutdown / Startup
                            Hemant's suggestion to catalog the archivelogs would probably have eliminated steps 3-6.

                            Sincerely,
                            Derek Knutsen
                            • 26. Re: Problems with cloning database using image copies
                              660550
                              Hement and Francisco,

                              Thank you both for you time and patience. This has been a very vexing issue and I was feeling a lot of heat from my management. Your expertise has been greatly appreciated.

                              Sincerely,
                              Derek Knutsen
                              • 27. Re: Problems with cloning database using image copies
                                808135
                                same problem faced

                                Edited by: 805132 on Oct 25, 2010 2:43 PM

                                Edited by: 805132 on Oct 25, 2010 2:43 PM
                                1 2 Previous Next