Performing Flashback Restore on Oracle 19c Two Node RAC Servers

Share via:

Hello Readers,

In this article , we will see Performing Flashback Restore on Oracle 19c Two Node RAC Servers.

When the time of Testing applications or  Checking performance issues on databases , As a DBA we need to restore the databases to the previous states.

In Such cases these steps are very useful.

Pre-checks :

Steps : 

1.Check the database details. 

2.Check the Instance details.

3.Check FRA Size and Restore Points created on database.

4.Check User connections on database.

5.Shutdown the database using SRVCTL.

6.Mount the database  with only Single Instance using SRVCTL. 

7.Restore the database using flashback restore database command.

8.Open the database  with resetlogs.

9.Shutdown the database using SRVCTL.

10. Start the database with all the nodes using SRVCTL 

Post Checks : 

11.Check the status of Databases and Services .

12.Check the datafile status and any files need to recover .

13.Perform the log switch .

1. Check Database Details 

2.Check the Instance details 

3.Check FRA Size 

Check Restore points available on database

4.We need to check User connections made to database 

5.Shutdown the database using SRVCTL

6.Mount the database  with only Single Instance using SRVCTL. 

7.Restore the database using flashback restore database command.

8.Open the database  with resetlogs.

9.Shutdown the database using SRVCTL.

10. Start the database with all the nodes using SRVCTL 

11.Check the status of Databases and Services 

12.Check the datafiles status and any files need to recover 

Note : 

On the above lines No files need to recover and all the datafiles are Online.

13.Perform the log switch 

I hope above information was very helpful.

Thank you for giving your valuable time to read the above information.

Follow Me :

Ajay Kumar’s Linkedin : https://www.linkedin.com/in/ajay-kumar90/

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)
Loading...

Add Comment