RMAN > configure redundancy 2 retention policy; CONFIGURE REDUNDANCY 2 RETENTION STRATEGY; new RMAN configuration settings are stored successfully. channel ch2: SID, restore RMAN restore in the State of the mount in Oracle 11 g DB. 2022 eehelp.com. connected to target database: XE (DBID = 2713545907). I'm trying to restore a controlfile from an earlier date. Copyright (c) 1982, 2009, Oracle and/or its affiliates. DBF, file number of the input data file = 00002 name = / var/oradata/XE/sysaux. On the end DATAGUARD, we take a weekly full backup RMAN. DBF, file number of the input data file = 00003 name = / var/oradata/XE/undotbs1. A few more questions unanswered in my mind.1. Handle: rewh2omanStatus level: BeginnerJoin date: January 9, 2007Messages total: 87Total Questions: 6 (4 pending)Name russ. file number of the input data file = 00002 name = / var/oradata/XE/sysaux. The data files and RMAN backup files resides on the other HDD that are: Now the OS is reloaded, and I installed oracle from scratch: --------------------------------------------------------------------------------, Oracle Database 11 g Express Edition Release 11.2.0.2.0 - 64 bit Production, AMT for Linux: Version 11.2.0.2.0 - production. Oracle SQL to Check the Database / Instance Name to Which the Current Session Is Connected using a Non DBA user, Troubleshoot Fix Resolve Ora-00020: Maximum Number Of Processes (num) Exceeded. What could be in the last update of El Capitan to slow my Mid 2010 GHz Intel Core 2 Duo Macbook Pro 2.66 down so much? | Contact

(5) to restore the data successfully file using the command below: the value of newname for datafile '+ DATA/isldg/datafile/system.298.849413815' to ' / u01/app/oracle/oradata/isldb/system1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/sysaux.295.849413813' to ' / u01/app/oracle/oradata/isldb/sysaux1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/undotbs1.296.849413813' to ' / u01/app/oracle/oradata/isldb/undotbs1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/undotbs2.297.849413815' to ' / u01/app/oracle/oradata/isldb/undotbs2.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/users.299.849413849' to ' / u01/app/oracle/oradata/isldb/users1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/bu_system_tbs.291.849413617' to ' / u01/app/oracle/oradata/isldb/bu_system_tbs1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/bu_his_log_tbs.292.849413617' to ' / u01/app/oracle/oradata/isldb/bu_his_log_tbs1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/bu_index_tbs.293.849413617' to ' / u01/app/oracle/oradata/isldb/bu_index_tbs1.dbf'; the value of newname for datafile '+ DATA/isldg/datafile/bu_image_tbs.294.849413619' to ' / u01/app/oracle/oradata/isldb/bu_image_tbs1.dbf'; the value of newname for tempfile 1 to ' / u01/app/oracle/oradata/isldb/temp1.dbf'; RESTORATION came with success, and all data files store in the folder specified with success. Three methods1 use a tag2 set up to what SNA or something pointing to the RCS of the backup located on disk23 uncatalog all backups located on other drives4 restore a controlfile with only information about the backups on disk2, Chinar does not understand allocate channel only processes of backup destinations.--------Sybrand BakkerSenior Oracle DBA, Why the update did slow my MacBook pro down so, Why the update did slow my MacBook pro down so much? Once I placed th. RMAN restore different localization files. $ls ltr - /orabackup/bkp_030113/controlprod.ctl. Currently, we have RMAN scripts that make incremental backups and weekly/monthly full daily. RMAN > backup backupset device type disk database; channel ORA_DISK_1: SID = 114 type device = DISK, channel ORA_DISK_1: from full data file backup set, channel ORA_DISK_1: specifying datafile (s) in backup set, file number of the input data file = 00001 = / var/oradata/XE/system name. can I adopt this procedure in my scenario. Yes you are right in this case. Catalogue start with "/ u03/app/oracle/fast_recovery_area/MAZ/backupset/2015_05_15"; now, I checked that the backup set it available on SERV2, using the control file of the target instead of recovery catalog database, Time of accomplishment time BS key size Device Type, ------- ---------- ----------- ------------ ---------------, BP key: 190 situation: AVAILABLE Tablet: YES Tag: FIRST, Part name: /u03/app/oracle/fast_recovery_area/MAZ/backupset/2015_05_15/o1_mf_annnn_FIRST_bocjlvfk_.bkp, List of newspapers archived on backup the value 190, The next time that THRD Seq YVERT low low time next YVERT, ---- ------- ---------- --------- ---------- ---------, 1 501 1950316 14 MAY 15 1973213 15 MAY 15, 1 502 1973213 MAY 15, 15 1973254 15 MAY 15, 1 503 1973254 MAY 15, 15 1974268 15 MAY 15, 1 504 1974268 MAY 15, 15 1974295 15 MAY 15, 1 505 1974295 MAY 15, 15 1974321 15 MAY 15, 1 506 1974321 MAY 15, 15 1976213 15 MAY 15, 1 507 1976213 MAY 15, 15 1976251 15 MAY 15, 1 508 1976251 MAY 15, 15 1977715 15 MAY 15, Time of accomplishment BS key Type LV size device Type elapsed time, ------- ---- -- ---------- ----------- ------------ ---------------, BP key: 191 Situation: AVAILABLE Tablet: YES Tag: TAG20150515T105436, Part name: /u03/app/oracle/fast_recovery_area/MAZ/backupset/2015_05_15/o1_mf_nnndf_TAG20150515T105436_bocjlwr0_.bkp, 1977721 full 1 /u02/app/oracle/oradata/maz/system01.dbf 15 May 15, 2 full 1977721 15 May 15 /u02/app/oracle/oradata/maz/sysaux01.dbf, 3 full 1977721 15 May 15 /u02/app/oracle/oradata/maz/undotbs01.dbf, 4 integer 1977721 /u02/app/oracle/oradata/maz/users01.dbf 15 May 15, BP key: 192 situation: AVAILABLE Tablet: YES Tag: FIRST, Part name: /u03/app/oracle/fast_recovery_area/MAZ/backupset/2015_05_15/o1_mf_annnn_FIRST_bocjmzy1_.bkp, List of newspapers archived on backup value 192, 1 509 1977715 MAY 15, 15 1977737 15 MAY 15, at this point if I am running the following then everything works, but I want to restore by using the name of the tag (initially), so I try this, RMAN-00571: ===========================================================. RMAN-06172: no AUTOBACKUP couldn't find or handle specified is not a valid copy or a piece. Suppose one of say users.dbf data files has been removed.

Q3. _____________________________________________________________________________________________________________________, A thousand may fall at your side, ten thousand at your right hand, but it will not come near you. When you restore a database from scratch, you need to know and define the DBID to identify the files required for the restoration, which must also match your target database, which is the database or the instance that you want to restore. 2. can I add a restore point whose name is generated dynamically, for weekly backup, for example: weekly_rest_point_13082013, including therefore the current date? 3 > set up to that time ' TO_DATE (December 14, 2014 19:26:45 ',' dd/mm/yyyy hh24:mi:ss') "; 4 > restore controlfile to ' / tmp/test04.ctl '; channel ch10: sid = 976 devtype = SBT_TAPE, channel ch10: Veritas NetBackup for Oracle - version 7.1 (2011020313), From restoration to February 26, 15 14:41:34, RMAN-03002: failure of the restore command at 26/02/2015 14:41:35, RMAN-06101: no channel to restore a backup or a copy of the control file. All Rights Reserved. This is the one. RMAN would simply apply the recovery logs archived for 14 days to the point of recovery or it would be smart enough to realize, there a backup to restore all first 7 days ago, then apply 7 days recovery logs, to the point of recovery? And make sure you set DBID of production database. There, you have to restore/recovery complete database, because of your database running in NOARCHIVELOG mode. The command line you entered does not work because it is simply wrong. He asked all of the available archives, whenever you give the database recovery, he keeps searching for the next archives, actually these archives are not yet generated, then you can ignore. | Disclaimer, Here the RMAN tag is TAG='TAG20160921T013645', dismounted I use the below taken backup script: allocate channels d1 device type disk format ' / rmanback/isl/$TODAY/df_%U_%T'; allocate channel device type d2 disc format ' / rmanback/isl/$TODAY/df_%U_%T'; backup database effective additional 0 CHECK the LOGIC AS BACKUPSET COMPRESS; backup format ' / rmanback/isl/$TODAY/controlfile.ctlbk' (current controlfile); backup format ' / rmanback/isl/$TODAY/spfile.spbak' (spfile); (2) the transfer of the rman backup complete on a remote server on the same ' / rmanback' file. I read doc available in this regard and google as well. Radiation of the obsolete following backups and copies: -------------------- ------ ------------------ --------------------, Backup piece 1265 3 October 15/var/oracle_fra/XE/backupset /2015_10_03/o1_mf_nnndf_TAG20151003T023003_c0z0zwm9_. (Psalm 91:7), acehints.com Copyright 2011-21 All Rights Reserved Now I want to restore the last backup of the database: I googled and found this article: How do to restore database Oracle using RMAN (with examples) but do not know what is: Question-1: Which means the VALUE XE 1521 in my case? At the time of recovery, it is common that you see these messages. RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =. Please get back with the answer to my query. During restore, RMAN restores the archives at the local site, and finally when the recovery is complete, it deletes the temporarily stored archives. I needed to put the router in Bridge mode to enable NAT in the modem works properly. now copied all the files backup and a copy of the pfile to SERV2. | Site Map E8350 in Bridge mode allow me access to the router with 192.168.1.1, I have a small home network with the E8350 (AC2400) and a PK5001A of Qwest ActionTec modem. Now I want to restore the backup, RMAN COMPLETE the DATAGUARD server to a new server NO - ASM using file system normal For this reason, I have to follow the procedure below: (1) take RMAN full backup of DATAGUARD END as a stage to mount and store it on ' / rmanback' file. Don't you cannot assign the dynamic name in name of the restore point. I think not, is to keep to the required field. RMAN-03002: failure of the restore command at the 13:15:05 15/05/2015, RMAN-06026: some targets not found - abandonment of restoration, RMAN-06023: no backup or copy of the file 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, you are allowed when executing 'backup list', TAG20150515T105436 was one of the existing tag in you database backups (see your message). sql statement: create pfile = "/ u01/app /, channel ORA_DISK_1: specifying datafile (s) in. SERV1 MAZ prod database server's SERV2 developemt server with no database on this subject. Controlfile autobackup format of disc type of the device set to ' / u03/app/oracle/fast_recovery_area/TEST/autobackup/2015_05_15/%F'; Restore spfile from pfile ' / u01/app/oracle/product/11.2.0/dbhome_2/dbs/initmaz.ora' automatic backup; startup nomount pfile=/u01/app/oracle/product/11.2.0/dbhome_2/dbs/initmaz.ora. All rights reserved. Question-2: Lbooking for a restore script, It will be the first time in my career to restore the database. Is there anywhere I can buy one as I looked all over the internet and can find a? file number of the input data file = 00003 name = / var/oradata/XE/undotbs1. (3) hot RMAN copy backup data files, while they are updated, but in order to avoid a block inconsistent read to avoid corruption. also, we have a single instance, DATAGUARD, where production data are replicated. Stop / Drop Scheduled / Running jobs in Oracle, SQL Query to Find Out Oracle Session Details for a Past Time Period from the History tables. All rights reserved. BKP, Log archiving 669 3 October 15/var/oracle_fra/XE/archivelog / 2015_10_03/o1_mf_1_730_ c0z13f0x_.arc, Backup piece 1266 3 October 15/var/oracle_fra/XE/autobackup /2015_10_03/o1_mf_s_892089109_c0z1364t_.bkp, backup piece handle = / var/oracle_fra/XE / backupset/2015_10_03/o1_mf_ nnndf_TAG20151003T023003_ c0z0zwm9_.BKP RECID = 1265 STAMP = 892089004, name = archived log file / var/oracle_fra/XE / ARCHIVELOG/2015_10_03/o1_mf_1_ 730_c0z13f0x_.arc RECID = 669 STAMP = 892089118, backup piece handle = / var/oracle_fra/XE / backup automatic/2015_10_03/o1_mf_s_ 892089109_c0z1364t_.BKP RECID = 1266 STAMP = 892089110, Recovery Manager: release 11.2.0.2.0 - Production on Mon Oct 5 02:32:04 2015, SQL statement: alter system archive log current. If after the last COLD backup is there not get command of newspaper (this means journal seq number is the same), so you can restore your database since the last backup and can retrieve it. Oracle / Product/11.2.0/XE/DBS/ " spfile2init.ora" of spfile "; sql statement: create pfile = "/ u01/app / Oracle / Product/11.2.0/XE/DBS/ spfile2init.ora "of spfile. My db_name is 'isldb '. the same seq # is available since the last log backup. RMAN restore: what is the DBID? There were a few problems with plesk on our server and there is no way except the OS reload. Also if you have incremental backups can run NOARCHIVELOG mode even RETRIEVE the NOREDO of DATABASE then you can open the database. RMAN restore error - recovery of media asking unknown journal: thread 1 seq 7. allocated channel: ch2 released channel: ch2

This isn't a problem. > SQL > restore database until cancel using backup controlfile; Could someone help me please, how can I recover as open my database? He seems to have a different file name format. And I haven't used the command "recover archivelog deletion of database; I used "recover the database. control files intact. I have a question which can be very nave, it is to confirm if the RMAN restore happens in the mount status of data or can it also happen when the DB is in open State? c149qwxk_.BKP tag = TAG20151005T023003 comment = NONE, piece 1265 3 October 15/var/oracle_fra/XE/backupset /, Log archiving 669 3 October 15/var/oracle_fra/XE/archivelog /, piece 1266 3 October 15/var/oracle_fra/XE/autobackup /, c0z0zwm9_.BKP RECID = 1265 STAMP = 892089004, name = archived log file / var/oracle_fra/XE /, 730_c0z13f0x_.arc RECID = 669 STAMP = 892089118, 892089109_c0z1364t_.BKP RECID = 1266 STAMP = 892089110. Everything takes more time in all areas. (6) now when I recover the database, then I found the below error: ORA-01157: cannot identify/lock data file 1 - see DBWR trace file. ORA-01610: recovery using BACKUP CONTROLFILE option must be. At instead step 3 with DATA RESTORE (or RESTORE TABLESPACE USERS) file and step 4 instead with RECOVER DATAFILE (or RECOVER TABLESPACE USERS) and after that you can open the database by using ALTER DATABASE OPEN. You have just enough do to standardize the data files. channel ch1: restore complete, elapsed time: released channel: ch1 If you feel that your questions have been answered, then please provide appropriate points and consider the son of closing. No one can touch _allow_resetlogs_corruption action You are now on your own. RMAN the fact on its own that you mentioned is expected as shown - for backups, restorations of not only this setting. Q2. There, you have to restore/recovery complete database, because of your database running in NOARCHIVELOG mode. The data files are not frozen, as with the hot user managed backup. I was given this laptop for Christmas and noticed that it is not built in a dvd player. How to Find out / Check SGA and PGA size of Oracle Database? I hope my question is clear what is the eligible state of the database in which the RMAN restore can happen. By simply disabling the NAT in the E8350 network broe. channel ch1: restored backup piece. Now to restore the database, I use the following steps.1 rman > shutdown immediate2.RMAN > startup mount3.RMAN > restore database4.RMAN > restore database5.RMAN > alter database open; I'm wrong. Yes you are right in this case. It doesn't matter if the switch is produced or not. The following folders/files are on my slave drive: / Disk1/oracle_fra/XE/ARCHIVELOG/2015_09_29, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_09_30, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_01, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_02, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_03, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_04, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_05, / Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_06, /Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_04/o1_mf_1_731_c11ognk8_.arc, /Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_05/o1_mf_1_732_c149vo3c_.arc, /Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_05/o1_mf_1_733_c15dshcn_.arc, /Disk1/oracle_fra/XE/ARCHIVELOG/2015_10_06/o1_mf_1_734_c18sw1q9_.arc, / Disk1/oracle_fra/XE/Autobackup/2015_09_29, / Disk1/oracle_fra/XE/Autobackup/2015_09_30, / Disk1/oracle_fra/XE/Autobackup/2015_10_01, / Disk1/oracle_fra/XE/Autobackup/2015_10_02, / Disk1/oracle_fra/XE/Autobackup/2015_10_03, / Disk1/oracle_fra/XE/Autobackup/2015_10_04, / Disk1/oracle_fra/XE/Autobackup/2015_10_05, /Disk1/oracle_fra/XE/autobackup/2015_10_04/o1_mf_s_892175488_c11ogk7m_.BKP, /Disk1/oracle_fra/XE/autobackup/2015_10_05/o1_mf_s_892261919_c149vhn0_.BKP, / Disk1/oracle_fra/XE/backupset/2015_09_29, / Disk1/oracle_fra/XE/backupset/2015_09_30, / Disk1/oracle_fra/XE/backupset/2015_10_01, / Disk1/oracle_fra/XE/backupset/2015_10_02, / Disk1/oracle_fra/XE/backupset/2015_10_03, / Disk1/oracle_fra/XE/backupset/2015_10_04, / Disk1/oracle_fra/XE/backupset/2015_10_05, /Disk1/oracle_fra/XE/backupset/2015_10_04/o1_mf_nnndf_TAG20151004T023003_c11ocwg1_.BKP, /Disk1/oracle_fra/XE/backupset/2015_10_05/o1_mf_nnndf_TAG20151005T023003_c149qwxk_.BKP, /Disk1/oracle_fra/XE/onlinelog/o1_mf_1_9d4vrb2o_.log, /Disk1/oracle_fra/XE/onlinelog/o1_mf_2_9d4vrcn4_.log, /Disk1/oracle_fra/XE/onlinelog/o1_mf_3_9d4vrfbh_.log, /Disk1/oracle_fra/XE/onlinelog/o1_mf_4_9d4vrgt3_.log, /Disk1/oracle_fra/XE/onlinelog/o1_mf_6_9d4vr88o_.log. 3. even when logseq is not available when the database is saved, I take the following steps.1 rman > startup nomount;2 rman > restore controlfile autobackup.3.RMAN > change the editing of the database;4 rman > restore database;5 rman > recover noredo db;6 rman > alter database open resetlogs;It is a right. If you must restore controlfile, restoration can be done with the database OPEN or MOUNT, it should be in NOMOUNT State. I'm set the same channel on tape, but the 2nd syntax fails. RMAN > configure controlfile autobackup format clear device type disk; RMAN configuration settings are reset to the default value. Also if you have incremental backups can run NOARCHIVELOG mode even RETRIEVE the NOREDO of DATABASE then you can open the database. How to restore the backup of ago 14 days instead? RMAN > restore controlfile to ' / rmanback/isl/20140810_181405/controlfile.ctlbk'; channel ORA_DISK_1: SID = 332 type device = DISK, channel ORA_DISK_1: restore the control file, channel ORA_DISK_1: restore complete, duration: 00:00:01, output file name=/u01/app/oracle/oradata/isldg/control01.ctl, output file name=/u01/app/oracle/oradata/isldg/control02.ctl. with your actual copies, your should run: restore the database from tag = "TAG20150515T105436"; If you do a new backup with diferent tag the database to archivelog, you will use this new tag (DATABASE_TAG). BTW, FRA is configured?Work around you can try to disable and after successful restoration, again, you can activate FRA. (2) "extra small set of archivelogs" can be enormous if the backup is long-term with many DML during backup. (3) in the new server, I take the scene nomount database using a spfile (spfile has a single entry: 'DB_NAME = isldb').

If you have lost datafile users.dbf it means that this (tablespace) datafie has been automatically disconnected.

10 q. If I restore the database of 14 days but then question. Oracle instance shut down start editing pfile=/u01/app/oracle/product/11.2.0/dbhome_2/dbs/initmaz.ora. do the restore backup command restore controlfile also alongwith datafiles.2 database is running in noarchivelog mode. How can I reinstall Windows Media Center? My Windows Media Center has been accidentally uninstalled were can I go to reinstall it? RMAN restore level 0, 1 incremental level and ARCHIVELOGs, default channel: deletion of Journal archives. connected to target database: ISLDB (unassembled). And if thi does not need perform full restoration/recovery. (4) then I restore the controlfile successfully: Recovery Manager: release 11.2.0.3.0 - Production Wed Aug 20 16:01:21 2014. Restore controlfile to ' / tmp/test03.ctl ' to 'ctrl_uaipq5s3l_s54610_p1_t866316405 '; 2 > allocate channel ch10 device type sbt parms = "ENV = (NB_ORA_CLIENT = myhost)"; ". Please clean the forum! channel ch1: specifying datafile(s), FULL_1rrgas5d_59_1 Control file included: cash SNA: 32882311416 cash time: 14 December 14 19:26:45, allocate channel ch10 device type sbt parms = "ENV = (NB_ORA_CLIENT = myhost)"; ". Q4. All rights reserved. file number of the input data file = 00001 = / var/oradata/XE/system name. 3. even when logseq is not available when the database is saved, I take the following steps.1 rman > startup nomount;2 rman > restore controlfile autobackup.3.RMAN > change the editing of the database;4 rman > restore database;5 rman > recover noredo db;6 rman > alter database open resetlogs;It is a right. You need a sufficiently archivelogs, regardless of the copy backupset or image, to make the data files in compliance. RMAN restore to another device Oracle 11 g 1, If I have two full backups in my FRA (say 7 to 14 days). It will go to the last backup (7 days ago)? If you try to restore automatic backup, useRestore automatic backup controlfile; and the element of particular backup.Restore controlfile to ' / backup_dir/piece_name "; sonidba wrote:Hello worldI have some confusion about rman restore and recover procedures. He has never run it slow before! How to Copy File without Changing Last Modified Date, Time stamp and ownership in Linux / Unix? I noted the dbid and last SNA and then take a backup on SERV1 by using the following command. Can you do an online backup as a copy of the Image instead of a backup set or you can offline backups when you use a copy of the Image? RMAN, DISK Which means the VALUE XE 1521 in my case? Can you check the backup file permissions after you have moved production to the development area? Here is the log for each backup car of the day: Recovery Manager: release 11.2.0.2.0 - Production on Mon Oct 5 02:30:02 2015. Your archivelog was not "missing." But after database restore (step4) you can just issue RESTORE database and can open with RESETLOGS options also. (1) switching is not required for recovery. Published by: rui_catcuddler on October 13, 2010 11:18. RMAN, Steps to Recover Database from RMAN Backup TAG, How to Keep / Pin / Check PLSQL Objects in Buffer Cache / Memory Using DBMS_SHARED_POOL.KEEP. RMAN > configure controlfile autobackup on; RMAN > sql "create pfile =" / u01/app / . channel ch1: piece handle, TAG20160921T013645 My daily script is as below: And the script to backup weekly as below: 1. can I add a "restore point" for the backup script daily, without the clause "keep until the"? I guess that the following be useful: Oracle Database 11g: example of disaster recovery.

How do to restore database Oracle using RMAN (with examples), Oracle Database 11g: example of disaster recovery, BP key: 1463956 status: EXPIRED Tablet: NO Tag: TAG20141214T192638, Handle: ctrl_uaipq5s3l_s54610_p1_t866316405 Media: D05771. DBF, Enter a number of file datafile = name=/var/oradata/XE/users.dbf 00004, channel ORA_DISK_1: starting total, 1-5 October 15, channel ORA_DISK_1: finished piece 1 at 5 October 15, piece handle = / var/oracle_fra/XE / backupset/2015_10_05/o1_mf_ nnndf_TAG20151005T023003_ c149qwxk_.BKP tag = TAG20151005T023003 comment = NONE, Channel ORA_DISK_1: backup complete set, time: 00:01:56, From control file and SPFILE Autobackup 5 October 15, piece handle = / var/oracle_fra/XE / backup automatic/2015_10_05/o1_mf_s_ 892261919_c149vhn0_.BKP comment = NONE, File control finished and Autobackup SPFILE to 5 October 15, RMAN retention policy is set to 2 redundancy. But after database restore (step4) you can just issue RESTORE database and can open with RESETLOGS options also. Copyright (c) 1982, 2011, Oracle and/or its affiliates. Change the status of your backup controlfile AVAILABLE with this command: BACKUP OF CONTROLFILE CHANGE TAG "TAG20141214T192638" AVAILABLE; I'm on the 11.2.0.3 Oracle database. 0.022 s. and/or its affiliates. ORA-01110: data file 1: '+ DATA/isldg/datafile/system.298.849413815 '. In this scenario, the steps above can be used. You can not order from catalogue on the RMAN command line. RMAN, restoration of ASM no - asm environment! WE are running Oracle 11 GR 2 CARS as our PRODUCTION server. can I adopt this procedure in my scenario. Co. Hi guys wonder if you can help me. rewh2oman