You should run a shell with nohup on Linux to ensure long-running tasks or processes continue to execute even if your user session is terminated or a network connection is lost.
For instance, when managing an Oracle Database, you often need to execute tasks that can take a significant amount of time, such as data loading, database backups, or maintenance operations.Continue reading “How to Run an Oracle SQL Script Using nohup on Linux”
In many cases you need to recover an Oracle database until time in the past or a point in time recovery because there was some kind of error or someone made a mistake.
First you need to shut down the database and start it in mount state.
Then you can run this command inside RMAN after connecting with rman target / or with a catalog if you also have one.
set until time "to_date('22-07-2019 16:30:00','DD-MM-YYYY HH24:MI:SS')";
alter database open resetlogs;
After this, it is advised that you do a full database backup.