D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 9 17:12:43 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 8.2678E+10 bytes
Fixed Size 7774968 bytes
Variable Size 1.2885E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 260657152 bytes
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
D:\>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Jun 9 17:14:26 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN> restore controlfile from 'D:\rman_backup_smrprodb\control_63_SMRPRODB_20190609_cf_D-SMRPRODB_id-3201394995_bqu3lhl7.bak';
Starting restore at 09-JUN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
channel ORA_DISK_1: copied control file copy
output file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\CONTROL01.CTL
output file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\CONTROL02.CTL
Finished restore at 09-JUN-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> catalog start with 'D:\rman_backup_smrprodb\';
Starting implicit crosscheck backup at 09-JUN-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=430 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=456 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=469 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=482 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=495 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=508 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=521 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=534 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=547 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=560 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=573 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=586 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=599 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=612 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=625 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=638 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=651 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=664 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=677 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=690 device type=DISK
Crosschecked 28 objects
Finished implicit crosscheck backup at 09-JUN-19
Starting implicit crosscheck copy at 09-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished implicit crosscheck copy at 09-JUN-19
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_13_GBGGMS1R_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_14_GBGGMS83_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_15_GBGGN5CL_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_05\O1_MF_1_16_GBGNCNB6_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_10_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_11_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_12_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_13_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_14_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_15_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_16_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_17_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_18_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_19_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_1_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_20_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_21_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_22_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_23_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_24_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_25_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_26_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_27_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_28_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_29_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_2_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_3_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_4_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_5_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_6_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_7_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_8_1005460847.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\1_9_1005460847.ARC
searching for all files that match the pattern D:\rman_backup_smrprodb\
List of Files Unknown to the Database
=====================================
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B0U3KRVL_8544_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B1U3KRVL_8545_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B2U3KRVL_8546_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B3U3KRVM_8547_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B4U3KRVP_8548_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BBU3KS00_8555_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BEU3LHKP_8558_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BFU3LHKP_8559_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BGU3LHKP_8560_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BHU3LHKP_8561_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BIU3LHKS_8562_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190609_CF_D-SMRPRODB_ID-3201394995_BQU3LHL7.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B5U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B6U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B7U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B8U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BAU3KRVR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BNU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BOU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BDU3KS02_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BRU3LHL8_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T8U20MM0_8104_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T9U20MM1_8105_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TAU20MM1_8106_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TBU20MM1_8107_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TCU20MMI_8108_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\CONTROL_63_SMRPRODB_20190520_CF_D-SMRPRODB_ID-3201394995_TIU20MNQ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TDU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TEU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TFU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TGU20MMM_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_THU20MMT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\STANDBYCONTROL_SMRPRODB_20190520_TJU20MNR_1_1.CTL
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B0U3KRVL_8544_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B1U3KRVL_8545_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B2U3KRVL_8546_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B3U3KRVM_8547_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_B4U3KRVP_8548_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BBU3KS00_8555_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BEU3LHKP_8558_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BFU3LHKP_8559_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BGU3LHKP_8560_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BHU3LHKP_8561_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BIU3LHKS_8562_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190609_CF_D-SMRPRODB_ID-3201394995_BQU3LHL7.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B5U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B6U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B7U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_B8U3KRVQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BAU3KRVR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BNU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BOU3LHKU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BDU3KS02_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190609_BRU3LHL8_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T8U20MM0_8104_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_T9U20MM1_8105_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TAU20MM1_8106_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TBU20MM1_8107_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\BACKUP_SMRPRODB_DB_TCU20MMI_8108_1_20190520
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\CONTROL_63_SMRPRODB_20190520_CF_D-SMRPRODB_ID-3201394995_TIU20MNQ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TDU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TEU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TFU20MML_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_TGU20MMM_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\SMRPRODB_THU20MMT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\WINDOW_RMAN\STANDBYCONTROL_SMRPRODB_20190520_TJU20MNR_1_1.CTL
List of Files Which Were Not Cataloged
=======================================
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
RMAN> RUN
2> {
3> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
4> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
5> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
6> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
7> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
8> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
9> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
10> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
11> RESTORE DATABASE;
12> SWITCH DATAFILE ALL;
13> SWITCH TEMPFILE ALL;
14> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 09-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to D:\app\plmadmin\oradata\smrprodb\indx01.dbf
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to D:\app\plmadmin\oradata\smrprodb\system01.dbf
channel ORA_DISK_2: restoring datafile 00005 to D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
channel ORA_DISK_2: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
channel ORA_DISK_3: restoring datafile 00007 to D:\app\plmadmin\oradata\smrprodb\idata02.dbf
channel ORA_DISK_3: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP
channel ORA_DISK_4: starting datafile backup set restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_DISK_4: restoring datafile 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_4: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BMU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_DISK_2: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BKU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:45
channel ORA_DISK_3: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BLU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:45
channel ORA_DISK_4: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_BJU3LHKT_1_1.BCKP tag=TAG20190609T101453
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:15
Finished restore at 09-JUN-19
datafile 1 switched to datafile copy
input datafile copy RECID=594 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=595 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=596 STAMP=1010510407 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=597 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=598 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=599 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=600 STAMP=1010510408 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
RMAN>
RMAN>
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''
RMAN> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log''
RMAN>
RMAN>
RMAN>
RMAN>
RMAN> recover database noredo;
Starting recover at 09-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
Finished recover at 09-JUN-19
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 06/09/2019 17:21:49
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF'
RMAN> recover database;
Starting recover at 09-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
using channel ORA_DISK_7
using channel ORA_DISK_8
using channel ORA_DISK_9
using channel ORA_DISK_10
using channel ORA_DISK_11
using channel ORA_DISK_12
using channel ORA_DISK_13
using channel ORA_DISK_14
using channel ORA_DISK_15
using channel ORA_DISK_16
using channel ORA_DISK_17
using channel ORA_DISK_18
using channel ORA_DISK_19
using channel ORA_DISK_20
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=3776
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_BPU3LHL5_8569_1_20190609 tag=TAG20190609T101501
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000003776_1008055157.0001 thread=1 sequence=3776
unable to find archived log
archived log thread=1 sequence=3777
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/09/2019 17:22:06
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 3777 and starting SCN of 469371778
RMAN> alter database open resetlogs;
Statement processed
RMAN>
No comments:
Post a Comment