-rw-r 1 oracle dba 1112064 May 14 15:59 jed2.bk srvctl stop database -d vodwstg When does the SPFILE gat backed up with AUTOBACKUP now tuned on? RMAN> connect auxiliary sys/********@vodwstg_d channel ORA_AUX_DISK_1: restoring datafile 00001 to +data ORA-15046: ASM file name +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 is not in single-file creation form. total 15657608 the Source that is the RMAN Target, the database Im using to make a new database. *.undo_tablespace=UNDOTBS1 Be careful not to get another database. Save my name, email, and website in this browser for the next time I comment. 1 938 10888351934687 13-MAY-13 10888351935346 13-MAY-13 Our community of experts have been thoroughly vetted for their expertise and industry experience. NAME TYPE VALUE Use the below command to check SPFILE:-In sqlplus run this command:sqlplus> show parameter spfileIf SPFILE is not present, create a SPFILE and re-start the instance using the SPFILE.Note:- If SPFILE does not exist then you can create one as SYS user.To create SPFILE contact DBA.If you're not using an SPFILE there is no need to take backup of SPFILE, modify the script by removing lines that take SPFILE backup. Copy original init file back RMAN> backup database include current controlfile plus archivelog; channel ORA_DISK_1: starting archived log backup set, channel ORA_DISK_1: specifying archived log(s) in backup set, input archived log thread=1 sequence=381 RECID=243 STAMP=771602832, input archived log thread=1 sequence=390 RECID=252 STAMP=771611313, input archived log thread=1 sequence=391 RECID=253 STAMP=772202140, input archived log thread=1 sequence=392 RECID=254 STAMP=772202534, input archived log thread=1 sequence=393 RECID=255 STAMP=772202597, input archived log thread=1 sequence=394 RECID=256 STAMP=772202604, input archived log thread=1 sequence=395 RECID=257 STAMP=772206376, channel ORA_DISK_1: starting piece 1 at 10-JAN-12, channel ORA_DISK_1: finished piece 1 at 10-JAN-12, piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_annnn_TAG20120110T134617_7jrj99mc_.bkp tag=TAG20120110T134617 comment=NONE, channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01, channel ORA_DISK_1: starting full datafile backup set, channel ORA_DISK_1: specifying datafile(s) in backup set, input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf, input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf, input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf, input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf, input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/p1.dbf, input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/p2.dbf, input datafile file number=00008 name=/u01/app/oracle/oradata/orcl/p3.dbf, input datafile file number=00009 name=/u01/app/oracle/oradata/orcl/p4.dbf, input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf, piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_nnndf_TAG20120110T134618_7jrj9c10_.bkp tag=TAG20120110T134618 comment=NONE, channel ORA_DISK_1: backup set complete, elapsed time: 00:01:46, including current control file in backup set, piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_ncnnf_TAG20120110T134618_7jrjdo6y_.bkp tag=TAG20120110T134618 comment=NONE, input archived log thread=1 sequence=396 RECID=258 STAMP=772206486, piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_annnn_TAG20120110T134807_7jrjdqo9_.bkp tag=TAG20120110T134807 comment=NONE, Starting Control File and SPFILE Autobackup at 10-JAN-12, piece handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2012_01_10/o1_mf_s_772206489_7jrjdswk_.bkp comment=NONE, Finished Control File and SPFILE Autobackup at 10-JAN-12, sql statement: alter system switch logfile, Now copy the backup andarchive logsto the same location on the target server, Create the directory structure on the oracle11 server, [oracle@oracle12 2012_01_10]$ ls -ltr /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/*, -rw-r----- 1 oracle dba 59892224 Jan 10 13:46 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_annnn_TAG20120110T134617_7jrj99mc_.bkp, -rw-r----- 1 oracle dba 2613968896 Jan 10 13:47 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_nnndf_TAG20120110T134618_7jrj9c10_.bkp, -rw-r----- 1 oracle dba 10420224 Jan 10 13:48 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_ncnnf_TAG20120110T134618_7jrjdo6y_.bkp, -rw-r----- 1 oracle dba 51712 Jan 10 13:48 /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_annnn_TAG20120110T134807_7jrjdqo9_.bkp, [oracle@oracle12 2012_01_10]$ ls -ltr /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/, -rw-r----- 1 oracle dba 39119872 Jan 10 12:35 o1_mf_1_391_7jrd4vsp_.arc, -rw-r----- 1 oracle dba 34304 Jan 10 12:42 o1_mf_1_392_7jrdk68c_.arc, -rw-r----- 1 oracle dba 13824 Jan 10 12:43 o1_mf_1_393_7jrdm5qh_.arc, -rw-r----- 1 oracle dba 2048 Jan 10 12:43 o1_mf_1_394_7jrdmdjj_.arc, -rw-r----- 1 oracle dba 2841600 Jan 10 13:46 o1_mf_1_395_7jrj97np_.arc, -rw-r----- 1 oracle dba 50176 Jan 10 13:48 o1_mf_1_396_7jrjdpkv_.arc, -rw-r----- 1 oracle dba 112640 Jan 10 13:50 o1_mf_1_397_7jrjjj6t_.arc, -rw-r----- 1 oracle dba 2048 Jan 10 13:50 o1_mf_1_398_7jrjjrvr_.arc, [oracle@oracle12 2012_01_10]$ cd /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/, [oracle@oracle12 2012_01_10]$ tar czf - *.bkp | ssh oracle11 tar xzf - -C /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/, [oracle@oracle12 2012_01_10]$ cd /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/, [oracle@oracle12 2012_01_10]$ tar czf - *.arc | ssh oracle11 tar xzf - -C /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/, [oracle@oracle11 dbs]$ rman auxiliary / catalog rmancat/securestore@rman_catalog, Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jan 10 14:25:11 2012, connected to auxiliary database: DUPORCL (not mounted). ORA-15046: ASM file name +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 is not in single-file creation form. ''Reset to original value by RMAN'' scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; sql statement: alter system set db_name = ''DUPORCL'' comment= ''Reset to original value by RMAN'' scope=spfile, sql statement: alter system reset db_unique_name scope=spfile, sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPORCL" RESETLOGS ARCHIVELOG. vodwstg> show parameter control_files 877 B A A DISK 13-MAY-13 1 1 YES TAG20130513T185136 ->cat initvodwstg_1.ora I really hope in 12c they can make this easier still. *.undo_retention=3600 You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. NAME TYPE VALUE vodwstg_?.__*> lsnrctl reload seems to blow up listener so I stopped and started the listener resource on that node only channel ORA_DISK_1: restored backup piece 1 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== Since we are going to switch back to the RAC init file, that will point us to the correct spfile on ASM anyway. executing Memory Script. ent.263.812318013 [INS-30516] Please specify unique diskgroups. RMAN> list backup summary; ASMCMD [+] >. channel ORA_DISK_1: validation complete, elapsed time: 00:06:25 Our experts volunteer their time to help other people in the technology industry learn and succeed. RMAN> duplicate target database to duporcl; channel ORA_AUX_DISK_1: SID=19 device type=DISK. This is long and Id love to format it nicely for you, but I just dont have the time. In this case the SPFILE (and control file) autobackup is located anywhere you specify, but default location will be %ORACLE_HOME%\Database on Windows and $ORACLE_HOME/dbs on UNIX. ) Remember best practise is to turn the autobackup of the control file to ON (it is OFF by default). Since we know where the backup resides on the target, maybe we should try the duplicate using the BACKUP LOCATION clause. Modify that file channel ORA_AUX_DISK_1: restoring datafile 00018 to +data Instance vodwstg_2 is running on node kdb-ch2-a2s Let us now revert the autobackup back to the FRA. In the end I discovered it is just a matter of understanding ASM copy. (oracle) kdb-ch2-a1s:vodwstg_1:/u01/oracle/11.2.0.3/db/dbs "/u01/app/oracle/oradata/duporcl/p3.dbf", renamed tempfile 1 to /u01/app/oracle/oradata/duporcl/temp01.dbf in control file, datafile copy file name=/u01/app/oracle/oradata/duporcl/sysaux01.dbf RECID=1 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/undotbs01.dbf RECID=2 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/users01.dbf RECID=3 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/example01.dbf RECID=4 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/p2.dbf RECID=5 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/p3.dbf RECID=6 STAMP=772208873, datafile copy file name=/u01/app/oracle/oradata/duporcl/p4.dbf RECID=7 STAMP=772208873, input datafile copy RECID=1 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/sysaux01.dbf, input datafile copy RECID=2 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/undotbs01.dbf, input datafile copy RECID=3 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/users01.dbf, input datafile copy RECID=4 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/example01.dbf, input datafile copy RECID=5 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/p2.dbf, input datafile copy RECID=6 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/p3.dbf, input datafile copy RECID=7 STAMP=772208873 file name=/u01/app/oracle/oradata/duporcl/p4.dbf. ->srvctl start instance -d vodwstg -i vodwstg_1 -o nomount, vodwstg> show parameter spfile You need this in the Target (RMAN Auxiliary) server tnsnames.ora so you can later connect auxiliary: Static entries to listener on source so you can connect in nomount mode As a result, some of the functionality on this website may not work for you. So to work around this, we tried to fool RMAN by creating the directory structure when using a FRA. So, now I wondered. } Well nomount RAC instance 1, (oracle) kdb-ch2-a1s:vodwstg_1:/u01/oracle/11.2.0.3/db/dbs ->srvctl start database -d vodwstg Sign in|Report Abuse|Print Page|Powered By Google Sites, Primary database : orcl (TNS alias : orcl), Duplicating database : duporcl (TNS alias : duporcl), Recovery Catalog database : emrep (TNS alias : emrep,rman_catalog), [oracle@oracle11 admin]$ cat tnsnames.ora, # tnsnames.ora Network Configuration File: /u01/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora. RMAN-00571: =========================================================== "/u01/app/oracle/oradata/duporcl/temp01.dbf"; catalog clone datafilecopy "/u01/app/oracle/oradata/duporcl/sysaux01.dbf". ls: cannot access /u01/oracle/11.2.0.3/db/dbs/spfilevodwstg_1.ora: No such file or directory. (oracle) kdb-ch2-a1s:vodwstg_1:/u01/oracle/11.2.0.3/db/dbs Essentially thought the initial impetus was doing an RMAN duplication without any connection between the systems. (ADDRESS = (PROTOCOL = TCP)(HOST = kdb-ch2-a1s.sys.comcast.net)(PORT = 1521)) Its like crowd-sourced consulting. channel ORA_AUX_DISK_1: starting datafile backup set restore Hello! 13-MAY-13 06.53.26.000000000 PM, RMAN> duplicate database vodwprd to vodwstg until time to_date(13-MAY-13 06.53.26PM,dd-mon-yy hh:mi:sspm) backup location +FRA/VODWPRD/BACKUPSET/2013_05_13; Piece Name: +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 , Using list backup tag=, I should need: "/u01/app/oracle/oradata/duporcl/undotbs01.dbf". "/u01/app/oracle/oradata/duporcl/system01.dbf"; "/u01/app/oracle/oradata/duporcl/sysaux01.dbf"; "/u01/app/oracle/oradata/duporcl/undotbs01.dbf"; "/u01/app/oracle/oradata/duporcl/users01.dbf"; "/u01/app/oracle/oradata/duporcl/example01.dbf"; "/u01/app/oracle/oradata/duporcl/p1.dbf"; "/u01/app/oracle/oradata/duporcl/p2.dbf"; "/u01/app/oracle/oradata/duporcl/p3.dbf"; "/u01/app/oracle/oradata/duporcl/p4.dbf"; channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set, channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/duporcl/system01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/duporcl/sysaux01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/duporcl/undotbs01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/duporcl/users01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/duporcl/example01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/duporcl/p1.dbf, channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/duporcl/p2.dbf, channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/duporcl/p3.dbf, channel ORA_AUX_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/duporcl/p4.dbf, channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_nnndf_TAG20120110T134618_7jrj9c10_.bkp, channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_nnndf_TAG20120110T134618_7jrj9c10_.bkp tag=TAG20120110T134618, channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15, input datafile copy RECID=11 STAMP=772208853 file name=/u01/app/oracle/oradata/duporcl/system01.dbf, input datafile copy RECID=12 STAMP=772208853 file name=/u01/app/oracle/oradata/duporcl/sysaux01.dbf, input datafile copy RECID=13 STAMP=772208853 file name=/u01/app/oracle/oradata/duporcl/undotbs01.dbf, input datafile copy RECID=14 STAMP=772208853 file name=/u01/app/oracle/oradata/duporcl/users01.dbf, input datafile copy RECID=15 STAMP=772208853 file name=/u01/app/oracle/oradata/duporcl/example01.dbf, input datafile copy RECID=16 STAMP=772208854 file name=/u01/app/oracle/oradata/duporcl/p2.dbf, input datafile copy RECID=17 STAMP=772208854 file name=/u01/app/oracle/oradata/duporcl/p3.dbf, input datafile copy RECID=18 STAMP=772208854 file name=/u01/app/oracle/oradata/duporcl/p4.dbf, datafile 6 not processed because file is read-only, archived log for thread 1 with sequence 396 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_396_7jrjdpkv_.arc, archived log for thread 1 with sequence 397 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_397_7jrjjj6t_.arc, archived log for thread 1 with sequence 398 is already on disk as file /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_398_7jrjjrvr_.arc, archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_396_7jrjdpkv_.arc thread=1 sequence=396, archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_397_7jrjjj6t_.arc thread=1 sequence=397, archived log file name=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_01_10/o1_mf_1_398_7jrjjrvr_.arc thread=1 sequence=398, ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below, ORA-01157: cannot identify/lock data file 6 - see DBWR trace file, ORA-01110: data file 6: '/u01/app/oracle/oradata/orcl/p1.dbf', media recovery complete, elapsed time: 00:00:01. ORA-19691: +FRA/asm/backupset/nnndf0_tag20130513t180036_0.1043.815339727 is from different database: id=3140027952, name=VODWPRD. 3 kdb-ch2-a3s.sys.comcast.net 14-MAY-13 OPEN ACTIVE BS Key Size Device Type Elapsed Time Completion Time . We create the directory structure GAVIN/autobackup/2013_06_17 under the to level location /u01/backup and copy the backup pieces to this location. The time we save is the biggest benefit of E-E to our team. *.control_files=+DATA,+FRA, Shutdown RAC database -bash-3.2$ cd /u01/backup ->srvctl stop instance -d vodwstg -i vodwstg_1 sql clone "alter tablespace P1 online"; datafile copy file name=/u01/app/oracle/oradata/duporcl/p1.dbf RECID=8 STAMP=772208888, input datafile copy RECID=8 STAMP=772208888 file name=/u01/app/oracle/oradata/duporcl/p1.dbf, sql statement: alter tablespace P1 online, Duplicate Database from RMAN backup without connecting to Target Database. *.cluster_database=TRUE Other good stuff. Another Note: You only connect as auxiliary as you dont have access to the Source or an RMAN Catalog. I hope I have it all as this was quick and not supposed to be a thorough presentation. Change), You are commenting using your Facebook account. BP Key: 879 Status: AVAILABLE Compressed: YES Tag: TAG20130513T185335 srvctl start instance -d vodwstg -i vodwstg_1 -o nomount In this document I talk about: Now cleanup the datafiles and controlfiles for your database RMAN-05542: Only UNTIL TIME can be used with DUPLICATE without TARGET and CATALOG connections. VODWSTG> show parameter spfile GROUP 1 ( '/u01/app/oracle/oradata/duporcl/redo01.log' ) SIZE 50 M REUSE. Setup listener with hard-coded entry for the target/auxiliary database, Setup tnsnames to for dedicated connection to the target/auxiliary, Copy files from source to target/auxiliary, Prepare the auxiliary (nomount,single instance), RMAN duplicate using until time and backup location. We can't guarantee quick solutions - Experts Exchange isn't a help desk. Huh? If you have the connections it is much simpler, especially when using the slick DUPLICATE TARGET DATABASE FROM ACTIVE DATABASE 2) Issue the STARTUP NOMOUNT FORCE command from an RMAN prompt (note not SQL*PLUS). We noticed that while you have a Veritas Account, you aren't yet registered to manage cases and use chat. ), LISTENER.ORA NAME TYPE VALUE contents of Memory Script: cp initvodwstg_1.ora initvodwstg_1.dupback { the Target that is the RMAN Auxiliary , the database Im creating as a duplicate of the source. ORA-19870: error while restoring backup piece +FRA/asm/backupset/nnndf0_tag20130513t180036_0.1043.815339727 copying +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 -> kdb-ch2-a3s.sys.comcast.net:+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0 SPFILE is automatically backed up along with the database control file when any of the following events occur and when the control file autobackup has been enabled in RMAN. To get around having only 1 controlfile at the end, modify control files to multiple file format, e.g. VODTPRD/ BP Key: 878 Status: AVAILABLE Compressed: NO Tag: TAG20130513T185145 So now we include the db_file_recovery_dest and db_name parameters in the RESTORE SPFILE command. Welcome to our community! "/u01/app/oracle/oradata/duporcl/example01.dbf". channel ORA_DISK_1: piece handle=+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 tag=TAG20130513T180036 srvctl start database -d vodwstg Starting Duplicate Db at 14-MAY-13 We're a community of IT professionals committed to sharing knowledge. NAME TYPE VALUE Of course, if there is something Im doing here and there is an easier way, PLEASE let me know. Notice that they arent the new control files we had after duplicating. Are Cris Collinsworth and Abraham Lincolnrelated? Well, it appears to be there. Were working tech professionals who love collaborating. PRCR-1079 : Failed to start resource ora.vodwstg.db Explaining the Truman Doctrine, Marshall Plan, and NATO to ateenager, My experience on the 10th anniversary of9/11, Why I do have an issue with showing up at Chick-Fil-A in opposition to MarriageRights, Why we chose a charter school (and a localschool), Finding the Oracle session based on a UNIX/Linuxprocess, How to reference a shell variable named by another shellvariable, jdesc.sql A better describe for Oracle (version1), Local (non-RMAN) Backups of your pfile, spfile, and controlfile. VODWSTG/, Now, we should be good to try another duplication after restarting in single mode. JED/ *.undo_management=AUTO . Yep, couldnt start because it couldnt find the control files. contents of Memory Script: pgTAP set_eq on function returning table: ERROR: column % has pseudo-typerecord, RMAN Duplication without a connection | Jed's, a challenge with returning a table and testing withpgTAP. "/u01/app/oracle/oradata/duporcl/p2.dbf". [oracle@oracle12 2012_01_10]$ rman target / catalog rmancat/securestore@rman_catalog, Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jan 10 13:44:19 2012. - - - - channel ORA_AUX_DISK_1: restoring datafile 00002 to +data Of course if you had just specified the target directory you would have had the same result as it implies the full file name. alter system set control_files = +DATA/vodwstg/controlfile/current.331.815409617,+FRA/vodwstg/controlfile/current.310.815409617 scope=spfile sid=*; So, let us change those (if you didnt find out what they were before shutting down the single instance, just look in ASM and find them): vodwstg> alter system set control_files = +DATA/vodwstg/controlfile/current.331.815409617,+FRA/vodwstg/controlfile/current.310.815409617 scope=spfile sid=*; In this case, the scenario is the same as the above. My database account keeps getting lockedout! RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== - RMAN-03002: failure of Duplicate Db command at 05/13/2013 20:28:11 Unless youre really sure you can lose the current Target database (if you had one already), run an RMAN backup of your database before you blow it away. All rights reserved. We can't always guarantee that the perfect solution to your specific problem will be waiting for you. (LogOut/ RMAN> catalog backuppiece +FRA/ASM/BACKUPSET/nnndf0_tag20130513t180036_0.1043.815339727; backup the existing init file Either way it is a good example of some of these issues. connected to target database: ORCL (DBID=1286969050). Mon May 13 19:10:43 2013 The DBID (2968723077) and the timestamp (20130613) is now contained in the backup file name c-2968723077-20130613-01. vodwprd> select scn_to_timestamp(10888351935325) from dual; SCN_TO_TIMESTAMP(10888351935325) This makes sense, but when doing duplicate it can be confusing. -rw-r 1 oracle dba 20825600 May 14 15:58 jed1.bk Strangely enough, it is because the target directory isnt there. restore clone primary controlfile from /sharedfs/tmp/jed4.bk; 878 Full 18.83M DISK 00:00:00 13-MAY-13 srvctl stop database -d vodwstg ASMCMD [+] > cp +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 sys@kdb-ch2-a3s.sys.comcast.net.+ASM3:+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0 Finished restore at 13-MAY-13. (SERVER = DEDICATED) This is a simple list of the things you need to do to get through this process. (LogOut/ ASMCMD [+] > ls -ls +FRA/ASM/BACKUPSET/nnndf0_tag20130513t180036_0.1043.815339727 ''Modified by RMAN duplicate'' scope=spfile"; sql clone "alter system set db_unique_name =, sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile, sql statement: alter system set db_unique_name = ''DUPORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile, channel ORA_AUX_DISK_1: starting datafile backup set restore, channel ORA_AUX_DISK_1: restoring control file, channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2012_01_10/o1_mf_s_772206489_7jrjdswk_.bkp, channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2012_01_10/o1_mf_s_772206489_7jrjdswk_.bkp, ORA-19505: failed to identify file "/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2012_01_10/o1_mf_s_772206489_7jrjdswk_.bkp", Linux-x86_64 Error: 2: No such file or directory, channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_ncnnf_TAG20120110T134618_7jrjdo6y_.bkp, channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_01_10/o1_mf_ncnnf_TAG20120110T134618_7jrjdo6y_.bkp tag=TAG20120110T134618, channel ORA_AUX_DISK_1: restored backup piece 1, channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01, output file name=/u01/app/oracle/oradata/duporcl/control01.ctl, output file name=/u01/app/oracle/oradata/duporcl/control02.ctl. note: Case is important in global_dbname and sid_name It MUST match that of database sid. Add dedicated server entries to DB Home in tnsnames.ora (for DB home on whatever server you plan to connect from) -rw-r 1 oracle dba 19759104 May 14 16:14 jed4.bk. shutdown immediate VODWSTG_D = N nnndf0_tag20130513t180036_0 => +FRA/ASM/BACKUPSET/nnndf0_tag20130513t180036_0.1043.815339727 channel ORA_DISK_1: reading from backup piece +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 The SPFILE has accidently been deleted and now the database is not starting up after a shutdown has been executed. BS Key Type LV Size Device Type Elapsed Time Completion Time Note: Be sure to find one prior to the time (or SCN specified). Create a free website or blog at WordPress.com. Required fields are marked *. 1 kdb-ch2-a1s.sys.comcast.net 14-MAY-13 OPEN ACTIVE RMAN> duplicate database vodwprd to vodwstg until time to_date(13-MAY-13 06.53.26PM,dd-mon-yy hh:mi:sspm) backup location +FRA/VODWPRD/BACKUPSET/2013_05_13; Starting Duplicate Db at 13-MAY-13 +FRA/vodwstg/controlfile/current.1148.813084741. With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, (SERVICE_NAME = vodwstg) RMAN-00571: =========================================================== ASMCMD [+] >. 876 B F A DISK 13-MAY-13 1 1 YES TAG20130513T180036 Errors in file /u01/oracle/grid/diag/asm/+asm/+ASM3/trace/+ASM3_ora_30958.trc: -rw-r 1 oracle dba 15991676928 May 14 16:02 jed3.bk RMAN-00571: =========================================================== So, what is needed to restore/recover? But what happens in this case when we try to restore the SPFILE from the location where the backup has been restored. Auxiliary: Bad interface, bad interface (vSphereUI), Selecting rows when the data does notexist. Piece Name: +FRA/vodwprd/autobackup/2013_05_13/s_815338305.321.815338305 { What if the file names are completely different, or what if I have to put them on a local file system. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Impact of WHERE clause function(column) use. So, I copied over all the other files too. show parameter control_files VODWSTG> shutdown immediate Control File Included: Ckp SCN: 10888351934883 Ckp time: 13-MAY-13 The real trick to this process is realizing that you dont need the backups with the original names, in fact, the name of the files does not matter (as youll see.). Let us now specify an actual location on disk instead of just the %F. The s in the string identifies the OMF as a backup related to the SPFILE. +FRA/vodwstg/controlfile/current.310.815409617 channel ORA_AUX_DISK_1: reading from backup piece /sharedfs/tmp/jed3.bk using target database control file instead of recovery catalog Mon May 13 19:10:43 2013 channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set 1996-2022 Experts Exchange, LLC. Change). Starting Duplicate Db at 13-MAY-13 ORACLE instance shut down. *.thread=? Here is one of those points where I ran into issues starting in RAC mode. . using channel ORA_DISK_1 alter clone database mount; 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed. But what happens if we want to use the AUTOBACKUP command to restore the spfile because many backup files have been restored and we are not sure which backup file contains the SPFILE backup. Come for the solution, stay for everything else. Verify you have UNDO tablespaces for each node (if increasing the number of nodes) d) Complete the database creation. local instance parameters list backup of archivelog all; We just need to modify the BACKUP LOCATION, RMAN> duplicate database vodwprd to vodwstg until time to_date(13-MAY-13 06.53.26PM,dd-mon-yy hh:mi:sspm) backup location /sharedfs/tmp; CRS-5017: The resource action ora.vodwstg.db start encountered the following error: Instance vodwstg_3 is running on node kdb-ch2-a3s. A new server has been provisioned and all the latest backup files have been restored from tape to a location on disk /u01/backup. Piece Name: +FRA/vodwprd/backupset/2013_05_13/annnf0_tag20130513t185136_0.316.815338297 I have so many names for this. So, on the target system create the directories in asmcmd, then try it again: ASMCMD [+] > cp +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 sys@kdb-ch2-a3s.sys.comcast.net.+ASM3:+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0 Starting Duplicate Db at 13-MAY-13 } Verify you have REDO Logs for each node and laid out appropriately copying +FRA/vodwprd/autobackup/2013_05_13/s_815338305.321.815338305 -> kdb-ch2-a3s.sys.comcast.net:+FRA/vodwprd/backupset/2013_05_13/s_815338305 SPFILE=+DATA/vodwstg/spfilevodwstg.ora This post is to assist you in the case you want to duplicate a RAC to another RAC. (SID_LIST = By default, RMAN will send the autobackup to the flash recovery area (if used). =============== remove: RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== So in my opinion, it is quite an important thing to consider in our disaster recovery strategy. In this case this was 2 control file backups prior to the last taken. sql clone create spfile from memory; control_files string +DATA/vodwstg/controlfile/current.327.813084741, Try starting as single instance Based on this we can duplicate to SCN 10888351935325 which is the lowest SCN in all logs in this last backup of archivelogs. executing Memory Script - - - Setup the environment and bring the database in the mount state to prepare for the duplication of the database. Finished Duplicate Db at 13-MAY-13. Your email address will not be published. Copy in single instance pfile Hey, at least it is there. show parameter control_files, Pingback: RMAN Duplication without a connection | Jed's.