In many cases you probably need to restore a database to a point in the past.
Errors that won’t be reversed only with a flashback table or perhaps you do not have
the flashback feature configured for the database.
You can use restore point with a specific time in the past or using the SCN number.
To capture the SCN of the database you can the query below:
Today I will show you how to create a recovery catalog. If you have more than one databases to manage, you want to keep the backup information of your databases for a long time the recovery catalog might be justified. You can register an unlimited numbers of databases into the recovery catalog.
Connect to SQLPLUS with SYSDBA: