Oracle Database Commands and Practical Examples

Monday, 5 August 2019

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>

Friday, 2 August 2019

RAC 12c R1 Automatic | Manual and NORESTART Management Policies PART 2 -NorestartPolicy

Norestart : The database is never automatically restarted still act as manual. Previous condition will be manual.

[root@srv1 trace]# srvctl modify database -db rac -policy norestart
The management policy of services acsrv,lbsrv,pretaf,soesrv,staf will be modified to MANUAL. Modify the management policy of the database rac? (y/[n]) y
[root@srv1 trace]# srvctl config database -d rac
Database unique name: rac
Database name: rac
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_2
Oracle user: oracle
Spfile: +DATA/RAC/PARAMETERFILE/spfile.268.1011961131
Password file: +DATA/RAC/PASSWORD/pwdrac.256.1011959883
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: NORESTART
Server pools:
Disk Groups: FRA,DATA
Mount point paths:
Services: acsrv,lbsrv,pretaf,soesrv,staf
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances: rac1,rac2
Configured nodes: srv1,srv2
Database is administrator managed
[root@srv1 trace]# 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 srv1 169.254.163.239 192.
168.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE ONLINE srv1 Open,STABLE
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.acsrv.svc
1 ONLINE ONLINE srv2 STABLE
ora.rac.db
1 ONLINE ONLINE srv1 Open,STABLE
2 ONLINE ONLINE srv2 Open,STABLE
ora.rac.lbsrv.svc
1 ONLINE ONLINE srv1 STABLE
2 ONLINE ONLINE srv2 STABLE
ora.rac.pretaf.svc
1 ONLINE ONLINE srv2 STABLE
ora.rac.pretaf_preconnect.svc
1 ONLINE ONLINE srv1 STABLE
ora.rac.soesrv.svc
1 ONLINE ONLINE srv2 STABLE
ora.rac.staf.svc
1 ONLINE ONLINE srv2 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
--------------------------------------------------------------------------------
[root@srv1 trace]# crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'srv1'
CRS-2673: Attempting to stop 'ora.crsd' on 'srv2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'srv1'
CRS-2673: Attempting to stop 'ora.rac.lbsrv.svc' on 'srv1'
CRS-2673: Attempting to stop 'ora.mgmtdb' on 'srv1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srv1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'srv1'
CRS-2673: Attempting to stop 'ora.backup.backup.acfs' on 'srv1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'srv2'
CRS-2673: Attempting to stop 'ora.backup.backup.acfs' on 'srv2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'srv2'
CRS-2673: Attempting to stop 'ora.oc4j' on 'srv2'
CRS-2673: Attempting to stop 'ora.cvu' on 'srv2'
CRS-2677: Stop of 'ora.rac.lbsrv.svc' on 'srv1' succeeded
CRS-2677: Stop of 'ora.cvu' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.rac.pretaf_preconnect.svc' on 'srv1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srv1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'srv1'
CRS-2677: Stop of 'ora.rac.pretaf_preconnect.svc' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.rac.db' on 'srv1'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'srv2'
CRS-2677: Stop of 'ora.rac.db' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'srv1'
CRS-2677: Stop of 'ora.scan1.vip' on 'srv1' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'srv2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'srv1'
CRS-2673: Attempting to stop 'ora.srv1.vip' on 'srv1'
CRS-2677: Stop of 'ora.DATA.dg' on 'srv1' succeeded
CRS-2677: Stop of 'ora.srv1.vip' on 'srv1' succeeded
CRS-2677: Stop of 'ora.mgmtdb' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'srv1'
CRS-2677: Stop of 'ora.MGMTLSNR' on 'srv1' succeeded
CRS-2677: Stop of 'ora.backup.backup.acfs' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.BACKUP.BACKUP.advm' on 'srv1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'srv1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'srv2'
CRS-2677: Stop of 'ora.CRS.dg' on 'srv1' succeeded
CRS-2677: Stop of 'ora.BACKUP.BACKUP.advm' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.BACKUP.dg' on 'srv1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'srv2' succeeded
CRS-2677: Stop of 'ora.backup.backup.acfs' on 'srv2' succeeded
CRS-2677: Stop of 'ora.BACKUP.dg' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'srv1'
CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'srv2'
CRS-2673: Attempting to stop 'ora.BACKUP.BACKUP.advm' on 'srv2'
CRS-2673: Attempting to stop 'ora.rac.acsrv.svc' on 'srv2'
CRS-2673: Attempting to stop 'ora.rac.lbsrv.svc' on 'srv2'
CRS-2673: Attempting to stop 'ora.rac.soesrv.svc' on 'srv2'
CRS-2673: Attempting to stop 'ora.rac.staf.svc' on 'srv2'
CRS-2673: Attempting to stop 'ora.rac.pretaf.svc' on 'srv2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'srv2'
CRS-2677: Stop of 'ora.CRS.dg' on 'srv2' succeeded
CRS-2677: Stop of 'ora.BACKUP.BACKUP.advm' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.BACKUP.dg' on 'srv2'
CRS-2677: Stop of 'ora.rac.lbsrv.svc' on 'srv2' succeeded
CRS-2677: Stop of 'ora.rac.soesrv.svc' on 'srv2' succeeded
CRS-2677: Stop of 'ora.rac.acsrv.svc' on 'srv2' succeeded
CRS-2677: Stop of 'ora.rac.pretaf.svc' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'srv1'
CRS-2677: Stop of 'ora.rac.staf.svc' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.rac.db' on 'srv2'
CRS-2677: Stop of 'ora.ons' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'srv1'
CRS-2673: Attempting to stop 'ora.srv2.vip' on 'srv2'
CRS-2677: Stop of 'ora.net1.network' on 'srv1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'srv1' has completed
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'srv2'
CRS-2677: Stop of 'ora.oc4j' on 'srv2' succeeded
CRS-2677: Stop of 'ora.crsd' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'srv1'
CRS-2673: Attempting to stop 'ora.evmd' on 'srv1'
CRS-2673: Attempting to stop 'ora.storage' on 'srv1'
CRS-2677: Stop of 'ora.storage' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'srv1'
CRS-2677: Stop of 'ora.rac.db' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'srv2'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'srv2'
CRS-2677: Stop of 'ora.DATA.dg' on 'srv2' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'srv2' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'srv2' succeeded
CRS-2677: Stop of 'ora.BACKUP.dg' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'srv2'
CRS-2677: Stop of 'ora.asm' on 'srv2' succeeded
CRS-2677: Stop of 'ora.srv2.vip' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'srv2'
CRS-2677: Stop of 'ora.ctssd' on 'srv1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'srv1' succeeded
CRS-2677: Stop of 'ora.ons' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'srv2'
CRS-2677: Stop of 'ora.net1.network' on 'srv2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'srv2' has completed
CRS-2677: Stop of 'ora.crsd' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'srv2'
CRS-2673: Attempting to stop 'ora.evmd' on 'srv2'
CRS-2673: Attempting to stop 'ora.storage' on 'srv2'
CRS-2677: Stop of 'ora.storage' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'srv2'
CRS-2677: Stop of 'ora.ctssd' on 'srv2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'srv2' succeeded
CRS-2677: Stop of 'ora.asm' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'srv1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'srv1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'srv1'
CRS-2677: Stop of 'ora.cssd' on 'srv1' succeeded
CRS-2677: Stop of 'ora.asm' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'srv2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'srv2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'srv2'
CRS-2677: Stop of 'ora.cssd' on 'srv2' succeeded
[root@srv1 trace]# crsctl start cluster -all
CRS-2672: Attempting to start 'ora.evmd' on 'srv1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'srv2'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'srv1'
CRS-2672: Attempting to start 'ora.evmd' on 'srv2'
CRS-2676: Start of 'ora.cssdmonitor' on 'srv2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'srv2'
CRS-2672: Attempting to start 'ora.diskmon' on 'srv2'
CRS-2676: Start of 'ora.cssdmonitor' on 'srv1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'srv1'
CRS-2672: Attempting to start 'ora.diskmon' on 'srv1'
CRS-2676: Start of 'ora.diskmon' on 'srv2' succeeded
CRS-2676: Start of 'ora.diskmon' on 'srv1' succeeded
CRS-2676: Start of 'ora.evmd' on 'srv1' succeeded
CRS-2676: Start of 'ora.evmd' on 'srv2' succeeded
CRS-2676: Start of 'ora.cssd' on 'srv2' succeeded
CRS-2676: Start of 'ora.cssd' on 'srv1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'srv2'
CRS-2672: Attempting to start 'ora.ctssd' on 'srv1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'srv2'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'srv1'
CRS-2676: Start of 'ora.ctssd' on 'srv2' succeeded
CRS-2676: Start of 'ora.ctssd' on 'srv1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'srv2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'srv2'
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'srv1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'srv1'
CRS-2676: Start of 'ora.asm' on 'srv1' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'srv1'
CRS-2676: Start of 'ora.storage' on 'srv1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'srv1'
CRS-2676: Start of 'ora.asm' on 'srv2' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'srv2'
CRS-2676: Start of 'ora.storage' on 'srv2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'srv2'
CRS-2676: Start of 'ora.crsd' on 'srv1' succeeded
CRS-2676: Start of 'ora.crsd' on 'srv2' succeeded

[root@srv1 trace]# 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 srv1 169.254.163.239 192.
168.10.1,STABLE
ora.cvu
1 ONLINE ONLINE srv2 STABLE
ora.mgmtdb
1 ONLINE OFFLINE srv1 Instance Shutdown,ST
ARTING
ora.oc4j
1 ONLINE ONLINE srv2 STABLE
ora.rac.acsrv.svc
1 OFFLINE OFFLINE STABLE
ora.rac.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE 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
--------------------------------------------------------------------------------

[root@srv1 trace]# srvctl config service -s staf -d rac

Service name: staf

Server pool:

Cardinality: 1

Disconnect: false

Service role: PRIMARY

Management policy: MANUAL

DTP transaction: false

AQ HA notifications: false

Global: false

Commit Outcome: false

Failover type: SELECT

Failover method: BASIC

TAF failover retries: 10

TAF failover delay: 5

Connection Load Balancing Goal: LONG

Runtime Load Balancing Goal: NONE

TAF policy specification: NONE

Edition:

Pluggable database name:

Maximum lag time: ANY

SQL Translation Profile:

Retention: 86400 seconds

Replay Initiation Time: 300 seconds

Session State Consistency:

GSM Flags: 0

Service is enabled

Preferred instances: rac1

Available instances: rac2

[root@srv1 trace]#

[root@srv1 trace]# srvctl modify service -s soesrv -db rac -policy automatic

[root@srv1 trace]# srvctl modify service -s acsrv -db rac -policy automatic

[root@srv1 trace]# srvctl modify service -s lbsrv -db rac -policy automatic

[root@srv1 trace]# srvctl modify service -s pretaf -db rac -policy automatic

[root@srv1 trace]# srvctl modify service -s soesrv -db rac -policy automatic

[root@srv1 trace]# srvctl modify service -s staf -db rac -policy automatic

[root@srv1 trace]# 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 srv1 169.254.163.239 192.

168.10.1,STABLE

ora.cvu

1 ONLINE ONLINE srv2 STABLE

ora.mgmtdb

1 ONLINE ONLINE srv1 Open,STABLE

ora.oc4j

1 ONLINE ONLINE srv2 STABLE

ora.rac.acsrv.svc

1 ONLINE ONLINE srv1 STABLE

ora.rac.db

1 ONLINE ONLINE srv1 Open,STABLE

2 ONLINE ONLINE srv2 Open,STABLE

ora.rac.lbsrv.svc

1 ONLINE ONLINE srv1 STABLE

2 ONLINE ONLINE srv2 STABLE

ora.rac.pretaf.svc

1 ONLINE ONLINE srv1 STABLE

ora.rac.pretaf_preconnect.svc

1 ONLINE ONLINE srv2 STABLE

ora.rac.soesrv.svc

1 ONLINE ONLINE srv1 STABLE

ora.rac.staf.svc

1 ONLINE ONLINE srv1 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

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

[root@srv1 trace]#

HOME

Monday, 5 August 2019

RMAN 12c 12.1.0.2.0 - Restore database preview and summary command

Rman Validate Database| Tablespace | Datafile command 12cR1

Friday, 2 August 2019

RAC 12c R1 Automatic | Manual and NORESTART Management Policies PART 2 -NorestartPolicy