Hi All we are performing rman full backup restoration on window machine. As i have faced issue as while performing restoration using inconsistent backup using rman we can not recover using archivelog for media recovery process on window machine case. As per oracle docs media recovery is not possible in cross platform case.
Redo application is not supported between Linux and Windows except with a standby database.
C:\Users\plmadmin>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 23 11:38:07 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.3422E+10 bytes
Database Buffers 6.8988E+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
C:\Users\plmadmin>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 23 11:39:28 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN>
RMAN> restore controlfile from 'D:\rman_backup_smrprodb\control_63_SMRPRODB_20190723_cf_D-SMRPRODB_id-3201394995_geu7c65j.bak';
Starting restore at 23-JUL-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 23-JUL-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u04/MasterDB/oradata/SMRPRODB/redo01a.log
/u04/MasterDB/oradata/SMRPRODB/redo02a.log
/u04/MasterDB/oradata/SMRPRODB/redo03a.log
/u04/MasterDB/oradata/SMRPRODB/redo04.log
/u04/MasterDB/oradata/SMRPRODB/redo_05.log
/u04/MasterDB/oradata/SMRPRODB/redo_06.log
/u04/MasterDB/oradata/SMRPRODB/redo_07.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log
13 rows selected
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/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> 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>
RMAN>
RMAN>
RMAN>
RMAN> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG
13 rows selected
RMAN> catalog start with 'D:\rman_backup_smrprodb\';
Starting implicit crosscheck backup at 23-JUL-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 33 objects
Finished implicit crosscheck backup at 23-JUL-19
Starting implicit crosscheck copy at 23-JUL-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
Crosschecked 2 objects
Finished implicit crosscheck copy at 23-JUL-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\28_APRIL_2019\ARCHIVE_LOG\ARC0000004601_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004733_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004752_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004833_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004834_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004835_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004836_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004838_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004839_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004842_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004843_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004854_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004885_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004898_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004919_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004951_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004981_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004984_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005007_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005031_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005039_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005062_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005069_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005083_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005095_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G2U7C64V_9730_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G3U7C64V_9731_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G4U7C64V_9732_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G5U7C64V_9733_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G6U7C650_9734_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190723_CF_D-SMRPRODB_ID-3201394995_GEU7C65J.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G8U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GBU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GCU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190723_GFU7C65K_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\28_APRIL_2019\ARCHIVE_LOG\ARC0000004601_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004733_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004752_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004833_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004834_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004835_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004836_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004838_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004839_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004842_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004843_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004854_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004885_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004898_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004919_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004951_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004981_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004984_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005007_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005031_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005039_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005062_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005069_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005083_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005095_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G2U7C64V_9730_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G3U7C64V_9731_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G4U7C64V_9732_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G5U7C64V_9733_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G6U7C650_9734_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190723_CF_D-SMRPRODB_ID-3201394995_GEU7C65J.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G8U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GBU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GCU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190723_GFU7C65K_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> set newname for tempfile 2 to "D:\app\plmadmin\oradata\smrprodb\temp02.dbf";
12> RESTORE DATABASE;
13> SWITCH DATAFILE ALL;
14> SWITCH TEMPFILE ALL;
15> }
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
executing command: SET NEWNAME
Starting restore at 23-JUL-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_GAU7C652_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_G8U7C652_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_G9U7C652_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_G7U7C651_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP tag=TAG20190723T100833
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_G8U7C652_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:46
channel ORA_DISK_3: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:46
channel ORA_DISK_4: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:16
Finished restore at 23-JUL-19
datafile 1 switched to datafile copy
input datafile copy RECID=653 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=654 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=655 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=656 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=657 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=658 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=659 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
renamed tempfile 2 to D:\app\plmadmin\oradata\smrprodb\temp02.dbf in control file
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 07/23/2019 11:47:55
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 23-JUL-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=5139
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723 tag=TAG20190723T100850
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\ARC0000005139_1010514318.0001 thread=1 sequence=5139
unable to find archived log
archived log thread=1 sequence=5140
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/23/2019 11:48:12
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 5140 and starting SCN of 507051307
RMAN> alter database open resetlogs;
Statement processed
RMAN> select name,open_mode,databse_role from v$database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 07/23/2019 11:49:32
ORA-00904: "DATABSE_ROLE": invalid identifier
RMAN> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
RMAN>
Redo application is not supported between Linux and Windows except with a standby database.
C:\Users\plmadmin>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jul 23 11:38:07 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.3422E+10 bytes
Database Buffers 6.8988E+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
C:\Users\plmadmin>rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jul 23 11:39:28 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN>
RMAN> restore controlfile from 'D:\rman_backup_smrprodb\control_63_SMRPRODB_20190723_cf_D-SMRPRODB_id-3201394995_geu7c65j.bak';
Starting restore at 23-JUL-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 23-JUL-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u04/MasterDB/oradata/SMRPRODB/redo01a.log
/u04/MasterDB/oradata/SMRPRODB/redo02a.log
/u04/MasterDB/oradata/SMRPRODB/redo03a.log
/u04/MasterDB/oradata/SMRPRODB/redo04.log
/u04/MasterDB/oradata/SMRPRODB/redo_05.log
/u04/MasterDB/oradata/SMRPRODB/redo_06.log
/u04/MasterDB/oradata/SMRPRODB/redo_07.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo01b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo01c.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo02b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo02c.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo03b.log
/u04/MasterDB/oradata/SMRPRODB/redo/redo03c.log
13 rows selected
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/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> 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>
RMAN>
RMAN>
RMAN>
RMAN> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03A.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO04.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_05.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_06.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO_07.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO01C.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO02C.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03B.LOG
D:\APP\PLMADMIN\ORADATA\SMRPRODB\REDO03C.LOG
13 rows selected
RMAN> catalog start with 'D:\rman_backup_smrprodb\';
Starting implicit crosscheck backup at 23-JUL-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 33 objects
Finished implicit crosscheck backup at 23-JUL-19
Starting implicit crosscheck copy at 23-JUL-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
Crosschecked 2 objects
Finished implicit crosscheck copy at 23-JUL-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\28_APRIL_2019\ARCHIVE_LOG\ARC0000004601_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004733_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004752_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004833_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004834_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004835_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004836_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004838_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004839_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004842_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004843_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004854_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004885_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004898_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004919_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004951_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004981_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004984_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005007_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005031_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005039_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005062_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005069_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005083_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005095_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G2U7C64V_9730_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G3U7C64V_9731_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G4U7C64V_9732_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G5U7C64V_9733_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G6U7C650_9734_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190723_CF_D-SMRPRODB_ID-3201394995_GEU7C65J.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G8U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GBU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GCU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190723_GFU7C65K_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\28_APRIL_2019\ARCHIVE_LOG\ARC0000004601_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004733_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004752_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004833_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004834_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004835_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004836_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004838_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004839_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004842_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004843_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004854_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004885_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004898_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004919_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004951_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004981_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000004984_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005007_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005031_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005039_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005062_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005069_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005083_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\28_APRIL_2019\ARCHIVE_LOG\ARC0000005095_1010514318.0001
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G2U7C64V_9730_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G3U7C64V_9731_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G4U7C64V_9732_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G5U7C64V_9733_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_G6U7C650_9734_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190723_CF_D-SMRPRODB_ID-3201394995_GEU7C65J.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G8U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GBU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GCU7C653_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190723_GFU7C65K_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> set newname for tempfile 2 to "D:\app\plmadmin\oradata\smrprodb\temp02.dbf";
12> RESTORE DATABASE;
13> SWITCH DATAFILE ALL;
14> SWITCH TEMPFILE ALL;
15> }
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
executing command: SET NEWNAME
Starting restore at 23-JUL-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_GAU7C652_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_G8U7C652_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_G9U7C652_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_G7U7C651_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_GAU7C652_1_1.BCKP tag=TAG20190723T100833
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_G8U7C652_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:46
channel ORA_DISK_3: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G9U7C652_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:46
channel ORA_DISK_4: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_G7U7C651_1_1.BCKP tag=TAG20190723T100833
channel ORA_DISK_4: restored backup piece 1
channel ORA_DISK_4: restore complete, elapsed time: 00:01:16
Finished restore at 23-JUL-19
datafile 1 switched to datafile copy
input datafile copy RECID=653 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=654 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=655 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=656 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=657 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\ILOG01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=658 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\INDX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=659 STAMP=1014378450 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA02.DBF
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
renamed tempfile 2 to D:\app\plmadmin\oradata\smrprodb\temp02.dbf in control file
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 07/23/2019 11:47:55
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 23-JUL-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=5139
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDU7C65I_9741_1_20190723 tag=TAG20190723T100850
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\ARC0000005139_1010514318.0001 thread=1 sequence=5139
unable to find archived log
archived log thread=1 sequence=5140
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/23/2019 11:48:12
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 5140 and starting SCN of 507051307
RMAN> alter database open resetlogs;
Statement processed
RMAN> select name,open_mode,databse_role from v$database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 07/23/2019 11:49:32
ORA-00904: "DATABSE_ROLE": invalid identifier
RMAN> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB READ WRITE PRIMARY
RMAN>
No comments:
Post a Comment