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 No comments:
Labels:

Wednesday, 27 November 2019

Oracle NID UTILITY TARGET -- Change DBNAME ONLY


  • [oracle@srv3 admin]$ sqlplus sys/system123@rac as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 27 17:11:06 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> sho parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      RAC
SQL> sho parameter db_unique

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      RAC
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@srv3 admin]$ nid TARGET=sys/system123@RAC DBNAME=STDRAC SETNAME=YES


DBNEWID: Release 12.1.0.2.0 - Production on Wed Nov 27 17:11:30 2019

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

Connected to database RAC (DBID=2608333762)

NID-00121: Database should not be open


Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.

  • [oracle@srv3 admin]$ sqlplus sys/system123@rac as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 27 17:11:53 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;

Database closed.
Database dismounted.
ORACLE instance shut down.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Warning: You are no longer connected to ORACLE.
SQL> exit

  • [oracle@srv3 admin]$ sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 27 17:13:22 2019

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

Connected to an idle instance.


  • SQL> startup mount;

ORACLE instance started.

Total System Global Area  754974720 bytes
Fixed Size                  2928968 bytes
Variable Size             549457592 bytes
Database Buffers          197132288 bytes
Redo Buffers                5455872 bytes
Database mounted.
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@srv3 admin]$ nid TARGET=sys/system123@RAC DBNAME=STDRAC SETNAME=YES


DBNEWID: Release 12.1.0.2.0 - Production on Wed Nov 27 17:13:40 2019

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

Connected to database RAC (DBID=2608333762)

Connected to server version 12.1.0

Control Files in database:
    /u01/app/oracle/oradata/RAC/control01.ctl
    /u01/app/oracle/fast_recovery_area/RAC/control02.ctl


  • Change database name of database RAC to STDRAC? (Y/[N]) => Y


Proceeding with operation
Changing database name from RAC to STDRAC
    Control File /u01/app/oracle/oradata/RAC/control01.ctl - modified
    Control File /u01/app/oracle/fast_recovery_area/RAC/control02.ctl - modified
    Datafile /u01/app/oracle/oradata/RAC/system01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/idata01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/sysaux01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/undotbs01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/users01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/ilog01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/indx01.db - wrote new name
    Datafile /u01/app/oracle/oradata/RAC/temp01.db - wrote new name
    Control File /u01/app/oracle/oradata/RAC/control01.ctl - wrote new name
    Control File /u01/app/oracle/fast_recovery_area/RAC/control02.ctl - wrote new name
    Instance shut down

Database name changed to STDRAC.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.


###################   Change CDB Database name Example ###################
[SMRCDB] to [STDRAC]

oracle@srv4:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin> . oraenv
ORACLE_SID = [SMRCDB] ?
The Oracle base remains unchanged with value /u01/app/oracle
oracle@srv4:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin> sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 6 22:55:13 2020

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

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size                  8793832 bytes
Variable Size             704643352 bytes
Database Buffers         1073741824 bytes
Redo Buffers                7983104 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
oracle@srv4:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin> nid TARGET=sys/system123@SMRCDB DBNAME=STDRAC SETNAME=YES

DBNEWID: Release 12.2.0.1.0 - Production on Thu Aug 6 22:56:25 2020

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

Connected to database SMRCDB (DBID=3280283628)

Connected to server version 12.2.0

Control Files in database:
    /u01/app/oracle/oradata/SMRCDB/control01.ctl
    /u01/app/oracle/fast_recovery_area/SMRCDB/control02.ctl

Change database name of database SMRCDB to STDRAC? (Y/[N]) => Y

Proceeding with operation
Changing database name from SMRCDB to STDRAC
    Control File /u01/app/oracle/oradata/SMRCDB/control01.ctl - modified
    Control File /u01/app/oracle/fast_recovery_area/SMRCDB/control02.ctl - modified
    Datafile /u01/app/oracle/oradata/SMRCDB/system01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/sysaux01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/undotbs01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/pdbseed/system01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/pdbseed/sysaux01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/users01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/pdbseed/undotbs01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/temp01.db - wrote new name
    Datafile /u01/app/oracle/oradata/SMRCDB/pdbseed/temp012020-08-04_22-52-23-393-PM.db - wrote new name
    Control File /u01/app/oracle/oradata/SMRCDB/control01.ctl - wrote new name
    Control File /u01/app/oracle/fast_recovery_area/SMRCDB/control02.ctl - wrote new name
    Instance shut down

Database name changed to STDRAC.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID - Completed succesfully.


  • Create pfile from  SMRCDB pfile change db_name to 'STDRAC' and start database with pfile.

oracle@srv4:/u01/app/oracle/oradata/SMRCDB> cat /u01/app/oracle/product/12.2.0/dbhome_1/dbs/initSTDRAC.ora
STDRAC.__data_transfer_cache_size=0
STDRAC.__db_cache_size=1107296256
STDRAC.__inmemory_ext_roarea=0
STDRAC.__inmemory_ext_rwarea=0
STDRAC.__java_pool_size=16777216
STDRAC.__large_pool_size=33554432
STDRAC.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
STDRAC.__pga_aggregate_target=603979776
STDRAC.__sga_target=1795162112
STDRAC.__shared_io_pool_size=67108864
STDRAC.__shared_pool_size=553648128
STDRAC.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/SMRCDB/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='/u01/app/oracle/oradata/SMRCDB/control01.ctl','/u01/app/oracle/fast_recovery_area/SMRCDB/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/SMRCDB/'
#DB_CREATE_FILE_DEST='/u01/app/oracle/oradata/SMRCDB/'
*.db_name='STDRAC'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area/SMRCDB'
*.db_recovery_file_dest_size=10398m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=STDRACXDB)'
*.enable_pluggable_database=true
*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=srv4.example.com)(PORT=1523))'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=570m
*.processes=800
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1708m
*.undo_tablespace='UNDOTBS1'
oracle@srv4:/u01/app/oracle/oradata/SMRCDB>


oracle@srv4:/u01/app/oracle/product/12.2.0/dbhome_1/network/admin>
SQL> startup pfile='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initSTDRAC.ora';
ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size                  8793832 bytes
Variable Size             704643352 bytes
Database Buffers         1073741824 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.
SQL>
SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
STDRAC    READ WRITE           PRIMARY



SQL> sho pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
SQL> select CDB from v$database;

CDB
---
YES



Posted by at No comments:
Labels:

Thursday, 14 November 2019

RAC - Restore RAC RMAN Backup linux to Single Instance Window database 12c

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

RMAN Backup - 2 node RAC 12.1.0.2.0 version on OEL 6.7 linux operating system.

RMAN  Restore - Single instance on window server.



 HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node (Doc ID 415579.1)
#######################################################################
C:\Users\varunyadav>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 13 17:24:56 2019

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

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2298478592 bytes
Fixed Size                  3834584 bytes
Variable Size             905973032 bytes
Database Buffers         1375731712 bytes
Redo Buffers               12939264 bytes
SQL>
SQL>
SQL> alter database mount;

Database altered.

SQL>
####################################################################

C:\Users\varunyadav>rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Wed Nov 13 17:25:50 2019

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

connected to target database: RAC (not mounted)

RMAN> restore controlfile from 'C:\varun_docs\rman_bkp_rac\control01_cf_d-rac_id-2608333762_35ugp2l6.bak';

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

channel ORA_DISK_1: copied control file copy
output file name=C:\APP\VARUNYADAV\ORADATA\RAC\CONTROL01.CTL
output file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\CONTROL02.CTL
Finished restore at 13-NOV-19

RMAN> catalog start with 'C:\varun_docs\rman_bkp_rac';

released channel: ORA_DISK_1
Starting implicit crosscheck backup at 13-NOV-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=577 device type=DISK
Crosschecked 21 objects
Finished implicit crosscheck backup at 13-NOV-19

Starting implicit crosscheck copy at 13-NOV-19
using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-NOV-19

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_1_6_GWQH7CGR_.ARC

searching for all files that match the pattern C:\varun_docs\rman_bkp_rac

List of Files Unknown to the Database
=====================================
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2OUGP2DN_88_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2PUGP2DO_89_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2QUGP2E7_90_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2RUGP2EM_91_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2SUGP2F9_92_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\CONTROL01_CF_D-RAC_ID-2608333762_35UGP2L6.BAK
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2TUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2UUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2VUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_30UGP2G0_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_31UGP2H7_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_32UGP2HE_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\STANDBYCONTROL_36UGP2LD_1_1.CTL

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

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

List of Cataloged Files
=======================
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2OUGP2DN_88_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2PUGP2DO_89_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2QUGP2E7_90_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2RUGP2EM_91_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_2SUGP2F9_92_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\CONTROL01_CF_D-RAC_ID-2608333762_35UGP2L6.BAK
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2TUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2UUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_2VUGP2FU_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_30UGP2G0_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_31UGP2H7_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\RAC_32UGP2HE_1_1.BCKP
File Name: C:\VARUN_DOCS\RMAN_BKP_RAC\STANDBYCONTROL_36UGP2LD_1_1.CTL

RMAN> RUN
2> {
3> set newname for datafile 1 to "C:\app\varunyadav\oradata\rac\system01.dbf";
4> set newname for datafile 3 to "C:\app\varunyadav\oradata\rac\sysaux01.dbf";
5> set newname for datafile 4 to "C:\app\varunyadav\oradata\rac\undotbs01.dbf";
6> set newname for datafile 5 to "C:\app\varunyadav\oradata\rac\undotbs02.dbf";
7> set newname for datafile 2 to "C:\app\varunyadav\oradata\rac\idata01.dbf";
8> set newname for datafile 6 to "C:\app\varunyadav\oradata\rac\users01.dbf";
9> set newname for datafile 7 to "C:\app\varunyadav\oradata\rac\ilog01.dbf";
10> set newname for datafile 8 to "C:\app\varunyadav\oradata\rac\indx01.dbf";
11> set newname for tempfile 1 to "C:\app\varunyadav\oradata\rac\temp01.dbf";
12> RESTORE DATABASE;
13> SWITCH DATAFILE ALL;
14> SWITCH TEMPFILE ALL;
15> recover database;
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

executing command: SET NEWNAME

Starting restore at 13-NOV-19
using channel ORA_DISK_1

skipping datafile 1; already restored to file C:\app\varunyadav\oradata\rac\system01.dbf
skipping datafile 3; already restored to file C:\app\varunyadav\oradata\rac\sysaux01.dbf
skipping datafile 2; already restored to file C:\app\varunyadav\oradata\rac\idata01.dbf
skipping datafile 4; already restored to file C:\app\varunyadav\oradata\rac\undotbs01.dbf
skipping datafile 5; already restored to file C:\app\varunyadav\oradata\rac\undotbs02.dbf
skipping datafile 7; already restored to file C:\app\varunyadav\oradata\rac\ilog01.dbf
skipping datafile 6; already restored to file C:\app\varunyadav\oradata\rac\users01.dbf
skipping datafile 8; already restored to file C:\app\varunyadav\oradata\rac\indx01.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 13-NOV-19

datafile 1 switched to datafile copy
input datafile copy RECID=12 STAMP=1024248929 file name=C:\app\varunyadav\oradata\rac\system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=13 STAMP=1024248931 file name=C:\app\varunyadav\oradata\rac\idata01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=14 STAMP=1024248932 file name=C:\app\varunyadav\oradata\rac\sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=15 STAMP=1024248933 file name=C:\app\varunyadav\oradata\rac\undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=16 STAMP=1024248934 file name=C:\app\varunyadav\oradata\rac\undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=17 STAMP=1024248935 file name=C:\app\varunyadav\oradata\rac\users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=18 STAMP=1024248937 file name=C:\app\varunyadav\oradata\rac\ilog01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=19 STAMP=1024248939 file name=C:\app\varunyadav\oradata\rac\indx01.dbf

renamed tempfile 1 to C:\app\varunyadav\oradata\rac\temp01.dbf in control file

Starting recover at 13-NOV-19
using channel ORA_DISK_1

starting media recovery

channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=536
channel ORA_DISK_1: reading from backup piece C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113
channel ORA_DISK_1: piece handle=C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_34UGP2L4_100_1_20191113 tag=TAG20191113T125500
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=492
channel ORA_DISK_1: reading from backup piece C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113
channel ORA_DISK_1: piece handle=C:\VARUN_DOCS\RMAN_BKP_RAC\BACKUP_RAC_DB_33UGP2L4_99_1_20191113 tag=TAG20191113T125500
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_1_492_GWQWMHM5_.ARC thread=1 sequence=492
archived log file name=C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_2_536_GWQWMGF5_.ARC thread=2 sequence=536
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/13/2019 17:50:22
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'C:\APP\VARUNYADAV\FAST_RECOVERY_AREA\RAC\ARCHIVELOG\2019_11_13\O1_MF_2_536_GWQWMGF5_.ARC'
ORA-10878: parallel recovery slave died unexpectedly

RMAN>

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_1.275.1020351751''  to  ''C:\app\varunyadav\oradata\rac\redo01.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_1.275.1020351751''  to  ''C:\app\varunyadav\oradata\rac\redo01.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_1.262.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo02.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_1.262.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo02.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_2.263.1020351755''  to  ''C:\app\varunyadav\oradata\rac\redo03.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_2.263.1020351755''  to  ''C:\app\varunyadav\oradata\rac\redo03.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_2.276.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo04.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_2.276.1020351753''  to  ''C:\app\varunyadav\oradata\rac\redo04.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_3.264.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo05.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_3.264.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo05.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_3.280.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo06.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_3.280.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo06.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_4.265.1020352335''  to  ''C:\app\varunyadav\oradata\rac\redo07.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+FRA/RAC/ONLINELOG/group_4.265.1020352335''  to  ''C:\app\varunyadav\oradata\rac\redo07.log''

RMAN> SQL "ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_4.281.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo08.log'' ";

sql statement: ALTER DATABASE RENAME FILE ''+DATA/RAC/ONLINELOG/group_4.281.1020352333''  to  ''C:\app\varunyadav\oradata\rac\redo08.log''

RMAN>
RMAN>

RMAN>

RMAN> alter database open resetlogs;

Statement processed

RMAN>
RMAN> alter database open resetlogs;

Statement processed

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

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
RAC       READ WRITE           PRIMARY

RMAN> select member from v$logfile;



MEMBER
--------------------------------------------------------------------------------

C:\APP\VARUNYADAV\ORADATA\RAC\REDO04.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO03.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO01.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO02.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO06.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO05.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO08.LOG


C:\APP\VARUNYADAV\ORADATA\RAC\REDO07.LOG


8 rows selected

RMAN> select name from v$datafile;



NAME
--------------------------------------------------------------------------------

C:\APP\VARUNYADAV\ORADATA\RAC\SYSTEM01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\IDATA01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\SYSAUX01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\UNDOTBS01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\UNDOTBS02.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\USERS01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\ILOG01.DBF


C:\APP\VARUNYADAV\ORADATA\RAC\INDX01.DBF


8 rows selected

RMAN>

C:\Users\varunyadav>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Nov 14 19:23:07 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 name,open_mode,database_Role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
RAC       READ WRITE           PRIMARY

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED PUBLIC

SQL> select group# from v$log where THREAD#=2;

    GROUP#
----------
         3
         4

SQL> alter database disable thread 2;

Database altered.

SQL> alter database clear unarchived logfile group 3;

Database altered.

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED DISABLED

SQL> sho parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled                    boolean     FALSE
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
C:\APP\VARUNYADAV\ORADATA\RAC\TEMP01.DBF

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

SQL> create temporary tablespace TEMP1 tempfile 'C:\APP\VARUNYADAV\ORADATA\RAC\TEMP001.DBF' size 50M;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL> drop tablespace TEMP including contents and datafiles;

Tablespace dropped.

SQL>

SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP1

SQL>
Posted by at No comments:
Labels: ,

Tuesday, 12 November 2019

[INS-41112] Specified network interface doesnt maintain connectivity across cluster nodes.



Cause - Installer has detected that network interface eth0 does not maintain connectivity on all cluster nodes.  Action - Ensure that the chosen interface has been configured across all cluster nodes.  Additional Information:
Summary of the failed nodes srv2  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv2"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services. srv1  - PRVG-11850 : The system call "connect" failed with error "113" while executing exectask on node "srv1"
No route to host  - Cause:  An attempt to execute exectask on the specified node failed.  - Action:  Examine the accompanying error message for details or contact Oracle Support Services.
#####################################################

Solution : This was the real time scenario  found during installation, No MAC address values defined by linux team on /etc/sysconfig/network/ ifcfg-em1 file  value HWADDR=xx:xx:xxx:xx:xx:xx



  • Check MAC address by typing command on terminal : /sbin/ifconfig
  • Add  HWADDR=xx:xx:xxx:xx:xx:xx  value  on /etc/sysconfig/network/ifcfg-em1 file  (on both nodes both NIC card)



oracle@sgdcplm01:/etc/sysconfig/network> cat ifcfg-p8p2

BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xx.xx.xxx/xx'
MTU=''
NAME='Ethernet Controller X710 for 10GbE backplane'
NETWORK=''
REMOTE_IPADDR=''
STARTMODE='auto'
oracle@sgdcplm02:/etc/sysconfig/network> cat ifcfg-em2
BOOTPROTO='static'
BROADCAST=''
ETHTOOL_OPTIONS=''
IPADDR='xx.xxx.x.xxx/xx'
MTU=''
NAME='Ethernet Controller 10G X550T'
NETWORK=''
REMOTE_IPADDR=''
HWADDR=xx:xx:xxx:xx:xx:xx
STARTMODE='auto'


Posted by at No comments:
Labels:

Oracle Database - Log Minor Examples

alter system set utl_file_dir='D:\63_archivelog\log_minor' scope=spfile;
D:\63_archivelog\log_minor
##############################################################################################################

EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', 'D:\63_archivelog\log_minor', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO01.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO02.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO03.LOG');

 SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO04.LOG');
################################################################################################################


EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/tmp/group_1.259.919359545', OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/tmp/group_2.261.919359549',OPTIONS => DBMS_LOGMNR.ADDFILE);

execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_230_1005460847.arc', OPTIONS => DBMS_LOGMNR.NEW);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_231_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_232_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_233_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_234_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_235_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_236_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_237_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);


EXECUTE DBMS_LOGMNR.START_LOGMNR (DICTFILENAME => 'D:\63_archivelog\log_minor\DICTIONARY1.ORA');

SELECT scn, operation, sql_redo, sql_undo FROM v$logmnr_contents;
Posted by at No comments:
Labels: ,

RAC - SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:08:51 2019

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

ERROR:
ORA-01017: invalid username/password; logon denied
ORA-17503: ksfdopn:2 Failed to open file
+DATA/SMRRAC/PASSWORD/pwdsmrrac.256.1020157701
ORA-12536: TNS:operation would block


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

ERROR:
ORA-01017: invalid username/password; logon denied


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@sgdcplm01:~>
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:09:02 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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @tablespace

NAME      OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
SMRRAC    READ WRITE           PRIMARY          smrrac


Tablespace                        Allocated      Current         Used    Available   %Used (vs)
Name                               Size(GB)     Size(GB)     Size(GB)     Size(GB)  (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
SYSAUX                                32.00          .83          .79        31.21         2.48
SYSTEM                                32.00          .78          .77        31.23         2.42
UNDOTBS1                              32.00          .13          .01        31.99          .02
UNDOTBS2                              32.00          .05          .01        31.99          .03
USERS                                 32.00          .00          .00        32.00          .00

SQL> sho parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/smr
                                                 rac/smrrac2/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
SQL> exit

Posted by at No comments:
Labels: ,

Siemens PLM Teamcenter -connection : Failed to initialize the pool manager

Scenario Preview:

We are getting error while starting teamcenter console below . Failed to initialize the pool manager.

Error:

sgdc:/u01/teamcenterdata #
sgdc:/u01/Dev/pool_manager/confs/dev # ./mgrstart

Siemens and the Siemens logo are registered trademarks of Siemens AG.
Teamcenter is a registered trademark of Siemens Product Lifecycle Management
Software Inc. or its subsidiaries in the United States and in other countries.
This software and related documentation are proprietary to Siemens Product
Lifecycle Management Software Inc.
Copyright (c) 2011 Siemens Product Lifecycle Management Software Inc. All
Rights Reserved.

JBoss copyright notice
JBoss is a registered trademark and servicemark of JBoss Inc.(c) 2002-2005 JBoss Inc.
All rights reserved.
JBoss and its use are subject to license: pool_manager\JBoss_lgpl_license.txt

JacORB copyright notice
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        2.3.0 <www.jacorb.org>
        (C) The JacORB project, 1997-2006
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
JacORB and its use are subject to license: pool_manager\JacORB_license.txt

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


2019/10/16-13:21:58,939 UTC MLD Log init: com.teamcenter.mld version V10000.1.0.51_20160206.00 (20160216)
log.properties found at /u01/SMRDev/pool_manager/confs/minddev/log.properties
INFO  - None - 2019/10/16-13:22:24,632 UTC - sgdc.abc.com - Starting Server Pool Mananger.
INFO  - None - 2019/10/16-13:22:24,633 UTC - sgdc.abc.com - Found pool configuration file: /u01/Dev/pool_manager/confs/minddev/serverPool.properties
INFO  - None - 2019/10/16-13:23:04,808 UTC - sgdc.abc.com - Attempting to establish teamcenter environment ...
INFO  - None - 2019/10/16-13:23:04,891 UTC - sgdc.abc.com - Teamcenter Environment established
INFO  - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Mux Address is http://sgdc.abc.com:8087
INFO  - None - 2019/10/16-13:24:45,213 UTC - sgdc.abc.com - Found TreeCache configuration file: /u01/SMRDev/pool_manager/confs/dev/TreeCacheTCP.xml
INFO  - None - 2019/10/16-13:24:45,295 UTC - sgdc.abc.com - TreeCache Configuration:
        TreeCache Cluster Name=Cluster
        TreeCache Mode=TCP
        Local Service Port=17800
        TreeCache Socket Connect Timeout=2000
        TreeCache Peers=SGDCPL06[17810]
        TreeCache Port Range=1
        TreeCache Connection Timeout=15000
        TreeCache Merge Min=5000
        TreeCache Merge Max=10000
        TreeCache Join Timeout=1250

ERROR - None - 2019/10/16-13:24:45,420 UTC - sgdc.abc.com - Error initializing JBoss Cache com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager
org.jgroups.ChannelException: failed to start protocol stack
        at org.jgroups.JChannel.connect(JChannel.java:389)
        at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)
        at com.teamcenter.jeti.SharedStore.init(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)
Caused by: java.lang.Exception: exception caused by TCP.start()
        at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)
        at org.jgroups.stack.DownHandler.run(Protocol.java:118)
Caused by: java.net.BindException: No available port to bind to
        at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)
        at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)
        at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)
        at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)
        at org.jgroups.protocols.TCP.start(TCP.java:62)
        at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)
        ... 1 more
Failed to initialize the pool manager
org.jgroups.ChannelException: failed to start protocol stack
        at org.jgroups.JChannel.connect(JChannel.java:389)
        at org.jboss.cache.TreeCache.startService(TreeCache.java:1548)
        at com.teamcenter.jeti.SharedStore.init(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.initCache(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerPoolManager.finishInit(Unknown Source)
        at com.teamcenter.jeti.serversubpoolmanager.ServerManager.main(Unknown Source)
Caused by: java.lang.Exception: exception caused by TCP.start()
        at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:600)
        at org.jgroups.stack.DownHandler.run(Protocol.java:118)
Caused by: java.net.BindException: No available port to bind to
        at org.jgroups.blocks.ConnectionTable.createServerSocket(ConnectionTable.java:342)
        at org.jgroups.blocks.ConnectionTable.start(ConnectionTable.java:174)
        at org.jgroups.blocks.ConnectionTable.<init>(ConnectionTable.java:84)
        at org.jgroups.protocols.TCP.getConnectionTable(TCP.java:98)
        at org.jgroups.protocols.TCP.start(TCP.java:62)
        at org.jgroups.stack.Protocol.handleSpecialDownEvent(Protocol.java:589)
        ... 1 more
  • Solution:


Add database details in the tc_profile file.

Location : /u01/Dev/pool_manager/confs/dev

Instance SID : ddev


sgdc:/u01/Dev/pool_manager/confs/dev #


pom_schema_sgdc.abc.com_ddev


TC_BUILD_DATE=100001020130604; export TC_BUILD_DATE
TC_DB_CONNECT=xxxx:xxxxxxxxx@ddev;
export TC_DB_CONNECT
ORACLE_SID=ddev; export ORACLE_SID
TC_DB_SERVER=sgdc.abc.com; export TC_DB_SERVER

Tnsnames.ora entery

 sgdc:/u01/teamcenterdata # cat tnsnames.ora
###########
# FILENAME: tnsnames.ora
# DATE    : Wed May 03 15:04:46 CEST 2017
###########
XXXRAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sgdc.abc.com)(PORT = 1531))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = rac)
    )
  )
XXXDEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =sgdc.abc.com)(PORT = 1531))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DDEV)
    )
  )


  • Start  teamcenter again

sgdc:/u01/Dev/pool_manager/confs/ddev # ./mgrstart


Siemens and the Siemens logo are registered trademarks of Siemens AG.
Teamcenter is a registered trademark of Siemens Product Lifecycle Management
Software Inc. or its subsidiaries in the United States and in other countries.
This software and related documentation are proprietary to Siemens Product
Lifecycle Management Software Inc.
Copyright (c) 2011 Siemens Product Lifecycle Management Software Inc. All
Rights Reserved.

JBoss copyright notice
JBoss is a registered trademark and servicemark of JBoss Inc.(c) 2002-2005 JBoss Inc.
All rights reserved.
JBoss and its use are subject to license: pool_manager\JBoss_lgpl_license.txt

JacORB copyright notice
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        2.3.0 <www.jacorb.org>
        (C) The JacORB project, 1997-2006
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
JacORB and its use are subject to license: pool_manager\JacORB_license.txt

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
"AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.


2019/10/17-06:18:18,812 UTC MLD Log init: com.teamcenter.mld version V10000.1.0.51_20160206.00 (20160216)
log.properties found at /u01/SMRDev/pool_manager/confs/minddev/log.properties
INFO  - None - 2019/10/17-06:18:44,457 UTC - sgdc.abc.com - Starting Server Pool Mananger.
INFO  - None - 2019/10/17-06:18:44,458 UTC - sgdc.abc.com - Found pool configuration file: /u01/Dev/pool_manager/confs/dev/serverPool.properties
INFO  - None - 2019/10/17-06:19:24,635 UTC - sgdc.abc.com - Attempting to establish teamcenter environment ...
INFO  - None - 2019/10/17-06:19:24,716 UTC - sgdc.abc.com - Teamcenter Environment established


INFO  - None - 2019/10/17-06:21:05,014 UTC - sgdc.abc.com - Mux Address is http://sgdc.abc.com:8087
INFO  - None - 2019/10/17-06:21:05,015 UTC - sgdc.abc.com - Found TreeCache configuration file: /u01/Dev/pool_manager/confs/ddev/TreeCacheTCP.xml
INFO  - None - 2019/10/17-06:21:05,107 UTC - sgdc.abc.com - TreeCache Configuration:
        TreeCache Cluster Name=Cluster
        TreeCache Mode=TCP
        Local Service Port=1xxxx
        TreeCache Socket Connect Timeout=2000
        TreeCache Peers=S[17810]
        TreeCache Port Range=1
        TreeCache Connection Timeout=15000
        TreeCache Merge Min=5000
        TreeCache Merge Max=10000
        TreeCache Join Timeout=1250


-------------------------------------------------------
GMS: address is 10.33.104.248:17800
-------------------------------------------------------
INFO  - None - 2019/10/17-06:21:20,263 UTC - sgdc.abc.com - TreeCache View: [10.33.104.248:17800|0] [10.33.104.248:17800]
INFO  - None - 2019/10/17-06:21:20,264 UTC - sgdc.abc.com - TreeCache GMS address: 10.33.104.248:17800
INFO  - None - 2019/10/17-06:21:25,305 UTC - sgdc.abc.com - MBean HTML adaptor is configured to start at http://sgdc.abc.com:8082
tecs>2019/10/17-06:21:30,474 UTC MLD Log init: com.teamcenter.mld version V10000.1.0.51_20160206.00 (20160216)
tecs>log.properties found at /u01/Dev/pool_manager/confs/ddev/log.properties
INFO  - None - 2019/10/17-06:21:31,963 UTC - sgdc.abc.com - Server tcs@PoolA@11276@sgdc.abc.com published
INFO  - None - 2019/10/17-06:21:34,014 UTC - sgdc.abc.com - Server tcs@PoolA@11276@sgdc.abc.com published
INFO  - None - 2019/10/17-06:21:51,038 UTC - sgdc.abc.com - TECS started by ServerManager.  Output is written to /u01/Dev/pool_manager/confs/ddev/tecs.out
INFO  - None - 2019/10/17-06:21:51,038 UTC - sgdc.abc.com - To terminate TECS, use /u01/Dev/pool_manager/confs/dev/tecsstop




Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)