How to Run an Oracle SQL Script Using nohup on Linux

time lapse photography of river

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”

Oracle RMAN Recover Database Until Time

body of water between green leaf trees

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.

shutdown immediate
startup mount

Then you can run this command inside RMAN after connecting with rman target / or with a catalog if you also have one.

run {
set until time "to_date('22-07-2019 16:30:00','DD-MM-YYYY HH24:MI:SS')";
restore database;
recover database;
alter database open resetlogs;

After this, it is advised that you do a full database backup.