You often need to know the size of an Oracle database to move it from one server to another. Or just to know if your export or whatever is going to take a lot of space and time.
In this article I show you a simple way to calculate the size of your Oracle database.
Size of Oracle datafiles in GB
Continue reading “How to Check Database Size in Oracle 19c”
select sum(bytes)/(1024*1024*1024) G
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.