So as you should know Oracle Database Server 12c release 1 is finally out there and this is my first post about it.
I've just finished to download some fundamental documents from Oracle website such as "2 Day DBA", "New Features Guide", "Concepts Guide", "Upgrade Guide", "Administrator's Guide" (1360 pages!!! (more...)
Imagine someone has deleted your spfile or you have modified it in depth that you are now unable to even startup your database.
Your only option
is to restore your spfile and this step is easy if you have not forgot to setup your RMAN environment to use the AUTOBACKUP (more...)
When you don't know the date and time to which you want to recover the database, SCN-based incomplete recovery
could be taken into consideration especially if you are able to retrieve a particular SCN.
In this scenario I will perform
a SCN-based incomplete recovery after I have used the Oracle (more...)
Every incomplete recovery is followed by a resetlogs command before opening the database: each time you use a resetlogs command, a new incarnation
of the database is created.
While performing incomplete recovery it should be known the target point at which the recovery process needs to terminate: there are several (more...)
Sometimes it could happen to retain a backup for a very long time, even forever that is it should be maintained until you manually remove it.
This post is related on how to keep a backup forever.
In particular the syntax to have a backup retained forever is using the (more...)
To simulate other RMAN scenarios I need to create a recovery catalog.
This post so will be related on the basic steps to create the user account managing the recovery catalog and the creation of the recovery catalog itself.
The first step is to create the recovery catalog user account.
Today I want to resynchronize a duplicated database: the source database is PROD @vsi08 server and the target database will have the same SID, but located @vsi10 server.
All the steps to set up a duplicated database are already explained in this
Let's duplicate for the first time (more...)