RMAN-00571: =======================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: =======================================
RMAN-03009: failure of backup command on CH1 channel at 03/24/2020 10:45:23
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
— bieżemy tylko autobackup controla z backupa:
RUN {
ALLOCATE CHANNEL CH1 DEVICE TYPE 'SBT_TAPE’ maxopenfiles 1 connect 'sys/x’;
SEND DEVICE TYPE 'SBT_TAPE’ 'NSR_ENV=(NSR_SERVER=ntw.ora-600.com,NSR_CLIENT=db1.ora-600.com,NSR_DATA_VOLUME_POOL=LTO)’;
BACKUP FORMAT 'cntrl_%s_%p_%t’ CURRENT CONTROLFILE;
RELEASE CHANNEL CH1;
}
allocated channel: CH1
…
RMAN-00571: =======================================
RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: =======================================
RMAN-03009: failure of backup command on CH1 channel at 03/24/2020 10:45:23
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage
— sprawdzamy gdzie jest plik ze snapem controla:
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name DB are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/snapcf_DB1.f’; — default
— wywala sie bo w RAC-u snapcf musi byc na shareowanym zasobie – wrzucamy snapy na zasob acfs-a albo asm-a
— ACFS
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/SHARED_ACFS/snapcf_BAZA.f’;
— ASM
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_DB1.f’;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/snapcf_DB1.f’;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
— próbujemy jeszcze raz samego control-a
RUN {
ALLOCATE CHANNEL CH1 DEVICE TYPE 'SBT_TAPE’ maxopenfiles 1 connect 'sys/x’;
SEND DEVICE TYPE 'SBT_TAPE’ 'NSR_ENV=(NSR_SERVER=ntw.ora-600.com,NSR_CLIENT=db1.ora-600.com,NSR_DATA_VOLUME_POOL=LTO)’;
BACKUP FORMAT 'cntrl_%s_%p_%t’ CURRENT CONTROLFILE;
RELEASE CHANNEL CH1;
}
Starting Control File and SPFILE Autobackup at 24-MAR-20
piece handle=c-618204352-20200324-0a comment=API Version 2.0,MMS Version 9.0.1.0
Finished Control File and SPFILE Autobackup at 24-MAR-20
released channel: CH1
— czy się utworzył na ASM-ie:
ASMCMD> ls
snapcf_DB1.f
ASMCMD>