Disclaimer

Tuesday, 3 December 2024

How to restore OLR from Backup in Oracle RAC

 

Backup current OLR and all available OLR backups

How to take Manual backup of OLR?

# ocrconfig -local -manualbackup
rac01.samik.com     2024/11/30 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/backup_20241201_122220.olr 2204791787


How to find the OLR auto backup?

[root@rac01.samik.com ~]# ocrconfig -local -showbackup auto

rac01.samik.com     2024/12/01 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/autobackup_20241201_112336.olr     2204791795
rac01.samik.com     2024/11/30 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/autobackup_20241130_112336.olr     2204791795



Verify available backups

# ocrconfig -local -showbackup

rac01.samik.com     2024/12/01 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/autobackup_20241201_112336.olr     2204791795
rac01.samik.com     2024/11/30 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/autobackup_20241130_112336.olr     2204791795
rac01.samik.com     2024/11/30 11:23:36     /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/backup_20241201_122220.olr 2204791787




Restore a  OLR from backup


Shutdown CRS and check that ohasd.bin process is not running and restore OLR

Step1:- Stop the cluster on the specific node
# crsctl stop crs


Step2:- Run the below command to restore OLR
# ocrconfig -local -restore  /applications/oracle/g19.3.0/grid_base/crsdata/rac01.samik.com/olr/backup_20241201_122220.olr


Step3:- Start the Cluster
# crsctl start crs





No comments:

Post a Comment

How to recovery PDB when PDB database is dropped in Oracle

  How to recovery PDB when PDB database is dropped :) [oracle@rac01 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 21.0.0.0.0 - Product...