rman restore same server different name

RECID=6 STAMP=876675610, datafile copy file name=/data2/prod/dup/tools01.dbf Thu Apr 9 10:47:41 2015. Sorry, but what is so difficult to understand? /backup/rman_backup/db_arch_2rq41rqd_1_1.bkp, channel ORA_AUX_DISK_1: piece handle=/backup/rman_backup/db_arch_2rq41rqd_1_1.bkp All rights reserved. M REUSE, GROUP 3 STAMP=875338210, input archived log thread=1 sequence=96 RECID=92 /data2/app/oracle/product/11.2.0/dbs/snapcf_prod.f; # default, specification does not match any backup in the STAMP=876675584, media recovery complete, elapsed time: 00:00:03. name=/data2/prod/dup/test01.dbf, input datafile copy RECID=16 STAMP=876675577 file Thats why I prefer to drop the database to be sure that all current datafiles are deleted. /data2/prod/dup/sysaux01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00003 to /data2/prod/dup/control02.ctl comment= scope=spfile, sql statement: alter system set db_file_name_convert = /data2/prod, /data2/prod/dup comment= to default destination, channel ORA_AUX_DISK_1: restoring archived log, channel ORA_AUX_DISK_1: reading from backup piece For this to work however, the existing database must not be open and started with only the controlfile mounted, of course. DUP RESETLOGS ARCHIVELOG. alter system reset db_unique_name Applications and Infrastructure Community. 9. RMAN decides what files need to be overwritten and whether it is more efficient to use image copies, full backup, incremental backups or archivelogs, and it will not restore or recover datafiles that do not need to be restored or recovered or have already been restored, etc. b) Drop database (to be sure the space storage used is released), be carefull to do NOT delete the backups. clone datafilecopy STAMP=876399532, input archived log thread=1 sequence=133 RECID=129 /data2/prod/dup/test01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00008 to oracle@172.16.110.16:/backup/rman_backup/, controlfile_c-284539893-20150410-00 I think the question is based on a common misconception, hence the thread subject "same server, same name". clone primary controlfile from initprod.ora It doesn't matter whether you are using the same or a different server. SQL> startup nomount pfile=/data1/oracle11g/product/dbs/initdup.ora; Total System Global Area 1152450560 bytes, Fixed Size 2212696 bytes, Variable Size 352324776 bytes, Database Buffers 788529152 bytes, Redo Buffers STAMP=875398375, input archived log thread=1 sequence=98 RECID=94 Edition Release 11.2.0.1.0 64bit Production, With the Partitioning, OLAP, Data Mining and Real duplicate scope=spfile, Fixed Size 2212696 bytes, channel ORA_AUX_DISK_1: restoring control file, channel ORA_AUX_DISK_1: restore complete, elapsed repository, channel ORA_DISK_1: starting archived log backup set, channel ORA_DISK_1: specifying archived log(s) in /backup/rman_backup/controlfile_c-284539893-20150410-00; sql statement: alter system set db_name = LOG_FILE_NAME_CONVERT =, sql statement: alter system set db_name = STAMP=876567056, input archived log thread=1 sequence=139 RECID=135 db_arch_2qq41rnc_1_1.bkp, -rw-r. STAMP=876018651, input archived log thread=1 sequence=121 RECID=117 STAMP=876094207, input archived log thread=1 sequence=123 RECID=119 name=/data2/prod/data01.dbf, input datafile file number=00004 STAMP=875857844, input archived log thread=1 sequence=116 RECID=112 connected to target database: PROD (DBID=284539893). STAMP=876583581, input archived log thread=1 sequence=141 RECID=137 handle=/backup/rman_backup/controlfile_c-284539893-20150410-00 comment=NONE, Finished Control File and SPFILE Autobackup at STAMP=876308432, input archived log thread=1 sequence=129 RECID=125 time: 00:00:01, Starting Control File and SPFILE Autobackup at 9383936 bytes, Disconnected from Oracle Database 11g Enterprise Issue the following command to duplicate database with different name and different directory structure. name=/data2/prod/sysaux01.dbf, input datafile file number=00005 set, input datafile file number=00001 comment=NONE, channel ORA_DISK_1: backup set complete, elapsed alter system set control_files =, /data2/prod/dup/control01.ctl, clone spfile to /data1/oracle11g/product/dbs/spfiledup.ora /data2/prod/dup;2> 3> 4> 5> 6> 7> 8> 9>, restore DEFAULT OPTIMIZE FOR LOAD TRUE ; # default, CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # REUSE.

Then you 'recover' and level 1 backups and/or archivelogs are used to roll the db forward from that level 0 backup up to your SET UNTIL time. STAMP=876641790, input archived log thread=1 sequence=145 RECID=141 100% 24KB name=/data2/prod/tools01.dbf, piece Correct ? Auxiliary instance should be start with pfile in nomount stage. name=/data2/prod/system01.dbf, input datafile file number=00002 1668MB 11.2MB/s 02:29, db_arch_2rq41rqd_1_1.bkp name=/data2/prod/dup/users01.dbf, input datafile copy RECID=13 STAMP=876675575 file 10-APR-15, piece

STAMP=875960595, input archived log thread=1 sequence=120 RECID=116 name=/data2/prod/dup/example01.dbf, input datafile copy RECID=5 STAMP=876675610 file /data1/oracle11g/product/dbs/spfiledup.ora; channel ORA_AUX_DISK_1: SID=63 device type=DISK, channel ORA_AUX_DISK_1: restoring spfile from Again, the RMAN restore process will automatically restore and overwrite existing database files as required and necessary for the recovery process to be able to apply the archvielogs to recover to the specified time. TO BACKUPSET; # default, CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK No, just to a point in time recovery. STAMP=876583754, input archived log thread=1 sequence=142 RECID=138 STAMP=875287426, input archived log thread=1 sequence=94 RECID=90 oracle@172.16.110.16:/data1/oracle11g/product/dbs/, initprod.ora /backup/rman_backup/db_arch_2sq41rsf_1_1.bkp, channel ORA_AUX_DISK_1: piece handle=/backup/rman_backup/db_arch_2sq41rsf_1_1.bkp tag=TAG20150410T154103 name=/data1/oracle11g/product/dbs/arch1_146_872701561.dbf RECID=1 name=/data2/prod/test01.dbf, input datafile file number=00008 STAMP=875842252, input archived log thread=1 sequence=115 RECID=111 RMAN duplicate scope=spfile; sql clone You cannot restore and recover database XYZ using a backup of XYZ unless the target database is the same and uses the same DBID or control file. STAMP=875225400, input archived log thread=1 sequence=92 RECID=88 Copyright - Netsoftmate IT Solutions Pvt. scope=spfile; sql statement: alter system set db_name = If your backup, archivelog and existing data is sufficient, the following should work: set until time "to_date('16-MAY-2017 00:00:00','DD-MON-YYYY HH24:MI:SS')"; Sometimes in test environments when you add new dafiles after the first restoration process, those datafiles remains in storage devices if I just run the restore process. Ltd. Good Contents Are Everywhere, But Here, We Deliver The Best of The Best.Please Hold on! name=/data2/prod/dup/tools01.dbf, channel ORA_AUX_DISK_1: starting archived log restore ( /data2/prod/dup/redo03.log ) SIZE 50 M a) I think you need to backup database 25th May 17. STAMP=876203937, input archived log thread=1 sequence=126 RECID=122 STAMP=875455916, input archived log thread=1 sequence=100 RECID=96 We are headquartered in India with offices spread across North America, Middle-east and SEA. pfile=/backup/rman_backup/initprod.ora from spfile; [oracle@Nsm-source rman_backup]$ scp backup set, input archived log thread=1 sequence=90 RECID=86 Sqlnet.ora should have correct parameters. db_file_name_convert =, /data2/prod, /data2/prod/dup comment=, sql clone Nothing else was mentioned. CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT /backup/rman_backup/db_arch_%U.bkp; CONFIGURE MAXSETSIZE TO UNLIMITED; # default, CONFIGURE ENCRYPTION FOR DATABASE OFF; # default, CONFIGURE ENCRYPTION ALGORITHM AES128; # default, CONFIGURE COMPRESSION ALGORITHM BASIC AS OF RELEASE Copy rman backup from target to destination server. STAMP=875650222, input archived log thread=1 sequence=107 RECID=103 db_unique_name PROD are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default, CONFIGURE BACKUP OPTIMIZATION OFF; # default, CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default. I was merely answering the OP's question whether it was necessary to drop the database first and the answer is simply: no, it's not necessary.

thread=1 sequence=146, channel clone_default: deleting archived log(s), archived log file GROUP 1 ( /data2/prod/dup/redo01.log ) SIZE 50 alter system set spfile= /data2/prod/dup/control02.ctl comment=, sql clone /backup/rman_backup/. AUTOBACKUP /backup/rman_backup/controlfile_c-284539893-20150410-00, channel ORA_AUX_DISK_1: SPFILE restore from /data2/prod/dup/sysaux01.dbf, renamed tempfile 1 to /data2/prod/dup/temp01.dbf in restore, channel ORA_AUX_DISK_1: specifying datafile(s) to STAMP=875371700, input archived log thread=1 sequence=97 RECID=93 c) Restore spfile, controlfile, database from backup 16th, d) Perform an incomplete database recovery to desired time or SCN.

23.5KB/s 00:00, [oracle@Nsm-linux data2]$ mkdir -p /data2/prod/dup. name=/data2/prod/dup/system01.dbf, input datafile copy RECID=10 STAMP=876675572 file name=/data2/prod/dup/sysaux01.dbf, input datafile copy RECID=11 STAMP=876675573 file To be on the safe side, somehow, I'll do like this: - shutdown immediate - this if the database is up and running, - rename the datafile folder, get a copy of spfile and controlfile to a safe location, - create the old folder for the datafiles, - restore controlfile from the desired backup. time: 00:01:05, input archived log thread=1 sequence=146 RECID=142 alter system set tag=TAG20150410T153820 comment=NONE, channel ORA_DISK_1: backup set complete, elapsed STAMP=875489442, input archived log thread=1 sequence=101 RECID=97 /data2/prod, 100% RECID=2 STAMP=876675609, datafile copy file name=/data2/prod/dup/users01.dbf We will not be getting error like 'DATAFILE already exists or any". STAMP=875771364, input archived log thread=1 sequence=112 RECID=108 restore from backup set, channel ORA_AUX_DISK_1: restoring datafile 00001 to /data2/prod/dup/system01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00002 to AUTOBACKUP complete, sql statement: alter system set spfile= STAMP=875809288, input archived log thread=1 sequence=114 RECID=110 RECID=4 STAMP=876675609, datafile copy file name=/data2/prod/dup/data01.dbf scope=spfile, connected to auxiliary database (not started), Total System Global Area 1152450560 bytes, Fixed Size 2212696 bytes, Variable Size 318770344 bytes, Database Buffers 822083584 bytes, Redo Buffers 9383936 bytes. Because the first step (rman restore) restores (completely overwrites) the data files from the last level 0 backup PRIOR TO your "until" time. name=/data2/prod/dup/test01.dbf, input datafile copy RECID=7 STAMP=876675611 file 1169 1.1KB/s 00:00. prior to start scp/ftp to destination server create directory structure to accommodate Rman backup on destination server.

[oracle@Nsm-source rman_backup]$ ls -lrth, -rw-r.

[oracle@Nsm-linux dbs]$ export ORACLE_SID=dup, SQL*Plus: Release 11.2.0.1.0 Production on Fri Apr 10 /data2/prod/dup/data01.dbf, channel ORA_AUX_DISK_1: restoring datafile 00007 to SQL> create STAMP=876288622, input archived log thread=1 sequence=128 RECID=124 STAMP=875883160, input archived log thread=1 sequence=117 RECID=113 Set Oracle sid on which backup will perform. DUP 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 catalog STAMP=876504610, input archived log thread=1 sequence=137 RECID=133 Today is 25th May '17 and I want to restore the data till 16th may only. from. If you want to restore a database using a different name, hence creating a new database, you use RMAN duplicate. 100% affiliates. STAMP=876586722, input archived log thread=1 sequence=143 RECID=139 RECID=1 STAMP=876675609, datafile copy file name=/data2/prod/dup/undotbs01.dbf original value by RMAN scope=spfile; sql clone /backup/rman_backup/controlfile_c-284539893-20150410-00; sql clone DISK TO 1; # default. controlfile_c-284539893-20150410-00, [oracle@Nsm-source rman_backup]$ scp * Modified by

STAMP=875804400, input archived log thread=1 sequence=113 RECID=109 STAMP=875955632, input archived log thread=1 sequence=119 RECID=115 name=/data2/prod/dup/data01.dbf, input datafile copy RECID=15 STAMP=876675576 file

Compare & Book

Cheap Flights, Trains, Buses and more