Oracle Database Commands and Practical Examples

Monday, 5 August 2019

PRCR-1079 : Failed to start resource ora.rac.db CRS-5017: The resource action "ora.rac.db start" encountered the following error: ORA-01102: cannot mount database in EXCLUSIVE mode

[oracle@srv2 u01]$ . oraenv
ORACLE_SID = [rac2] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv2 u01]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 5 13:40:38 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> sho parameter cluster

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string

SQL> sho parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/RAC/PARAMETERFILE/spfile
.268.1011961131

SQL> alter system set cluster_database=FALSE scope=both;
alter system set cluster_database=FALSE scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set cluster_database=FALSE scope=spfile;

System altered.

SQL> exit

[root@srv1 u01]# srvctl start database -d rac -startoption mount
PRCR-1079 : Failed to start resource ora.rac.db
CRS-5017: The resource action "ora.rac.db start" encountered the following error:
ORA-01102: cannot mount database in EXCLUSIVE mode
. For details refer to "(:CLSN00107:)" in "/u01/app/grid/diag/crs/srv2/crs/trace/crsd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.rac.db' on 'srv2' failed
CRS-2632: There are no more servers to try to place resource 'ora.rac.db' on that would satisfy its placement policy
[root@srv1 u01]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BACKUP.BACKUP.advm
ONLINE ONLINE srv1 Volume device /dev/a
sm/backup-461 is onl
ine,STABLE
ONLINE ONLINE srv2 Volume device /dev/a
sm/backup-461 is onl
ine,STABLE
ora.BACKUP.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.CRS.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.DATA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.FRA.dg
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.asm
ONLINE ONLINE srv1 Started,STABLE
ONLINE ONLINE srv2 Started,STABLE
ora.backup.backup.acfs
ONLINE ONLINE srv1 mounted on /u01/Back
up,STABLE
ONLINE ONLINE srv2 mounted on /u01/Back
up,STABLE
ora.net1.network
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
ora.ons
ONLINE ONLINE srv1 STABLE
ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE srv1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE srv2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE srv2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE srv2 169.254.128.179 192.
168.10.2,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv2 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.acsrv.svc
1 OFFLINE OFFLINE STABLE
ora.rac.db
1 ONLINE INTERMEDIATE srv1 Mounted (Closed),STA
BLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.rac.lbsrv.svc
1 OFFLINE OFFLINE STABLE
2 OFFLINE OFFLINE STABLE
ora.rac.pretaf.svc
1 OFFLINE OFFLINE STABLE
ora.rac.pretaf_preconnect.svc
1 OFFLINE OFFLINE STABLE
ora.rac.soesrv.svc
1 OFFLINE OFFLINE STABLE
ora.rac.staf.svc
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE srv1 STABLE
ora.scan2.vip
1 ONLINE ONLINE srv2 STABLE
ora.scan3.vip
1 ONLINE ONLINE srv2 STABLE
ora.srv1.vip
1 ONLINE ONLINE srv1 STABLE
ora.srv2.vip
1 ONLINE ONLINE srv2 STABLE
--------------------------------------------------------------------------------

[oracle@srv2 u01]$ . oraenv

ORACLE_SID = [rac2] ? rac2

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@srv2 u01]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 5 13:54:53 2019

Connected to an idle instance.

SQL> startup mount;

ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> sho parameter cluster

ORA-01034: ORACLE not available

Process ID: 0

Session ID: 0 Serial number: 0

SQL> exit

SQL> sho parameter cluster_database

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

cluster_database boolean FALSE

cluster_database_instances integer 1

SQL> alter system set cluster_database=TRUE scope=spfile;

System altered.

RMAN 12c 12.1.0.2.0 - Restore database preview and summary command

RMAN> restore database preview;

Starting restore at 05-AUG-19
using channel ORA_DISK_1

List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
144 Full 4.96G DISK 00:10:46 31-JUL-19
BP Key: 146 Status: AVAILABLE Compressed: NO Tag: TAG20190731T185241
Piece Name: /u01/Backup/ora_df1015095163_s188_s1
List of Datafiles in backup set 144
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/system.258.1011960053
2 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/idata.269.1014653909
3 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/sysaux.257.1011959959
4 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/undotbs1.260.1011960171
5 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/undotbs2.265.1011960859
6 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/users.259.1011960169
7 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/indx.270.1014656575
8 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/ilog.271.1014656841
9 Full 14458347 31-JUL-19 +DATA/RAC/DATAFILE/soetbs.273.1015005687

List of Archived Log Copies for database with db_unique_name RAC
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - ---------
729 1 412 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_412.367.1015095829

730 1 413 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_413.365.1015106633

731 1 414 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_414.363.1015106913

734 1 415 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_415.359.1015140637

737 1 416 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_416.355.1015176617

738 1 417 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_417.354.1015180475

741 1 418 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_418.350.1015181119

745 1 419 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_419.292.1015183619

747 1 420 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_420.295.1015192905

748 1 421 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_421.296.1015192991

749 1 422 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_422.297.1015212647

750 1 423 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_423.266.1015220859

751 1 424 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_424.269.1015237821

752 1 425 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_425.268.1015242777

753 1 426 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_426.410.1015243245

757 1 427 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_427.414.1015243291

759 1 428 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_428.400.1015245559

761 1 429 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_429.402.1015246315

763 1 430 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_430.437.1015246321

765 1 431 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_431.439.1015247851

766 1 432 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_432.440.1015249251

767 1 433 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_433.441.1015249253

772 1 434 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_434.446.1015250047

773 1 435 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_435.447.1015279255

774 1 436 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_436.448.1015279371

775 1 437 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_437.449.1015279435

777 1 438 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_438.451.1015307679

778 1 439 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_439.452.1015307703

779 1 440 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_440.453.1015308071

781 1 441 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_441.455.1015309837

782 1 442 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_442.456.1015322825

783 1 443 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_443.457.1015337227

785 1 444 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_444.459.1015351651

786 1 445 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_445.460.1015366077

788 1 446 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_446.462.1015378807

789 1 447 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_447.463.1015394133

790 1 448 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_448.464.1015394493

792 1 449 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_449.466.1015403425

793 1 450 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_450.467.1015410639

794 1 451 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_451.468.1015423849

796 1 452 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_452.470.1015438205

797 1 453 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_453.471.1015445403

798 1 454 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_454.472.1015452685

800 1 455 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_455.474.1015457419

801 1 456 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_05/thread_1_seq_456.475.1015486211

728 2 324 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_2_seq_324.368.1015095829

732 2 325 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_2_seq_325.361.1015106925

733 2 326 A 31-JUL-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_326.360.1015133793

735 2 327 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_327.358.1015140643

736 2 328 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_328.356.1015175817

739 2 329 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_329.352.1015180483

740 2 330 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_330.351.1015180487

742 2 331 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_331.290.1015181217

743 2 332 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_332.291.1015181223

744 2 333 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_333.408.1015183617

746 2 334 A 01-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_334.294.1015183999

754 2 335 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_335.264.1015243253

755 2 336 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_336.263.1015243261

756 2 337 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_337.262.1015243287

758 2 338 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_338.416.1015243297

760 2 339 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_339.399.1015245569

762 2 340 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_340.436.1015246321

764 2 341 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_341.438.1015247843

768 2 342 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_342.442.1015250041

769 2 343 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_343.443.1015250043

770 2 344 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_344.444.1015250045

771 2 345 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_345.445.1015250045

776 2 346 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_346.450.1015279439

780 2 347 A 02-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_2_seq_347.454.1015308075

784 2 348 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_2_seq_348.458.1015337231

787 2 349 A 03-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_349.461.1015374633

791 2 350 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_350.465.1015394497

795 2 351 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_351.469.1015423853

799 2 352 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_352.473.1015452691

802 2 353 A 04-AUG-19
Name: +FRA/RAC/ARCHIVELOG/2019_08_05/thread_2_seq_353.476.1015493405

recovery will be done up to SCN 14458347
Media recovery start SCN is 14458347
Recovery must be done beyond SCN 14458347 to clear datafile fuzziness
Finished restore at 05-AUG-19

RMAN> restore database preview summary;

Starting restore at 05-AUG-19

using channel ORA_DISK_1

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

144 B F A DISK 31-JUL-19 1 1 NO TAG20190731T185241

List of Archived Log Copies for database with db_unique_name RAC

=====================================================================

Key Thrd Seq S Low Time

------- ---- ------- - ---------

729 1 412 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_412.367.1015095829

730 1 413 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_413.365.1015106633

731 1 414 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_1_seq_414.363.1015106913

734 1 415 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_415.359.1015140637

737 1 416 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_416.355.1015176617

738 1 417 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_417.354.1015180475

741 1 418 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_418.350.1015181119

745 1 419 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_419.292.1015183619

747 1 420 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_420.295.1015192905

748 1 421 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_1_seq_421.296.1015192991

749 1 422 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_422.297.1015212647

750 1 423 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_423.266.1015220859

751 1 424 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_424.269.1015237821

752 1 425 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_425.268.1015242777

753 1 426 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_426.410.1015243245

757 1 427 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_427.414.1015243291

759 1 428 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_428.400.1015245559

761 1 429 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_429.402.1015246315

763 1 430 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_430.437.1015246321

765 1 431 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_431.439.1015247851

766 1 432 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_432.440.1015249251

767 1 433 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_433.441.1015249253

772 1 434 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_434.446.1015250047

773 1 435 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_435.447.1015279255

774 1 436 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_436.448.1015279371

775 1 437 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_1_seq_437.449.1015279435

777 1 438 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_438.451.1015307679

778 1 439 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_439.452.1015307703

779 1 440 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_440.453.1015308071

781 1 441 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_441.455.1015309837

782 1 442 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_442.456.1015322825

783 1 443 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_443.457.1015337227

785 1 444 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_444.459.1015351651

786 1 445 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_1_seq_445.460.1015366077

788 1 446 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_446.462.1015378807

789 1 447 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_447.463.1015394133

790 1 448 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_448.464.1015394493

792 1 449 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_449.466.1015403425

793 1 450 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_450.467.1015410639

794 1 451 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_451.468.1015423849

796 1 452 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_452.470.1015438205

797 1 453 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_453.471.1015445403

798 1 454 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_454.472.1015452685

800 1 455 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_1_seq_455.474.1015457419

801 1 456 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_05/thread_1_seq_456.475.1015486211

728 2 324 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_2_seq_324.368.1015095829

732 2 325 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_07_31/thread_2_seq_325.361.1015106925

733 2 326 A 31-JUL-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_326.360.1015133793

735 2 327 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_327.358.1015140643

736 2 328 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_328.356.1015175817

739 2 329 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_329.352.1015180483

740 2 330 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_330.351.1015180487

742 2 331 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_331.290.1015181217

743 2 332 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_332.291.1015181223

744 2 333 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_333.408.1015183617

746 2 334 A 01-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_01/thread_2_seq_334.294.1015183999

754 2 335 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_335.264.1015243253

755 2 336 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_336.263.1015243261

756 2 337 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_337.262.1015243287

758 2 338 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_338.416.1015243297

760 2 339 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_339.399.1015245569

762 2 340 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_340.436.1015246321

764 2 341 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_341.438.1015247843

768 2 342 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_342.442.1015250041

769 2 343 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_343.443.1015250043

770 2 344 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_344.444.1015250045

771 2 345 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_345.445.1015250045

776 2 346 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_02/thread_2_seq_346.450.1015279439

780 2 347 A 02-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_2_seq_347.454.1015308075

784 2 348 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_03/thread_2_seq_348.458.1015337231

787 2 349 A 03-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_349.461.1015374633

791 2 350 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_350.465.1015394497

795 2 351 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_351.469.1015423853

799 2 352 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_04/thread_2_seq_352.473.1015452691

802 2 353 A 04-AUG-19

Name: +FRA/RAC/ARCHIVELOG/2019_08_05/thread_2_seq_353.476.1015493405

recovery will be done up to SCN 14458347

Media recovery start SCN is 14458347

Recovery must be done beyond SCN 14458347 to clear datafile fuzziness

Finished restore at 05-AUG-19

RMAN>

Rman Validate Database| Tablespace | Datafile command 12cR1

[oracle@srv2 ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 5 12:01:07 2019

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

connected to target database: RAC (DBID=2599942250)

RMAN> validate database;

Starting validate at 05-AUG-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=79 instance=rac2 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
input datafile file number=00003 name=+DATA/RAC/DATAFILE/sysaux.257.1011959959
input datafile file number=00009 name=+DATA/RAC/DATAFILE/soetbs.273.1015005687
input datafile file number=00001 name=+DATA/RAC/DATAFILE/system.258.1011960053
input datafile file number=00004 name=+DATA/RAC/DATAFILE/undotbs1.260.1011960171
input datafile file number=00005 name=+DATA/RAC/DATAFILE/undotbs2.265.1011960859
input datafile file number=00007 name=+DATA/RAC/DATAFILE/indx.270.1014656575
input datafile file number=00008 name=+DATA/RAC/DATAFILE/ilog.271.1014656841
input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169

channel ORA_DISK_1: validation complete, elapsed time: 00:06:05
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 16699 112640 16154464
File Name: +DATA/RAC/DATAFILE/system.258.1011960053
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 69432
Index 0 15350
Other 0 11159

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2 OK 0 24099 307200 13862082
File Name: +DATA/RAC/DATAFILE/idata.269.1014653909
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 132070
Index 0 138908
Other 0 12123

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 34799 198404 16154334
File Name: +DATA/RAC/DATAFILE/sysaux.257.1011959959
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 54830
Index 0 51824
Other 0 56947

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 1 25600 16154464
File Name: +DATA/RAC/DATAFILE/undotbs1.260.1011960171
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 25599

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 2561 25600 16154350
File Name: +DATA/RAC/DATAFILE/undotbs2.265.1011960859
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 23039

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 17 642 1664810
File Name: +DATA/RAC/DATAFILE/users.259.1011960169
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30
Index 0 5
Other 0 588

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 12673 12800 12728855
File Name: +DATA/RAC/DATAFILE/indx.270.1014656575
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 12044 12800 13860531
File Name: +DATA/RAC/DATAFILE/ilog.271.1014656841
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 605
Index 0 0
Other 0 151

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 7679 128896 14507773
File Name: +DATA/RAC/DATAFILE/soetbs.273.1015005687
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 72746
Index 0 46799
Other 0 1672

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Control File OK 0 1242
Finished validate at 05-AUG-19

RMAN>

RMAN> validate tablespace users;

Starting validate at 05-AUG-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 17 642 1664810
File Name: +DATA/RAC/DATAFILE/users.259.1011960169
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30
Index 0 5
Other 0 588

Finished validate at 05-AUG-19

RMAN> validate datafile '+DATA/RAC/DATAFILE/users.259.1011960169';

Starting validate at 05-AUG-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 17 642 1664810
File Name: +DATA/RAC/DATAFILE/users.259.1011960169
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30
Index 0 5
Other 0 588

Finished validate at 05-AUG-19

RMAN>

HOME

Monday, 5 August 2019

PRCR-1079 : Failed to start resource ora.rac.db CRS-5017: The resource action "ora.rac.db start" encountered the following error: ORA-01102: cannot mount database in EXCLUSIVE mode

RMAN 12c 12.1.0.2.0 - Restore database preview and summary command

Rman Validate Database| Tablespace | Datafile command 12cR1