Friday, 29 November 2019

RMAN - Error : ORA-19698: redo01.log is from different database: id


  • ERROR: ORA-19698: /u01/app/oracle/oradata/SMRTESTENV/redo01.log is from different database: id=1055740869, db_name=SMRTESTE


oracle@sgdcpl08:/u02/expdp/smrtestenv> ps -ef |grep pmon
oracle    3460  2965  0 08:13 pts/0    00:00:00 grep --color=auto pmon
oracle@sgdcpl08:/u02/expdp/smrtestenv> . oraenv
ORACLE_SID = [SMRTESTENV] ?
The Oracle base remains unchanged with value /u01/app/oracle

  • oracle@sgdcpl08:/u02/expdp/smrtestenv> sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 29 08:13:55 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.


  • SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1593835520 bytes
Fixed Size                  2924880 bytes
Variable Size            1275072176 bytes
Database Buffers          301989888 bytes
Redo Buffers               13848576 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

  • oracle@sgdcpl08:/u02/expdp/smrtestenv> rman target /


Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 29 08:14:14 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SMRTESTE (not mounted)


  • RMAN> restore controlfile from '/u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak';

\
Starting restore at 29-NOV-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1032 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/SMRTESTENV/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/SMRTESTENV/control02.ctl
Finished restore at 29-NOV-19


  • RMAN>alter database mount;


Statement processed
released channel: ORA_DISK_1


  • RMAN> catalog start with '/u02/expdp/smrtestenv';


Starting implicit crosscheck backup at 29-NOV-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=693 device type=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 29-NOV-19

Starting implicit crosscheck copy at 29-NOV-19
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 29-NOV-19

searching for all files in the recovery area
cataloging files...
no files cataloged

searching for all files that match the pattern /u02/expdp/smrtestenv

List of Files Unknown to the Database
=====================================
File Name: /u02/expdp/smrtestenv/expdp-2019-11-29_02-40-01.dmp
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b0uhvp54_2400_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b1uhvp54_2401_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b2uhvp54_2402_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b3uhvp54_2403_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b4uhvp55_2404_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b5uhvp55_2405_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b7uhvp59_2407_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b8uhvp5a_2408_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bcuhvp71_2412_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bkui2dh7_2420_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bmui2dha_2422_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bnui2dj1_2423_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_boui2dj1_2424_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bpui2dj1_2425_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bqui2dj1_2426_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_brui2dj4_2427_1_20191129
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bduhvp74_20191128.bak
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak
File Name: /u02/expdp/smrtestenv/rman_SMRTESTENV.log

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b0uhvp54_2400_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b1uhvp54_2401_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b2uhvp54_2402_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b3uhvp54_2403_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b4uhvp55_2404_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b5uhvp55_2405_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b7uhvp59_2407_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b8uhvp5a_2408_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bcuhvp71_2412_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bkui2dh7_2420_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bmui2dha_2422_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bnui2dj1_2423_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_boui2dj1_2424_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bpui2dj1_2425_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bqui2dj1_2426_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_brui2dj4_2427_1_20191129
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bduhvp74_20191128.bak
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak

List of Files Which Were Not Cataloged
=======================================
File Name: /u02/expdp/smrtestenv/expdp-2019-11-29_02-40-01.dmp
  RMAN-07520: Reason: Data pump dump file
File Name: /u02/expdp/smrtestenv/rman_SMRTESTENV.log
  RMAN-07517: Reason: The file header is corrupted


  • RMAN> RUN

{
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database;
}2> 3> 4> 5> 6> 7>

Starting restore at 29-NOV-19
using channel ORA_DISK_1

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 00002 to /u01/app/oracle/oradata/SMRTESTENV/ILOG01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 00007 to /u01/app/oracle/oradata/SMRTESTENV/INDX01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 /u01/app/oracle/oradata/SMRTESTENV/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00006 to /u01/app/oracle/oradata/SMRTESTENV/users01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00001 to /u01/app/oracle/oradata/SMRTESTENV/system01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
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 /u01/app/oracle/oradata/SMRTESTENV/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
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 00005 to /u01/app/oracle/oradata/SMRTESTENV/IDATA01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 29-NOV-19



Starting recover at 29-NOV-19
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/29/2019 08:31:22
ORA-19698: /u01/app/oracle/oradata/SMRTESTENV/redo01.log is from different database: id=1055740869, db_name=SMRTESTE


  • RMAN>  alter database open resetlogs;


NOTE : alter database open resetlogs not work here. It will show error below:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 11/29/2019 08:35:45
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/SMRTESTENV/system01.dbf'

RMAN> exit


Recovery Manager complete.

###################################################################################################################################################################################################################################################


  • Remove all datafiles, controlfiles, redo log files at OS level.
  • startup nomount;
  • restore controlfile from backup location
  • alter database mount
  • catalog start with
  • restore and recover using rman backup ustility
  • alter database open resetlogs


oracle@sgdcpl08:/u02/expdp/smrtestenv> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 29 08:42:13 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-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/SMRTESTENV/control01.ctl'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
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
oracle@sgdcpl08:/u02/expdp/smrtestenv> ps -ef |grep pmon
oracle    3481     1  0 08:14 ?        00:00:00 ora_pmon_SMRTESTENV
oracle    7127  2965  0 08:42 pts/0    00:00:00 grep --color=auto pmon
oracle@sgdcpl08:/u02/expdp/smrtestenv> sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Fri Nov 29 08:42:35 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 abort;
ORACLE instance shut down.

  • SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1593835520 bytes
Fixed Size                  2924880 bytes
Variable Size            1275072176 bytes
Database Buffers          301989888 bytes
Redo Buffers               13848576 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

  • oracle@sgdcpl08:/u02/expdp/smrtestenv> rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Nov 29 08:43:00 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SMRTESTE (not mounted)


  • RMAN> restore controlfile from '/u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak';

Starting restore at 29-NOV-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1032 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=/u01/app/oracle/oradata/SMRTESTENV/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/SMRTESTENV/control02.ctl
Finished restore at 29-NOV-19


  • RMAN> alter database mount;

Statement processed
released channel: ORA_DISK_1


  • RMAN> catalog start with '/u02/expdp/smrtestenv';

Starting implicit crosscheck backup at 29-NOV-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=693 device type=DISK
Crosschecked 23 objects
Finished implicit crosscheck backup at 29-NOV-19

Starting implicit crosscheck copy at 29-NOV-19
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 29-NOV-19

searching for all files in the recovery area
cataloging files...
no files cataloged

searching for all files that match the pattern /u02/expdp/smrtestenv

List of Files Unknown to the Database
=====================================
File Name: /u02/expdp/smrtestenv/expdp-2019-11-29_02-40-01.dmp
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b0uhvp54_2400_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b1uhvp54_2401_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b2uhvp54_2402_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b3uhvp54_2403_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b4uhvp55_2404_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b5uhvp55_2405_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b7uhvp59_2407_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b8uhvp5a_2408_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bcuhvp71_2412_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bkui2dh7_2420_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bmui2dha_2422_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bnui2dj1_2423_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_boui2dj1_2424_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bpui2dj1_2425_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bqui2dj1_2426_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_brui2dj4_2427_1_20191129
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bduhvp74_20191128.bak
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak
File Name: /u02/expdp/smrtestenv/rman_SMRTESTENV.log
File Name: /u02/expdp/smrtestenv/o1_mf_1_3846_gy0qwlmm_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3847_gy0rls14_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3848_gy0xqp6j_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3849_gy0xs21o_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3850_gy0xshc3_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3851_gy1196h9_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3852_gy16nnt2_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3853_gy16pkmd_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3854_gy1fpyth_.arc

Do you really want to catalog the above files (enter YES or NO)? YEs
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b0uhvp54_2400_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b1uhvp54_2401_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b2uhvp54_2402_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b3uhvp54_2403_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b4uhvp55_2404_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b5uhvp55_2405_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b7uhvp59_2407_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_b8uhvp5a_2408_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bcuhvp71_2412_1_20191128
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bkui2dh7_2420_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bmui2dha_2422_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bnui2dj1_2423_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_boui2dj1_2424_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bpui2dj1_2425_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bqui2dj1_2426_1_20191129
File Name: /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_brui2dj4_2427_1_20191129
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bduhvp74_20191128.bak
File Name: /u02/expdp/smrtestenv/control01SMRTESTE_bsui2dj6_20191129.bak
File Name: /u02/expdp/smrtestenv/o1_mf_1_3846_gy0qwlmm_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3847_gy0rls14_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3848_gy0xqp6j_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3849_gy0xs21o_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3850_gy0xshc3_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3851_gy1196h9_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3852_gy16nnt2_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3853_gy16pkmd_.arc
File Name: /u02/expdp/smrtestenv/o1_mf_1_3854_gy1fpyth_.arc

List of Files Which Were Not Cataloged
=======================================
File Name: /u02/expdp/smrtestenv/expdp-2019-11-29_02-40-01.dmp
  RMAN-07520: Reason: Data pump dump file
File Name: /u02/expdp/smrtestenv/rman_SMRTESTENV.log
  RMAN-07517: Reason: The file header is corrupted


RMAN> RUN
{
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database;
}2> 3> 4> 5> 6> 7>

Starting restore at 29-NOV-19
using channel ORA_DISK_1

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 00002 to /u01/app/oracle/oradata/SMRTESTENV/ILOG01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bfui2dh5_2415_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00007 to /u01/app/oracle/oradata/SMRTESTENV/INDX01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bhui2dh5_2417_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 /u01/app/oracle/oradata/SMRTESTENV/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bjui2dh6_2419_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00006 to /u01/app/oracle/oradata/SMRTESTENV/users01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_blui2dh9_2421_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00001 to /u01/app/oracle/oradata/SMRTESTENV/system01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_biui2dh6_2418_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
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 /u01/app/oracle/oradata/SMRTESTENV/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_bgui2dh5_2416_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
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 00005 to /u01/app/oracle/oradata/SMRTESTENV/IDATA01.dbf
channel ORA_DISK_1: reading from backup piece /u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129
channel ORA_DISK_1: piece handle=/u02/expdp/smrtestenv/Backup_SMRTESTE_DB_beui2dh5_2414_1_20191129 tag=FULL_BACKUP_DAILY
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 29-NOV-19



Starting recover at 29-NOV-19
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 3853 is already on disk as file /u02/expdp/smrtestenv/o1_mf_1_3853_gy16pkmd_.arc
archived log for thread 1 with sequence 3854 is already on disk as file /u02/expdp/smrtestenv/o1_mf_1_3854_gy1fpyth_.arc
archived log file name=/u02/expdp/smrtestenv/o1_mf_1_3853_gy16pkmd_.arc thread=1 sequence=3853
archived log file name=/u02/expdp/smrtestenv/o1_mf_1_3854_gy1fpyth_.arc thread=1 sequence=3854
unable to find archived log
archived log thread=1 sequence=3855
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/29/2019 08:46:59
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 3855 and starting SCN of 38305278

RMAN>


  • RMAN> alter database open resetlogs;

Statement processed

RMAN>

  • RMAN> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
SMRTESTE  READ WRITE           PRIMARY

RMAN>


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)