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

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...