Oracle Database migration to a remote Data Protector cell--Best practices

19
As the last available archived log is the one with sequence 102, we perform our incomplete recovery
until sequence 103:
RMAN> run {
set until sequence = 103 ;
restore database ;
recover database ;
alter database open resetlogs;
}
III. Restore without Control File autobackup and No Recovery Catalog
In this case, we do not have a recovery catalog or Control File autobackup specified. This means,
RMAN has no information about where the Control File backup is located. It is not even aware if
there is even a backup of the Control File.
We also assume, no Data Protector managed Control File was taken. There is also no backup of the
Recovery Catalog available. This is one of the worst and recovery scenarios you can think about.
In this case, we need to proceed with a different approach:
Instead of relying on Oracle’s RMAN for locating the Control File backup, we need to provide RMAN
with the Backup Set holding the backup of the Control File.
As our data center A is not available, there is no way to access the Backup Session of the source
database. This would have provided us with the Backup set information where the Control File is
stored.
However, it should be relatively easy to find the session containing the Oracle Database backup from
ita022 as no more backups for this host should be available on this cell. Moreover, the Session ID of
the imported backup can also be retrieved from the Media Import Session.
We start querying the Data Protector Internal Database (IDB) for the session we just imported. There
are different ways to query the IDB to find out the session. Two of them are listed below:
• Get a list of the sessions in the IDB and filter them with the source hostname
• Query the IDB for backup sessions on a specific day. In our example, it just returns one.
hpu015:[/.root]# omnidb -session | grep ita022
2008/05/08-3 Backup Completed oracle.dba@ita022
hpu015:[/.root]# omnidb -session -type backup -since 2008/05/08 -detail
SessionID : 2008/05/08-3
Backup Specification: Oracle8 DB10g_online_FL
Session type : Backup (full)
Started : Thu May 8 05:39:18 2008
Finished : Thu May 8 05:43:24 2008
Status : Completed
Number of warnings : 0
Number of errors : 0
User : oracle
Group : dba
Host : ita022
Important Note:
It has to be mentioned that Data Protector has no information about which
files are contained in each of these backup objects.
Remember, RMAN is streaming the data to Data Protector’s channels, but
DP has no information about the files been sent through the channels. Only
RMAN does.