----check path----select member from v$logfile;F:\ORACLE\ORADATA\AE02PRD\REDO03A.LOGD:\ORACLE\ORADATA\AE02PRD\REDO03B.LOGF:\ORACLE\ORADATA\AE02PRD\REDO02A.LOGD:\ORACLE\ORADATA\AE02PRD\REDO02B.LOGF:\ORACLE\ORADATA\AE02PRD\REDO01A.LOGD:\ORACLE\ORADATA\AE02PRD\REDO01B.LOGselect file_id,file_name from dba_Data_files;1  D:\ORACLE\ORADATA\AE02PRD\SYSTEM01.DBF2  D:\ORACLE\ORADATA\AE02PRD\SYSAUX01.DBF3  D:\ORACLE\ORADATA\AE02PRD\UNDOTBS01.DBF4  D:\ORACLE\ORADATA\AE02PRD\USERS01.DBF6  F:\ORACLE\ORADATA\AE02PRD\CWMLITE01.DBF5  F:\ORACLE\ORADATA\AE02PRD\TEMP01.DBF9  F:\ORACLE\ORADATA\AE02PRD\PSD_TMP01.DBF8  F:\ORACLE\ORADATA\AE02PRD\DRSYS01.DBF7  F:\ORACLE\ORADATA\AE02PRD\RED04.DBF11  F:\ORACLE\ORADATA\AE02PRD\RED05.DBF10  F:\ORACLE\ORADATA\AE02PRD\EXAMPLE01.DBF13  F:\ORACLE\ORADATA\AE02PRD\INDX01.DBF12  F:\ORACLE\ORADATA\AE02PRD\RED06.DBF14  F:\ORACLE\ORADATA\AE02PRD\ODM01.DBF15  F:\ORACLE\ORADATA\AE02PRD\AUE_AUDIT01.DBF21  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA06.DBF20  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA05.DBF19  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA04.DBF18  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA03.DBF17  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA02.DBF16  F:\ORACLE\ORADATA\AE02PRD\PSD_DATA01.DBF29  F:\ORACLE\ORADATA\AE02PRD\PSD_INDX08.DBF28  F:\ORACLE\ORADATA\AE02PRD\PSD_INDX07.DBF27  F:\ORACLE\ORADATA\AE02PRD\PSD_INDX06.DBF26  F:\ORACLE\ORADATA\AE02PRD\PSD_INDX05.DBF25	F:\ORACLE\ORADATA\AE02PRD\PSD_INDX04.DBF24	F:\ORACLE\ORADATA\AE02PRD\PSD_INDX03.DBF23	F:\ORACLE\ORADATA\AE02PRD\PSD_INDX02.DBF22	F:\ORACLE\ORADATA\AE02PRD\PSD_INDX01.DBF30	F:\ORACLE\ORADATA\AE02PRD\TOOLS01.DBF31	F:\ORACLE\ORADATA\AE02PRD\XDB01.DBF32	F:\ORACLE\ORADATA\AE02PRD\AUDIT_01.DBFselect name from v$controlfile;F:\ORACLE\ORADATA\AE02PRD\CONTROL01.CTLF:\ORACLE\ORADATA\AE02PRD\CONTROL02.CTLF:\ORACLE\ORADATA\AE02PRD\CONTROL03.CTL-------start to refreshC:\Windows\system32>set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256set ORACLE_SID=AE02PRDRMAN TARGET /shutdown immediatestartup nomountRMAN>restore controlfile from 'F:\RMAN_Backup\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAK';Starting restore at 16-OCT-17using channel ORA_DISK_1channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:03output file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL01.CTLoutput file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL02.CTLoutput file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL03.CTLFinished restore at 16-OCT-17RMAN> alter database mount;Statement processedFor record type ARCHIVED LOG RECIDS from 7934 to 27122 are re-used before resyncFor record type BACKUP PIECE RECIDS from 562 to 2220 are re-used before resyncFor record type BACKUP SET RECIDS from 556 to 2790 are re-used before resyncFor record type DELETED OBJECT RECIDS from 7862 to 27223 are re-used before resyncreleased channel: ORA_DISK_1RMAN> catalog start with 'F:\RMAN_Backup\AE02PRD\';RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of catalog command at 10/16/2017 01:02:59RMAN-06189: current DBID 2265703831 does not match target mounted database (2269432018)RMAN>shutdown abort;startup nomount;set dbid=2269432018alter database mount; startup mount;catalog start with 'F:\RMAN_Backup\AE02PRD\';C:\Windows\system32>set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256C:\Windows\system32>rman target /Recovery Manager: Release 12.1.0.2.0 - Production on Mon Oct 16 00:34:32 2017Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.connected to target database: AE02PRD (DBID=2265703831, not open)RMAN> catalog start with 'F:\RMAN_Backup\AE02PRD\';using target database control file instead of recovery catalogsearching for all files that match the pattern F:\RMAN_Backup\AE02PRD\List of Files Unknown to the Database=====================================File Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JHSGR27J_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAKDo you really want to catalog the above files (enter YES or NO)? ycataloging files...no files catalogedList of Files Which Were Not Cataloged=======================================File Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JHSGR27J_1_1.BAK  RMAN-07518: Reason: Foreign database file DBID: 2269432018  Database Name: AE02PRDFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAK  RMAN-07518: Reason: Foreign database file DBID: 2269432018  Database Name: AE02PRDFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAK  RMAN-07518: Reason: Foreign database file DBID: 2269432018  Database Name: AE02PRDFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAK  RMAN-07518: Reason: Foreign database file DBID: 2269432018  Database Name: AE02PRDRMAN> ----------------------------------------------------------------------------------set ORACLE_SID=AE02PRDRMAN TARGET /shutdown abortstartup nomountRMAN> restore controlfile from 'F:\RMAN_Backup\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAK';Starting restore at 16-OCT-17using channel ORA_DISK_1channel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:03output file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL01.CTLoutput file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL02.CTLoutput file name=F:\ORACLE\ORADATA\AE02PRD\CONTROL03.CTLFinished restore at 16-OCT-17RMAN> alter database mount;Statement processedFor record type ARCHIVED LOG RECIDS from 7934 to 27122 are re-used before resyncFor record type BACKUP PIECE RECIDS from 562 to 2220 are re-used before resyncFor record type BACKUP SET RECIDS from 556 to 2790 are re-used before resyncFor record type DELETED OBJECT RECIDS from 7862 to 27223 are re-used before resyncreleased channel: ORA_DISK_1RMAN> catalog start with 'F:\RMAN_Backup\AE02PRD\';RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of catalog command at 10/16/2017 01:02:59RMAN-06189: current DBID 2265703831 does not match target mounted database (2269432018)RMAN> shutdown abortOracle instance shut downRMAN> startup nomountconnected to target database (not started)Oracle instance startedTotal System Global Area    1300234240 bytesFixed Size                     3056376 bytesVariable Size               1119882504 bytesDatabase Buffers             171966464 bytesRedo Buffers                   5328896 bytesRMAN>RMAN> set dbid=2269432018executing command: SET DBIDRMAN> alter database mount;Statement processedRMAN> catalog start with 'F:\RMAN_Backup\AE02PRD\';searching for all files that match the pattern F:\RMAN_Backup\AE02PRD\List of Files Unknown to the Database=====================================File Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JHSGR27J_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAKDo you really want to catalog the above files (enter YES or NO)? yescataloging files...cataloging doneList of Cataloged Files=======================File Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JHSGR27J_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JJSGR3QO_1_1.BAKFile Name: F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAKRMAN>run{   restore database;   switch datafile all;     }   Starting restore at 16-OCT-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=1422 device type=DISKchannel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to D:\ORACLE\ORADATA\AE02PRD\SYSTEM01.DBFchannel ORA_DISK_1: restoring datafile 00002 to D:\ORACLE\ORADATA\AE02PRD\SYSAUX01.DBFchannel ORA_DISK_1: restoring datafile 00003 to D:\ORACLE\ORADATA\AE02PRD\UNDOTBS01.DBFchannel ORA_DISK_1: restoring datafile 00004 to D:\ORACLE\ORADATA\AE02PRD\USERS01.DBFchannel ORA_DISK_1: restoring datafile 00005 to F:\ORACLE\ORADATA\AE02PRD\TEMP01.DBFchannel ORA_DISK_1: restoring datafile 00006 to F:\ORACLE\ORADATA\AE02PRD\CWMLITE01.DBFchannel ORA_DISK_1: restoring datafile 00007 to F:\ORACLE\ORADATA\AE02PRD\RED04.DBFchannel ORA_DISK_1: restoring datafile 00008 to F:\ORACLE\ORADATA\AE02PRD\DRSYS01.DBFchannel ORA_DISK_1: restoring datafile 00009 to F:\ORACLE\ORADATA\AE02PRD\PSD_TMP01.DBFchannel ORA_DISK_1: restoring datafile 00010 to F:\ORACLE\ORADATA\AE02PRD\EXAMPLE01.DBFchannel ORA_DISK_1: restoring datafile 00011 to F:\ORACLE\ORADATA\AE02PRD\RED05.DBFchannel ORA_DISK_1: restoring datafile 00012 to F:\ORACLE\ORADATA\AE02PRD\RED06.DBFchannel ORA_DISK_1: restoring datafile 00013 to F:\ORACLE\ORADATA\AE02PRD\INDX01.DBFchannel ORA_DISK_1: restoring datafile 00014 to F:\ORACLE\ORADATA\AE02PRD\ODM01.DBFchannel ORA_DISK_1: restoring datafile 00015 to F:\ORACLE\ORADATA\AE02PRD\AUE_AUDIT01.DBFchannel ORA_DISK_1: restoring datafile 00016 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA01.DBFchannel ORA_DISK_1: restoring datafile 00017 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA02.DBFchannel ORA_DISK_1: restoring datafile 00018 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA03.DBFchannel ORA_DISK_1: restoring datafile 00019 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA04.DBFchannel ORA_DISK_1: restoring datafile 00020 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA05.DBFchannel ORA_DISK_1: restoring datafile 00021 to F:\ORACLE\ORADATA\AE02PRD\PSD_DATA06.DBFchannel ORA_DISK_1: restoring datafile 00022 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX01.DBFchannel ORA_DISK_1: restoring datafile 00023 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX02.DBFchannel ORA_DISK_1: restoring datafile 00024 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX03.DBFchannel ORA_DISK_1: restoring datafile 00025 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX04.DBFchannel ORA_DISK_1: restoring datafile 00026 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX05.DBFchannel ORA_DISK_1: restoring datafile 00027 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX06.DBFchannel ORA_DISK_1: restoring datafile 00028 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX07.DBFchannel ORA_DISK_1: restoring datafile 00029 to F:\ORACLE\ORADATA\AE02PRD\PSD_INDX08.DBFchannel ORA_DISK_1: restoring datafile 00030 to F:\ORACLE\ORADATA\AE02PRD\TOOLS01.DBFchannel ORA_DISK_1: restoring datafile 00031 to F:\ORACLE\ORADATA\AE02PRD\XDB01.DBFchannel ORA_DISK_1: restoring datafile 00032 to F:\ORACLE\ORADATA\AE02PRD\AUDIT_01.DBFchannel ORA_DISK_1: reading from backup piece F:\RMAN_BKP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAKchannel ORA_DISK_1: errors found reading piece handle=F:\RMAN_BKP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAKchannel ORA_DISK_1: failover to piece handle=F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JISGR27R_1_1.BAK tag=TAG20171012T133907channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:31:18Finished restore at 16-OCT-17      RMAN>recover database;Starting recover at 16-OCT-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 10/16/2017 01:44:33ORA-19698: D:\ORACLE\ORADATA\AE02PRD\REDO01B.LOG is from different database: id=2265703831, db_name=AE02PRDRMAN>RMAN>dropped relative log files, then RMAN> recover database;Starting recover at 16-OCT-17using channel ORA_DISK_1starting media recoverychannel ORA_DISK_1: starting archived log restore to default destinationchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=45835channel ORA_DISK_1: reading from backup piece F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAKchannel ORA_DISK_1: piece handle=F:\RMAN_BACKUP\AE02PRD\AE02PRD_FULL_JKSGR3QU_1_1.BAK tag=TAG20171012T140622channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:03archived log file name=F:\ARCHIVE\AE02PRD\AE02PRD_1_45835_938831065.ARC thread=1 sequence=45835unable to find archived logarchived log thread=1 sequence=45836RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of recover command at 10/16/2017 01:54:09RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 45836 and starting SCN of 8181561702RMAN>recover database until scn 8181561702;RMAN> recover database until scn 8181561702;Starting recover at 16-OCT-17using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:01Finished recover at 16-OCT-17RMAN>select open_mode from v$database; RMAN> alter database open resetlogs;Statement processedRMAN> select open_mode from v$database;OPEN_MODE--------------------READ WRITERMAN> shutdown immediatedatabase closeddatabase dismountedOracle instance shut downRMAN> startupconnected to target database (not started)Oracle instance starteddatabase mounteddatabase openedTotal System Global Area    1300234240 bytesFixed Size                     3056376 bytesVariable Size               1124076808 bytesDatabase Buffers             167772160 bytesRedo Buffers                   5328896 bytesRMAN>C:\Windows\system32>sqlplus psd/UAEPRD823SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 16 02:09:15 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.Last Successful login time: Thu Oct 12 2017 03:02:35 -07:00Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> CONN / AS SYSDBAConnected.SQL> show parameter caseNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------sec_case_sensitive_logon             boolean     TRUESQL> alter system set sec_case_sensitive_logon=FALSE;System altered.SQL> alter system set sec_case_sensitive_logon=FALSE;System altered.SQL> QUITDisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsC:\Windows\system32>sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 16 02:11:17 2017Copyright (c) 1982, 2014, Oracle.  All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL> show parameter caseNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------sec_case_sensitive_logon             boolean     FALSESQL>