set pagesize 200 linesize 200
select 'set newname for datafile ' || a.FILE# || ' to "' || a.NAME || '";' from v$datafile a;
select 'set newname for tempfile ' || a.FILE# || ' to "' || a.NAME || '";' from v$tempfile a;
SELECT 'SQL "ALTER DATABASE RENAME FILE ''''' || a.MEMBER || ''''' to ''''' || a.MEMBER || ''''' ";' FROM v$logfile a;
D:\>startup nomount;
'startup' is not recognized as an internal or external command,
operable program or batch file.
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 15 10:21:02 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> restore controlfile from 'D:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
SP2-0734: unknown command beginning "restore co..." - rest of line ignored.
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:\>set ORACLE_SID=smrprodb
D:\>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Apr 15 10:25:16 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:\oracle12c_dump\rman_backup_63_test\control_63_SMRPRODB_20190415_cf_D-SMRPRODB_id-3201394995_kbtv1rhg.bak';
Starting restore at 15-APR-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 15-APR-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> catalog start with 'D:\oracle12c_dump\rman_backup_63_test\';
Starting implicit crosscheck backup at 15-APR-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 23 objects
Finished implicit crosscheck backup at 15-APR-19
Starting implicit crosscheck copy at 15-APR-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 15-APR-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\O1_MF_1_15_GC8GLZ05_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_16_GC8GM7T2_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_17_GC8GMF8J_.ARC
File Name: D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8GQGD7_.ARC
searching for all files that match the pattern D:\oracle12c_dump\rman_backup_63_test\
List of Files Unknown to the Database
=====================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_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:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
List of Files Which Were Not Cataloged
=======================================
File Name: D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\RMAN_SMRPRODB_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
RMAN> RUN
2> {
3> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo01a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01a.log'' ";
4> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log'' ";
5> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo03a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03a.log'' ";
6> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log'' ";
7> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_05.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_05.log'' ";
8> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log'' ";
9> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo_07.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_07.log'' ";
10> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log'' ";
11> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01c.log'' ";
12> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log'' ";
13> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02c.log'' ";
14> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log'' ";
15> SQL "ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log'' ";
16> set newname for datafile 1 to "D:\app\plmadmin\oradata\smrprodb\system01.dbf";
17> set newname for datafile 2 to "D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf";
18> set newname for datafile 3 to "D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf";
19> set newname for datafile 4 to "D:\app\plmadmin\oradata\smrprodb\idata01.dbf";
20> set newname for datafile 5 to "D:\app\plmadmin\oradata\smrprodb\ilog01.dbf";
21> set newname for datafile 6 to "D:\app\plmadmin\oradata\smrprodb\indx01.dbf";
22> set newname for datafile 7 to "D:\app\plmadmin\oradata\smrprodb\idata02.dbf";
23> set newname for tempfile 1 to "D:\app\plmadmin\oradata\smrprodb\temp01.dbf";
24> RESTORE DATABASE;
25>
26> SWITCH DATAFILE ALL;
27>
28> SWITCH TEMPFILE ALL;
29>
30> RECOVER DATABASE;
31>
32> }
sql statement: 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/redo02a.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02a.log''
sql statement: 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/redo04.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo04.log''
sql statement: 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_06.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo_06.log''
sql statement: 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/redo01b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo01b.log''
sql statement: 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/redo02b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo02b.log''
sql statement: 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/redo03b.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03b.log''
sql statement: ALTER DATABASE RENAME FILE ''/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log'' to ''D:\app\plmadmin\oradata\smrprodb\redo03c.log''
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 15-APR-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:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_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:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_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:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_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:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K7TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:55
channel ORA_DISK_3: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K6TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:55
channel ORA_DISK_2: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K5TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:05
channel ORA_DISK_4: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\SMRPRODB_K4TV1RGU_1_1.BCKP tag=TAG20190415T095542
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:26
Finished restore at 15-APR-19
datafile 1 switched to datafile copy
input datafile copy RECID=547 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=548 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=549 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=550 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=551 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=552 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=553 STAMP=1005656034 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
Starting recover at 15-APR-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=18
channel ORA_DISK_1: reading from backup piece D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
channel ORA_DISK_1: piece handle=D:\ORACLE12C_DUMP\RMAN_BACKUP_63_TEST\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415 tag=TAG20190415T095559
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC thread=1 sequence=18
channel default: deleting archived log(s)
archived log file name=D:\APP\PLMADMIN\FAST_RECOVERY_AREA\SMRPRODB\ARCHIVELOG\2019_04_15\O1_MF_1_18_GC8RP4G7_.ARC RECID=4736 STAMP=1005656036
unable to find archived log
archived log thread=1 sequence=19
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/15/2019 12:53:57
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 19 and starting SCN of 410913463
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE until cancel;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input
RMAN> RECOVER DATABASE noredo;
Starting recover at 15-APR-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 15-APR-19
RMAN>