Kategoria: Oracle rman

RECOVER COPY OF DATABASE WITH TAG ORA-19870 ORA-19625 ORA-27037

Opublikowano przez Wiech

— błędy wyskoczą jak nie mamy dostępu / zabierzemy zasób na, ktorym były kopie datafile-ów i chcemy zrobić recover copy of database with tag 'X’;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/15/2025 10:28:54
ORA-19870: error while restoring backup piece /zfssa/pool_backup/x_backup1/jq3mv282_1_1
ORA-19625: error identifying file /zfssa/pool_backup/x_backup1/data_D-x_I-1838446808_TS-UNDOTBS1_FNO-3_cg3ktclf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

— robimy crosschecka i ponawiamy bckp jak nie mamy już zasobu z kopią:

RMAN-20003: target database incarnation not found in recovery catalog

Opublikowano przez Wiech

podczas zabaw z restorem można trafić na RMAN-20003 (ustawiamy żądanego scn-a):

Starting recover at 2022-05-04 17:50:46
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/04/2022 17:50:46
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
——- ——- ——– —————- — ———- ———-
1 1 baza 2326959724 PARENT 1 2017-01-12 13:09:00
2 2 baza 2326959724 CURRENT 6974703964827 2022-05-04 12:39:48

ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer…

Opublikowano przez Wiech

— gdy podczas recovery wyskoczy:

RMAN-00571: =================================================
RMAN-00569: =========== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: =================================================
RMAN-03002: failure of recover command at 06/24/2022 14:30:32
ORA-19870: error while restoring backup piece bk_x_x_x
ORA-19507: failed to retrieve sequential file, handle=”bk_x_x_x”, parms=””
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
The function mm_retrieve_rs_info() failed with the error: RPC send operation failed; peer = 10.0.0.1:8550, errno = There is no process to read data written to a pipe. (1:5:32)

— oznacza, że zaliczyliśmy timeouta/zewrało połączenie – po prostu niefart, ale się nie przejmujemy i ponawiamy jeszcze raz recovera

RMAN-03002, RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

Opublikowano przez Wiech

— Podczas 2giego przebiegu odtwarzania możemy mieć bląd:

sql statement: alter session set nls_date_format = „DD-Mon-YYYY HH24:MI:SS”
executing command: SET until clause

RMAN-00571: =====================================
RMAN-00569: ====== ERROR MESSAGE STACK FOLLOWS ========
RMAN-00571: =====================================
RMAN-03002: failure of allocate command at 10/23/2020 14:50:07
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

— wysypał się bo robiliśmy juz open resetlogs i przy kolejnym przebiegu wracamy do momentu z przed open resetlogs…