Restoring from backups using RMAN (Recovery Manager) Example from Windows telegram chat


Oracle 11, Windows Server


Relevance:
30.03.2022


Yes, need to figure it out to understand what and how.


I'll try to describe my tasks, actions, and problems in detail.
I need to deploy a database from certain ready-made backups on a new server.
The number of disks and their names differ from the original server.

OS Windows
on the new server, Oracle 11g is installed and a database was created during installation. It is empty.
There is a full incremental backup level 0,
 and one subsequent incremental cumulative backup level 1
archive.log included in backup

Restoring the backups themselves (2 folders with backup files) to the server was done from tape.

A pfile was created from the spfile of the source database. Adjusted according to new paths and names.

On the new server, a series of commands was run to deploy from backup:

1. Startup nomount pfile -my pfile

2. RESTORE CONTROLFILE FROM  - backup file with control file.

3. ALTER DATABASE MOUNT;

4. catalog start with '\my backupset'

5. run the script

run {
SET NEWNAME FOR DATABASE   TO  '\oradata\my_sid\%b';
SET NEWNAME FOR tempfile  1 TO  '\oradata\my_sid\%b';
restore database;
switch datafile all;
switch tempfile all;
}

Today I see that restore was successful.


But I'm afraid to run the next step

run {
set until sequence xxxxx thread 1;
recover database;
} alter database open resetlogs;


https://t.me/oracledba_net/16630


See previous messages.