rman-05569: spfile backup not found in

BS Key Type LV Size Device Type Elapsed Time Completion Time The only problem that causes is that the old spfile will have the original control files in it. So in my opinion, it is quite an important thing to consider in our disaster recovery strategy. NAME TYPE VALUE CRS-5017: The resource action ora.vodwstg.db start encountered the following error: What if the file names are completely different, or what if I have to put them on a local file system. We need from TAG20130513T180036 for the datafile, to TAG20130513T185335 for the archivelog backups. ORA-15046: ASM file name +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 is not in single-file creation form. Selecting a range of dates when your group by query is missingdates. VODWSTG_D = ->cp initvodwstg_1.dupback initvodwstg_1.ora that error isnt very helpful. Control File Included: Ckp SCN: 10888351934883 Ckp time: 13-MAY-13 ent.263.812318013 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. RMAN-05574: CONTROLFILE backup not found for database VODWPRD created before to_date(13-MAY-13 06.53.26PM,dd-mon-yy hh:mi:sspm) in +FRA/VODWPRD/BACKUPSET/2013_05_13, RMAN> list backup of controlfile; Veritas does not guarantee the accuracy regarding the completeness of the translation.

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. ->srvctl stop instance -d vodwstg -i vodwstg_1 We're a community of IT professionals committed to sharing knowledge. the Source that is the RMAN Target, the database Im using to make a new database.

Change), You are commenting using your Facebook account. Since we are going to switch back to the RAC init file, that will point us to the correct spfile on ASM anyway. 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. Instance vodwstg_1 is running on node kdb-ch2-a1s *.db_file_name_convert=+DATA/VODWPRD,+DATA/VODWSTG 876 B F A DISK 13-MAY-13 1 1 YES TAG20130513T180036 Our community of experts have been thoroughly vetted for their expertise and industry experience. Will that work. remove: That is there is no connection from the source to the target, and no recovery catalog database. backup the existing init file I have so many names for this. Database dismounted. *.undo_tablespace=UNDOTBS1 (DESCRIPTION = 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. It is possible that updates have been made to the original version after this document was translated and published. Enter password: ********* Lets look the alert log channel ORA_DISK_1: validation complete, elapsed time: 00:06:25 Data Mining and Real Application Testing options Here is one of those points where I ran into issues starting in RAC mode. Now we are able to restore the SPFILE from autobackup! restore controlfile from +DATA/vodwstg/controlfile/current.263.812318013; Find out where your control files and spfile are: NAME TYPE VALUE VODTSTG/ VODWSTG> shutdown immediate Piece Name: +FRA/vodwprd/autobackup/2013_05_13/s_815338305.321.815338305 *.log_file_name_convert=+DATA/VODWPRD,+DATA/VODWSTG,+FRA/VODWPRD,+FRA/VODWSTG (oracle) kdb-ch2-a1s:vodwstg_1:/u01/oracle/11.2.0.3/db/dbs You may also refer to the English Version of this knowledge base article for up-to-date information. RMAN> list backup summary; =============== Fill in your details below or click an icon to log in: You are commenting using your WordPress.com account. So to work around this, we tried to fool RMAN by creating the directory structure when using a FRA. ''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. This is long and Id love to format it nicely for you, but I just dont have the time. total 15657608 3 944 10888351934683 13-MAY-13 10888351935351 13-MAY-13. Enter password: *********

Shutdown single instance Lets see what happens. 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. Rating submitted. SID_LIST_LISTENER = ASMCMD [+] >. Oracle backup fails with "Can not backup SPFILE because the instance was not started with SPFILE", RMAN-00571: ===========================================================. Static entries to listener on source so you can connect in nomount mode Modify that file Let us now revert the autobackup back to the FRA. vodwprd> select scn_to_timestamp(10888351935325) from dual; SCN_TO_TIMESTAMP(10888351935325) shutdown immediate (SERVER = DEDICATED) cp initvodwstg_1.ora initvodwstg_1.dupback To recover from loss of SPFILE if you are NOT using an RMAN Catalog, we need to do two things first : 1) Set the DBID Our experts volunteer their time to help other people in the technology industry learn and succeed. (GLOBAL_DBNAME =vodwstg) In this case, the scenario is the same as the above. 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. Please provide additional feedback (optional): Please note that this document is a translation from English, and may have been machine-translated. ASMCMD-8016: copy source->+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 and target->+FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 failed, huh? Huh? (ORACLE_HOME =/u01/oracle/11.2.0.3/db/) Note the SPFILE autobackup is now located at /u01/backup and we can see the format of the backup file on disk is no longer OMF. Copyright (c) 1982, 2009, Oracle and/or its affiliates. RMAN-05542: Only UNTIL TIME can be used with DUPLICATE without TARGET and CATALOG connections. control_files string +DATA/vodwstg/controlfile/current.331.815409617,

Start the database from an SPFILE in order to backup an SPFILE with RMAN. We can't guarantee quick solutions - Experts Exchange isn't a help desk. JED/ That looks better. My database account keeps getting lockedout! RMAN-03002: failure of Duplicate Db command at 05/13/2013 20:33:54 Let us now specify an actual location on disk instead of just the %F. "/u01/app/oracle/oradata/duporcl/undotbs01.dbf". In the end I discovered it is just a matter of understanding ASM copy. 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). Now we need to put the auxiliary into single instance mode. 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=*; spfile string +DATA/vodwstg/spfilevodwstg.ora This is a typical error we will face when either restoring the SPFILE or control file from an autobackup. Case 2) Autobackup in non-FRA location non OMF, Case 3) Total Disaster Recovery ( restore by specifying the backup file name). alter clone database mount; - - - So now we include the db_file_recovery_dest and db_name parameters in the RESTORE SPFILE command. A new server has been provisioned and all the latest backup files have been restored from tape to a location on disk /u01/backup. VODTPRD/ For details refer to (:CLSN00107:) in /u01/oracle/11.2.0.3/grid/log/kdb-ch2-a2s/agent/crsd/oraagent_oracle/oraagent_oracle.log. RMAN-00571: =========================================================== List of Backups

System altered. Oracle GoldenGate and Oracle 12c Online Training Commencing January 2017, Now an Oracle 12c Certified Master Database Cloud Administrator, Presenting at AUSOUG and AIOUG Conferences in November, RMAN Backup and Recovery scenarios involving loss of SPFILE, Oracle Cloud Marketplace GoldenGate Classic Environment, Oracle GoldenGate on Oracle Cloud Marketplace (Part 3), Oracle GoldenGate on Oracle Cloud Marketplace (Part 2), Data migration to Autonomous Database using MV2ADB, Migrate data in real-time from OCI Classic to OCI using MV2ADB and Oracle Cloud Marketplace GoldenGate, After every BACKUP or CREATE CATALOG command, After every BACKUP command contained in a RUN block, After every structural change to the database occurs like adding a new tablespace, altering the state of a tablespace or datafile (for example, bringing it online), adding a new online redo log, renaming a file. (SERVICE_NAME = vodwstg) using channel ORA_DISK_1 ASMCMD [+] >. But what happens in this case when we try to restore the SPFILE from the location where the backup has been restored.

document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Impact of WHERE clause function(column) use. { That quickly led to many interesting things I had to figure out mainly why does ASM copy not work. This is a simple list of the things you need to do to get through this process. using target database control file instead of recovery catalog RMAN-00571: =========================================================== BACKUPSET UNPROT COARSE MAY 13 19:00:00 Y 8192 1952109 15991676928 15992881152 nnndf0_tag20130513t180036_0.1043.815339727. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed. "/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. Change control_files=+DATA,+FRA then nomount, restore controlfile from ;, and mount, open, alter system set control_files=+DATA,+FRAscope=spfile; RMAN-00571: =========================================================== ->ll /sharedfs/tmp Let us look at some backup and recovery scenarios pertaining to the SPFIILE. To get around having only 1 controlfile at the end, modify control files to multiple file format, e.g. Based on this we can duplicate to SCN 10888351935325 which is the lowest SCN in all logs in this last backup of archivelogs. PRCR-1079 : Failed to start resource ora.vodwstg.db srvctl stop database -d vodwstg - Strangely enough, it is because the target directory isnt there. Hmmm. Piece Name: +FRA/vodwprd/backupset/2013_05_13/annnf0_tag20130513t185335_0.433.815338417, List of Archived Logs in backup set 879 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. So, what is needed to restore/recover?

executing Memory Script Required fields are marked *. You need this in the Target (RMAN Auxiliary) grid listener.ora 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. Instance vodwstg_3 is running on node kdb-ch2-a3s.

exit Yep, couldnt start because it couldnt find the control files. RMAN> catalog backuppiece +FRA/ASM/BACKUPSET/nnndf0_tag20130513t180036_0.1043.815339727; *.instance_number=? should all be in +DATA. In this case this was 2 control file backups prior to the last taken. Lets go all out, and put them on a local filesystem, and change their names. Instance vodwstg_2 is running on node kdb-ch2-a2s 2 kdb-ch2-a2s.sys.comcast.net 14-MAY-13 OPEN ACTIVE, Verify you control files are laid out appropriately ), RMAN> list backup of archivelog all; Piece Name: +FRA/vodwprd/backupset/2013_05_13/nnndf0_tag20130513t180036_0.429.815335237 executing Memory Script. Enter password: ********* So, I copied over all the other files too. Covered by US Patent. Other good stuff. Well, it appears to be there.

Hey, at least it is there. spfile string /u01/oracle/11.2.0.3/db/dbs/spfilevodwstg_1.ora, If we check for this spfile on the file system, we discover it isnt there: This gave me headaches the first time around, and it is one of those places you just want to make sure of things. Create a new init file to modify for single instance Most everyone I asked said it didnt work for them either and they used the filesystem or something else. RMAN-00571: ===========================================================

Essentially thought the initial impetus was doing an RMAN duplication without any connection between the systems. (SID_LIST = *.cluster_database=TRUE RMAN> duplicate database vodwprd to vodwstg until scn 10888351935325 backup location +FRA/VODWPRD/BACKUPSET/2013_05_13; ->cat initvodwstg_1.ora As expected.

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. Your email address will not be published. Errors in file /u01/oracle/grid/diag/asm/+asm/+ASM3/trace/+ASM3_ora_30958.trc: In this document I talk about: Starting Duplicate Db at 13-MAY-13 Alter clone database open resetlogs;

This entry was posted in tankless water heater rebates florida. Bookmark the johan cruyff and luka modric.

rman-05569: spfile backup not found in