Restore database on another server and change database name (Linux)

Hello, everyone! Today I will show you how to restore a database on another server with different directory structures and in the sequence change the database name. This operation is very common to tests procedure restore and recovery. I always used this process for many environments for evidences of restore.

Let’s start: Continue reading

Using restore points

Hello folks.

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:

Continue reading