"Как делается бекап"
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO "/u01/app/oracle/backup/%F";

CONFIGURE COMPRESSION ALGORITHM 'BASIC';

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 3;

crosscheck archivelog all;
crosscheck backup of database;
crosscheck backup of archivelog all;
crosscheck backup of controlfile;
crosscheck backupset;
crosscheck backup;
crosscheck copy;

delete noprompt expired backup of database;
delete noprompt expired backup of archivelog all;
delete noprompt expired backup;
delete noprompt expired backup of controlfile;
delete noprompt obsolete device type disk;
delete noprompt backup completed before 'sysdate -4';
delete noprompt archivelog all completed before 'sysdate -4';


run
{
allocate channel c1 type disk format '/u01/app/oracle/backup/rman_db_%T_%U.rman';
backup as compressed backupset full database include current controlfile;
release channel c1;
allocate channel c1 type disk maxpiecesize=2G
format '/u01/app/oracle/backup/rman_arc_%T_%U.rman';
sql "alter system archive log current";
delete noprompt archivelog all backed up 2 times to device type disk;
backup as compressed backupset archivelog all;
sql "alter database backup controlfile
to ''/u01/app/oracle/backup/rman_control.rman'' reuse";
release channel c1;
}

"Как восстанавливаю"На старом сервере узнать dbid:
select dbid from v$database;

На новом сервере:
rman target /
set dbid "указать номер dbid"
startup nomount
restore spfile to pfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora' from 'указать файл бекапа с spfile';
STARTUP FORCE NOMOUNT PFILE='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora';
RESTORE CONTROLFILE FROM 'указать файл бекапа controlfile';
ALTER DATABASE MOUNT;
CATALOG START WITH 'указать место хранения бекапа';
CROSSCHECK BACKUP;
RESTORE DATABASE;
RECOVER DATABASE;

MalishPo

не вышло :(
SQL> recover database using backup controlfile until cancel
ORA-00283: recovery session canceled due to errors
ORA-19912: cannot recover to target incarnation 2

Статус БДSQL> select status from v$instance;

STATUS
------------
MOUNTED

Попытка сбросаRMAN> set incarnation 1;

executing command: SET incarnation
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 04/27/2020 13:38:35
RMAN-00600: internal error, arguments [8516] [KEY] [2] [] []