 |  |
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Windows\system32>D:
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:12:08 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
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:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:14:17 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 Tue Apr 16 13:16:49 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN> restore standby controlfile from 'D:\rman_backup_smrprodb\standbycontrol_SMRPRODB_20190416_latv3rcd_1_1.ctl';
Starting restore at 16-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: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 16-APR-19
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> alter dataabse mount standby database;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:19:15
ORA-00940: invalid ALTER command
RMAN> shutdown immediate;
database dismounted
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 13:20:06 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 Tue Apr 16 13:22:25 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: SMRPRODB (not mounted)
RMAN> restore standby controlfile from 'D:\rman_backup_smrprodb\standbycontrol_SMRPRODB_20190416_latv3rcd_1_1.ctl';
Starting restore at 16-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: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 16-APR-19
RMAN> sql 'alter database mount standby database';
sql statement: alter database mount standby database
released channel: ORA_DISK_1
RMAN> catalog start with 'D:\rman_backup_smrprodb';
Starting implicit crosscheck backup at 16-APR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=482 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=508 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=521 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=534 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=547 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=560 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=573 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=586 device type=DISK
allocated channel: ORA_DISK_9
channel ORA_DISK_9: SID=599 device type=DISK
allocated channel: ORA_DISK_10
channel ORA_DISK_10: SID=612 device type=DISK
allocated channel: ORA_DISK_11
channel ORA_DISK_11: SID=625 device type=DISK
allocated channel: ORA_DISK_12
channel ORA_DISK_12: SID=638 device type=DISK
allocated channel: ORA_DISK_13
channel ORA_DISK_13: SID=651 device type=DISK
allocated channel: ORA_DISK_14
channel ORA_DISK_14: SID=664 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=677 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=690 device type=DISK
allocated channel: ORA_DISK_17
channel ORA_DISK_17: SID=703 device type=DISK
allocated channel: ORA_DISK_18
channel ORA_DISK_18: SID=716 device type=DISK
allocated channel: ORA_DISK_19
channel ORA_DISK_19: SID=729 device type=DISK
allocated channel: ORA_DISK_20
channel ORA_DISK_20: SID=742 device type=DISK
Crosschecked 28 objects
Finished implicit crosscheck backup at 16-APR-19
Starting implicit crosscheck copy at 16-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
Crosschecked 2 objects
Finished implicit crosscheck copy at 16-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\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_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_01TRRD87_7169_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_02TRRD87_7170_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_03TRRD8B_7171_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ATRRD8U_7178_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0DTRTIA2_7181_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ETRTIA2_7182_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0FTRTIA2_7183_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0GTRTIA2_7184_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0HTRTIA5_7185_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ITRTIA5_7186_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0PTRTIAP_7193_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0STRVVL6_7196_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0TTRVVL6_7197_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0UTRVVL6_7198_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0VTRVVL6_7199_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_10TRVVL9_7200_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_17TRVVLV_7207_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ATS2K16_7210_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1BTS2K16_7211_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1CTS2K16_7212_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1DTS2K16_7213_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ETS2K19_7214_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1FTS2K1C_7215_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1MTS2K22_7222_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDTUN01V_7693_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GKTUN02J_7700_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GNTUPKD6_7703_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GRTUPKDV_7707_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H2TUPKEJ_7714_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H5TUQJNQ_7717_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H7TUQJNQ_7719_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H8TUQJNQ_7720_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H9TUQJNT_7721_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HATUQJNT_7722_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HHTUQJOI_7729_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HKTUS5RN_7732_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HLTUS5RN_7733_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HMTUS5RN_7734_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HNTUS5RN_7735_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HOTUS5RO_7736_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HVTUS5SE_7743_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I2TUS7IQ_7746_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I3TUS7IQ_7747_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I4TUS7IQ_7748_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I5TUS7IQ_7749_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I6TUS7IT_7750_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I7TUS7IT_7751_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IETUS7JF_7758_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IHTUS8P0_7761_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IITUS8P0_7762_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IJTUS8P0_7763_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IKTUS8P0_7764_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ILTUS8P3_7765_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IMTUS8P3_7766_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ITTUS8PM_7773_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J0TUUT50_7776_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J1TUUT50_7777_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J2TUUT50_7778_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J3TUUT50_7779_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J4TUUT57_7780_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J5TUUT57_7781_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JCTUUT5P_7788_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KFTV2EO4_7823_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KITV2EO8_7826_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KPTV2EOK_7833_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KSTV3RBH_7836_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KTTV3RBH_7837_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KUTV3RBH_7838_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KVTV3RBH_7839_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L0TV3RBO_7840_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L1TV3RBO_7841_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L8TV3RCB_7848_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ULTRNO6Q_7125_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_USTRNO7C_7132_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UTTRNO7C_7133_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UUTRNO7C_7134_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UVTRNO7C_7135_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V0TRNO7C_7136_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V7TRO9JE_7143_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VETRO9KI_7150_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VLTRQTV9_7157_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VSTRQU0B_7164_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VVTRRD87_7167_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190412_CF_D-SMRPRODB_ID-3201394995_HITUQJOJ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_I0TUS5SF.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IFTUS7JG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IUTUS8PN.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190414_CF_D-SMRPRODB_ID-3201394995_JDTUUT5Q.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190416_CF_D-SMRPRODB_ID-3201394995_L9TV3RCC.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\RMAN_SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRIDE_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRMINDDEV_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_04TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_05TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_06TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_07TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_09TRRD8E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0JTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0KTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0LTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0MTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0NTRTIA7_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0OTRTIA8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_11TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_12TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_13TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_14TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_15TRVVLD_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_16TRVVLF_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1GTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1HTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1ITS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1JTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1KTS2K1F_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1LTS2K1I_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HBTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HCTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HDTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HETUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HGTUQJO1_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HPTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HQTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HRTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HSTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HTTUS5RT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HUTUS5RU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I8TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I9TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IATUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IBTUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ICTUS7IV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IDTUS7J0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_INTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IOTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IPTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IQTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IRTUS8P5_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ISTUS8P6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J6TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J7TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J8TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J9TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JATUUT59_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JBTUUT5A_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KJTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KKTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KLTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KMTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KOTV2EOC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L3TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L4TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L5TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L6TV3RBQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L7TV3RBR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRTESTENV_FULL.LOG
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190308_0RTRTIAR_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190309_19TRVVM1_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190310_1OTS2K24_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_I1TUS5SH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IGTUS7JH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IVTUS8PO_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190414_JETUUT5S_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KRTV2EOM_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190416_LATV3RCD_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_01TRRD87_7169_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_02TRRD87_7170_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_03TRRD8B_7171_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ATRRD8U_7178_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0DTRTIA2_7181_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ETRTIA2_7182_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0FTRTIA2_7183_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0GTRTIA2_7184_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0HTRTIA5_7185_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0ITRTIA5_7186_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0PTRTIAP_7193_1_20190308
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0STRVVL6_7196_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0TTRVVL6_7197_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0UTRVVL6_7198_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_0VTRVVL6_7199_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_10TRVVL9_7200_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_17TRVVLV_7207_1_20190309
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ATS2K16_7210_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1BTS2K16_7211_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1CTS2K16_7212_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1DTS2K16_7213_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1ETS2K19_7214_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1FTS2K1C_7215_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_1MTS2K22_7222_1_20190310
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GDTUN01V_7693_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GKTUN02J_7700_1_20190411
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GNTUPKD6_7703_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_GRTUPKDV_7707_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H2TUPKEJ_7714_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H5TUQJNQ_7717_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H7TUQJNQ_7719_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H8TUQJNQ_7720_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_H9TUQJNT_7721_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HATUQJNT_7722_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HHTUQJOI_7729_1_20190412
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HKTUS5RN_7732_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HLTUS5RN_7733_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HMTUS5RN_7734_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HNTUS5RN_7735_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HOTUS5RO_7736_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_HVTUS5SE_7743_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I2TUS7IQ_7746_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I3TUS7IQ_7747_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I4TUS7IQ_7748_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I5TUS7IQ_7749_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I6TUS7IT_7750_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_I7TUS7IT_7751_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IETUS7JF_7758_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IHTUS8P0_7761_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IITUS8P0_7762_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IJTUS8P0_7763_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IKTUS8P0_7764_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ILTUS8P3_7765_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_IMTUS8P3_7766_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ITTUS8PM_7773_1_20190413
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J0TUUT50_7776_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J1TUUT50_7777_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J2TUUT50_7778_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J3TUUT50_7779_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J4TUUT57_7780_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_J5TUUT57_7781_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JCTUUT5P_7788_1_20190414
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JFTV1HH0_7791_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JGTV1HH0_7792_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JHTV1HH0_7793_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JITV1HH0_7794_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JJTV1HH7_7795_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JKTV1HH7_7796_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JRTV1HHQ_7803_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JUTV1RGP_7806_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_JVTV1RGP_7807_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K0TV1RGP_7808_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K1TV1RGP_7809_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K2TV1RGS_7810_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_K3TV1RGT_7811_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KATV1RHF_7818_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KFTV2EO4_7823_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KITV2EO8_7826_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KPTV2EOK_7833_1_20190415
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KSTV3RBH_7836_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KTTV3RBH_7837_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KUTV3RBH_7838_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_KVTV3RBH_7839_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L0TV3RBO_7840_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L1TV3RBO_7841_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_L8TV3RCB_7848_1_20190416
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_ULTRNO6Q_7125_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_USTRNO7C_7132_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UTTRNO7C_7133_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UUTRNO7C_7134_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_UVTRNO7C_7135_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V0TRNO7C_7136_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_V7TRO9JE_7143_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VETRO9KI_7150_1_20190306
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VLTRQTV9_7157_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VSTRQU0B_7164_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\BACKUP_SMRPRODB_DB_VVTRRD87_7167_1_20190307
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190412_CF_D-SMRPRODB_ID-3201394995_HITUQJOJ.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_I0TUS5SF.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IFTUS7JG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190413_CF_D-SMRPRODB_ID-3201394995_IUTUS8PN.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190414_CF_D-SMRPRODB_ID-3201394995_JDTUUT5Q.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_JSTV1HHR.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190415_CF_D-SMRPRODB_ID-3201394995_KBTV1RHG.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\CONTROL_63_SMRPRODB_20190416_CF_D-SMRPRODB_ID-3201394995_L9TV3RCC.BAK
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_04TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_05TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_06TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_07TRRD8C_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_09TRRD8E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0JTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0KTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0LTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0MTRTIA6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0NTRTIA7_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_0OTRTIA8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_11TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_12TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_13TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_14TRVVLC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_15TRVVLD_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_16TRVVLF_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1GTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1HTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1ITS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1JTS2K1E_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1KTS2K1F_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_1LTS2K1I_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HBTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HCTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HDTUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HETUQJNV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HGTUQJO1_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HPTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HQTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HRTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HSTUS5RR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HTTUS5RT_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_HUTUS5RU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I8TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_I9TUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IATUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IBTUS7IU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ICTUS7IV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IDTUS7J0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_INTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IOTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IPTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IQTUS8P4_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_IRTUS8P5_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_ISTUS8P6_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J6TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J7TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J8TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_J9TUUT58_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JATUUT59_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JBTUUT5A_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JLTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JMTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JNTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JOTV1HH8_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JPTV1HHA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_JQTV1HHB_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K4TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K5TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K6TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K7TV1RGU_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K8TV1RGV_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_K9TV1RH0_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KJTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KKTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KLTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KMTV2EOA_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_KOTV2EOC_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L3TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L4TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L5TV3RBP_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L6TV3RBQ_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L7TV3RBR_1_1.BCKP
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190308_0RTRTIAR_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190309_19TRVVM1_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190310_1OTS2K24_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_I1TUS5SH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IGTUS7JH_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190413_IVTUS8PO_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190414_JETUUT5S_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_JTTV1HHS_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KCTV1RHI_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190415_KRTV2EOM_1_1.CTL
File Name: D:\RMAN_BACKUP_SMRPRODB\STANDBYCONTROL_SMRPRODB_20190416_LATV3RCD_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
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRIDE_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRMINDDEV_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
File Name: D:\RMAN_BACKUP_SMRPRODB\SMRTESTENV_FULL.LOG
RMAN-07517: Reason: The file header is corrupted
RMAN>
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>
13> SWITCH DATAFILE ALL;
14>
15> SWITCH TEMPFILE ALL;
16> }
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 16-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
skipping datafile 1; already restored to file D:\app\plmadmin\oradata\smrprodb\system01.dbf
skipping datafile 5; already restored to file D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
skipping datafile 2; already restored to file D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
skipping datafile 7; already restored to file D:\app\plmadmin\oradata\smrprodb\idata02.dbf
skipping datafile 3; already restored to file D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
skipping datafile 6; already restored to file D:\app\plmadmin\oradata\smrprodb\indx01.dbf
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 00004 to D:\app\plmadmin\oradata\smrprodb\idata01.dbf
channel ORA_DISK_1: reading from backup piece D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP
channel ORA_DISK_1: piece handle=D:\RMAN_BACKUP_SMRPRODB\SMRPRODB_L2TV3RBP_1_1.BCKP tag=TAG20190416T040513
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 16-APR-19
datafile 1 switched to datafile copy
input datafile copy RECID=556 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=557 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=558 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=559 STAMP=1005744399 file name=D:\APP\PLMADMIN\ORADATA\SMRPRODB\IDATA01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=560 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\ilog01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=561 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\indx01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=562 STAMP=1005744399 file name=D:\app\plmadmin\oradata\smrprodb\idata02.dbf
renamed tempfile 1 to D:\app\plmadmin\oradata\smrprodb\temp01.dbf in control file
RMAN> select process,status,sequence# from v$managed_standby;
PROCESS STATUS SEQUENCE#
--------- ------------ ----------
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
ARCH CONNECTED 0
RMAN> select max(sequence#) from v$archvied_log;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:27:29
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
RMAN> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
27
RMAN> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
--------- -------------------- ----------------
SMRPRODB MOUNTED PHYSICAL STANDBY
RMAN> select member from v$logfile
2> ;
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
2> ;
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> select member from v$logfile
2> ;
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> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_28_1005460847.arc';
Statement processed
RMAN> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_29_1005460847.arc';
Statement processed
RMAN> select member from v$logfile
2> select member from v$logfile
3> select member from v$logfile
4>
5>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signaled during parse
RMAN-00600: internal error, arguments [2016] [4] [] [] []
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> select max(sequence#) from v$archvived_log;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 13:47:34
ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
RMAN> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
29
RMAN> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
29
RMAN> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
29
RMAN> select sequence#,archived,applied from v$archived_log;
SEQUENCE# ARC APPLIED
---------- --- ---------
10 YES YES
11 YES YES
12 YES YES
13 YES YES
14 YES YES
15 YES YES
16 YES YES
17 YES YES
18 YES YES
19 YES YES
1 YES YES
20 YES YES
21 YES YES
22 YES YES
23 YES YES
24 YES YES
25 YES YES
26 YES YES
27 YES YES
2 YES YES
3 YES YES
4 YES YES
5 YES YES
6 YES YES
7 YES YES
8 YES YES
9 YES YES
28 YES NO
29 YES NO
29 rows selected
RMAN> alter database register logfile 'D:\app\plmadmin\fast_recovery_area\smrprodb\ARCHIVELOG\2019_04_15\1_29_1005460847.arc';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 04/16/2019 14:05:15
ORA-16089: archive log has already been registered
RMAN> alter database recover managed standby database disconnect from session;
Statement processed
RMAN> select sequence#,archived,applied from v$archived_log;
SEQUENCE# ARC APPLIED
---------- --- ---------
10 YES YES
11 YES YES
12 YES YES
13 YES YES
14 YES YES
15 YES YES
16 YES YES
17 YES YES
18 YES YES
19 YES YES
1 YES YES
20 YES YES
21 YES YES
22 YES YES
23 YES YES
24 YES YES
25 YES YES
26 YES YES
27 YES YES
2 YES YES
3 YES YES
4 YES YES
5 YES YES
6 YES YES
7 YES YES
8 YES YES
9 YES YES
28 YES NO
29 YES NO
29 rows selected
RMAN> select max(sequence#) from v$archived_log;
MAX(SEQUENCE#)
--------------
29
RMAN> ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "advise, allocate, alter, analyze, associate statistics, audit, backup, begin, @, call, catalog
, change, comment, commit, configure, connect, convert, copy, create, create catalog, create global, create script, create virtual, crosscheck, declar
e, delete, delete from, describe, describe catalog, disassociate statistics, drop, drop catalog, drop database, duplicate, exit, explain plan, flashba
ck, flashback table, grant, grant catalog, grant register, host, import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover,
register, release, rename, repair, replace, report, "
RMAN-01007: at line 1 column 1 file: standard input
RMAN> select member from v$logfile
2> ;
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> exit
Recovery Manager complete.
D:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 14:07:57 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter database reocver managed standby database disconnect from session;
alter database reocver managed standby database disconnect from session
*
ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database logfile current;
alter database recover managed standby database logfile current
*
ERROR at line 1:
ORA-00274: illegal recovery option LOGFILE
SQL> alter database recover managed standby database current logfile;
alter database recover managed standby database current logfile
*
ERROR at line 1:
ORA-00274: illegal recovery option CURRENT
SQL> alter database recover database cancel;
alter database recover database cancel
*
ERROR at line 1:
ORA-00274: illegal recovery option CANCEL
SQL> alter database recover database;
alter database recover database
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
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:\>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 16 14:11:19 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select sequence#,archived,applied from v$archived_log;
SEQUENCE# ARC APPLIED
---------- --- ---------
10 YES YES
11 YES YES
12 YES YES
13 YES YES
14 YES YES
15 YES YES
16 YES YES
17 YES YES
18 YES YES
19 YES YES
1 YES YES
SEQUENCE# ARC APPLIED
---------- --- ---------
20 YES YES
21 YES YES
22 YES YES
23 YES YES
24 YES YES
25 YES YES
26 YES YES
27 YES YES
2 YES YES
3 YES YES
4 YES YES
SEQUENCE# ARC APPLIED
---------- --- ---------
5 YES YES
6 YES YES
7 YES YES
8 YES YES
9 YES YES
28 YES YES
29 YES YES
29 rows selected.
SQL>
No comments:
Post a Comment