سلام به همه دوستان
یکی از ویژگی هایی که از اوراکل 12 به وجود اومد این بود تا حدودی نقش OS رو سعی کرد در خیلی از کارها حذف کنه
ما در نسخه قبل از 12 برای برطرف کردن gap های موجود در گارد که archivelog های آن موجود نباشه مجبور بودیم که چنیدین کار انجام بدیم مثل
1-در دیتابیس اصلی از controlfile بکاپ میگرفتیم بریا standby
2-در standby باید کوچکتری scn رو پیدا میکردیم و در دیتابیس اصلی یک backup incremental from SCN میگرفتیم
3-سپس باید هم کنترل فایل و هم بکاپمونو به سرور standby منتقل میکردیم و در سرورو standby باید در rman catalog انجام میدادیم
4-دیتابیس standby رو باید از حالت recovery خارج میکردیم و دیتابیس در حالت mount قرار میدادیم و سپس بکاپ رو باید برمیگردوندیم .
و در اخر هم MRP رو فعال میکردیم
اما در 12 به بعد کار خیلی اسون تر شده ما میتونیم فقط با یک دستور revover...from service عملیات sync شدن رو انجام بدیم به این صورت که خودش از کوچکتری scn شروع میکنه به بکاپ گرفتن در دیتابس اصلی و بعد از اتمام از روی شبکه برای دیتابیس standby ارسال میکنه و recovery رو انجام میده.
خب همین طور که در زیر میبینید در arlertlog گارد من این خطا رو دارم دریافت میکنم
PR00 (PID:14498): Fetching gap from T-1.S-187 to T-1.S-200 2019-04-10T17:24:32.999877+04:30 PR00 (PID:14498): FAL: Failed to request gap sequence PR00 (PID:14498): GAP - thread 1 sequence 187-200 PR00 (PID:14498): DBID 609790210 branch 1000029830 PR00 (PID:14498): FAL: All defined FAL servers have been attempted PR00 (PID:14498): ------------------------------------------------------------------------- PR00 (PID:14498): Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization PR00 (PID:14498): parameter is defined to a value that's sufficiently large PR00 (PID:14498): enough to maintain adequate log switch information to resolve PR00 (PID:14498): archived redo log gaps. PR00 (PID:14498): ------------------------------------------------------------------------- 2019-04-10T18:13:50.252395+04:30
SQL> select sequence#,thread#,applied,deleted from v$archived_log; SEQUENCE# THREAD# APPLIED DEL ---------- ---------- --------- --- 181 1 YES YES 182 1 YES YES 183 1 YES YES 184 1 YES NO 185 1 YES NO 186 1 YES NO 201 1 NO NO 202 1 NO NO 203 1 NO NO 204 1 NO NO 205 1 NO NO 11 rows selected.
SQL> select * from v$archive_gap; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE# CON_ID ---------- ------------- -------------- ---------- 1 187 200 1
با بررسی های که در سرور اصلی میکنیم به این نتیجه رسیدیم که archivelog های ما پاک شدن و باید بکاپ بگیریم
خب ابتدا اگه نگاهی به snc دیتا فایل هامونو ببینیم متوجه میشیم که فقط دیتابیس seed هدر یکسانی داره و بقیه باهم فرق داره
CDB$ROOT@ATMDB> select HXFIL File_num,substr(HXFNM,1,40),fhscn from x$kcvfh; FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 1 +DATA/ATMDB/DATAFILE/system.257.10000297 4913294 3 +DATA/ATMDB/DATAFILE/sysaux.258.10000297 4913294 4 +DATA/ATMDB/DATAFILE/undotbs1.259.100002 4913294 5 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 6 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 7 +DATA/ATMDB/DATAFILE/users.260.100002978 4913294 8 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 9 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4913294 10 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4913294 11 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4913294 12 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4913294 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 13 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 14 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 15 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 16 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 21 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 22 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 23 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 24 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 29 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 30 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 31 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 32 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 33 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 34 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4913294 35 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4913294 36 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4913294 37 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4913294 38 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4913294 39 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 40 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 41 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 42 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 43 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 44 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 45 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 46 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4913294 47 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 48 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 49 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 50 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 51 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 52 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 53 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 54 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 55 +DATA/ATMDB/DATAFILE/globaltbs.327.10051 4913294 46 rows selected.
حالا هیمین دستور رو در گاردمون میزنیم
SQL> select HXFIL File_num,substr(HXFNM,1,40),fhscn from x$kcvfh; FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 1 +DATA/DRATMDB/DATAFILE/system.307.100523 4904810 3 +DATA/DRATMDB/DATAFILE/sysaux.308.100523 4904810 4 +DATA/DRATMDB/DATAFILE/undotbs1.309.1005 4904810 5 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 6 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 7 +DATA/DRATMDB/DATAFILE/users.303.1005239 4904810 8 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 9 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4904810 10 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4904810 11 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4904810 12 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4904810 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 13 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 14 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 15 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 16 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 21 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 22 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 23 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 24 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 29 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 30 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 31 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 32 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 33 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 34 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4904810 35 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4904810 36 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4904810 37 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4904810 38 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4904810 39 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 40 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 41 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 42 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 43 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 44 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 45 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 46 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4904810 47 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 48 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 49 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 50 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 51 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 52 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 53 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 54 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 55 +DATA/DRATMDB/DATAFILE/globaltbs.319.100 4904810
خب current_scn دیتابیس گاردمون رو هم نگاه میکنیم
SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN ----------- 4904809
خب حالا در دیتابس گاردمون به rman متصل میشیم و شروع میکنیم به sync کردن
RMAN> recover database from service atmdb noredo using compressed backupset; Starting recover at 10-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=502 device type=DISK skipping datafile 5; already restored to SCN 1546460 skipping datafile 6; already restored to SCN 1546460 skipping datafile 8; already restored to SCN 1546460 skipping datafile 13; already restored to SCN 4677056 skipping datafile 14; already restored to SCN 4677056 skipping datafile 15; already restored to SCN 4677056 skipping datafile 16; already restored to SCN 4677056 skipping datafile 21; already restored to SCN 4677062 skipping datafile 22; already restored to SCN 4677062 skipping datafile 23; already restored to SCN 4677062 skipping datafile 24; already restored to SCN 4677062 skipping datafile 29; already restored to SCN 4677068 skipping datafile 30; already restored to SCN 4677068 skipping datafile 31; already restored to SCN 4677068 skipping datafile 32; already restored to SCN 4677068 skipping datafile 33; already restored to SCN 4677056 skipping datafile 39; already restored to SCN 4677068 skipping datafile 40; already restored to SCN 4677074 skipping datafile 41; already restored to SCN 4677074 skipping datafile 42; already restored to SCN 4677074 skipping datafile 43; already restored to SCN 4677080 skipping datafile 44; already restored to SCN 4677080 skipping datafile 45; already restored to SCN 4677080 skipping datafile 47; already restored to SCN 4677086 skipping datafile 48; already restored to SCN 4677086 skipping datafile 49; already restored to SCN 4677086 skipping datafile 50; already restored to SCN 4552203 skipping datafile 51; already restored to SCN 4552203 skipping datafile 52; already restored to SCN 4552203 skipping datafile 53; already restored to SCN 4677086 skipping datafile 54; already restored to SCN 4677086 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00001: +DATA/DRATMDB/DATAFILE/system.307.1005239033 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00003: +DATA/DRATMDB/DATAFILE/sysaux.308.1005239041 channel ORA_DISK_1: restore complete, elapsed time: 00:00:04 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00004: +DATA/DRATMDB/DATAFILE/undotbs1.309.1005239043 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00007: +DATA/DRATMDB/DATAFILE/users.303.1005239051 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00009: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/system.314.1005239053 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00010: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/sysaux.313.1005239057 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00011: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/undotbs1.312.1005239061 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00012: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/users.311.1005239061 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00034: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/system.278.1005239091 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00035: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/sysaux.277.1005239095 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00036: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/undotbs1.276.1005239097 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00037: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/intbank_data.275.1005239099 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00038: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/fakari.274.1005239101 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00046: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/kooktbs.266.1005239143 channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00055: +DATA/DRATMDB/DATAFILE/globaltbs.319.1005239161 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished recover at 10-APR-19
skipping datafile 52; already restored to SCN 4552203 skipping datafile 53; already restored to SCN 4677086 skipping datafile 54; already restored to SCN 4677086 channel ORA_DISK_1: starting incremental datafile backup set restore channel ORA_DISK_1: using compressed network backup set from service atmdb destination for restore of datafile 00001: +DATA/DRATMDB/DATAFILE/system.307.1005239033 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/10/2019 18:42:20 ORA-19849: error while reading backup piece from service atmdb ORA-19573: cannot obtain exclusive enqueue for datafile 1 ORA-45909: restore, recover or block media recovery may be in progress ORA-19660: some files in the backup set could not be verified ORA-19661: datafile 1 could not be verified ORA-19849: error while reading backup piece from service atmdb ORA-19573: cannot obtain exclusive enqueue for datafile 1 ORA-45909: restore, recover or block media recovery may be in progress
RMAN> shutdown immediate; database dismounted Oracle instance shut down RMAN> startup mount; connected to target database (not started) Oracle instance started database mounted Total System Global Area 3808426792 bytes Fixed Size 8903464 bytes Variable Size 989855744 bytes Database Buffers 2801795072 bytes Redo Buffers 7872512 bytes
خب حالا باز هدر دیتافایل هامونو چک میکنیم
CDB$ROOT@ATMDB> select HXFIL File_num,substr(HXFNM,1,40),fhscn from x$kcvfh; FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 1 +DATA/ATMDB/DATAFILE/system.257.10000297 4918061 3 +DATA/ATMDB/DATAFILE/sysaux.258.10000297 4918063 4 +DATA/ATMDB/DATAFILE/undotbs1.259.100002 4918071 5 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 6 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 7 +DATA/ATMDB/DATAFILE/users.260.100002978 4918075 8 +DATA/ATMDB/64A52F53A7693286E053CDA9E80A 1546460 9 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4918078 10 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4918081 11 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4918086 12 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4918089 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 13 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 14 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 15 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 16 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 21 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 22 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 23 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 24 +DATA/ATMDB/81CB41E668B624DAE0530A01000A 4677062 29 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 30 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 31 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 32 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 33 +DATA/ATMDB/81AEDFF3025C2508E0530A01000A 4677056 34 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4918092 35 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4918097 36 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4918100 37 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4918105 38 +DATA/ATMDB/81ADBC7C185B7319E0530A01000A 4918110 39 +DATA/ATMDB/81CAF86A2D121661E0530A01000A 4677068 40 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 41 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 42 +DATA/ATMDB/86018EEAAB1818F9E0530A01000A 4677074 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 43 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 44 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 45 +DATA/ATMDB/86018EEAAB1C18F9E0530A01000A 4677080 46 +DATA/ATMDB/850EE7FD4D054F9AE0530A01000A 4918113 47 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 48 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 49 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 50 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 51 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 52 +DATA/ATMDB/86018EEAAB2218F9E0530A01000A 4552203 53 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 54 +DATA/ATMDB/86018EEAAB1F18F9E0530A01000A 4677086 55 +DATA/ATMDB/DATAFILE/globaltbs.327.10051 4918116
SQL> select HXFIL File_num,substr(HXFNM,1,40),fhscn from x$kcvfh; FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 1 +DATA/DRATMDB/DATAFILE/system.307.100523 4918061 3 +DATA/DRATMDB/DATAFILE/sysaux.308.100523 4918063 4 +DATA/DRATMDB/DATAFILE/undotbs1.309.1005 4918071 5 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 6 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 7 +DATA/DRATMDB/DATAFILE/users.303.1005239 4918075 8 +DATA/DRATMDB/81ADA5E315E66798E0530A0100 1546460 9 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4918078 10 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4918081 11 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4918086 12 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4918089 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 13 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 14 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 15 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 16 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 21 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 22 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 23 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 24 +DATA/DRATMDB/81CB41E668B624DAE0530A0100 4677062 29 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 30 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 31 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 32 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 33 +DATA/DRATMDB/81AEDFF3025C2508E0530A0100 4677056 34 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4918092 35 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4918097 36 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4918100 37 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4918105 38 +DATA/DRATMDB/81ADBC7C185B7319E0530A0100 4918110 39 +DATA/DRATMDB/81CAF86A2D121661E0530A0100 4677068 40 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 41 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 42 +DATA/DRATMDB/86018EEAAB1818F9E0530A0100 4677074 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 43 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 44 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 45 +DATA/DRATMDB/86018EEAAB1C18F9E0530A0100 4677080 46 +DATA/DRATMDB/850EE7FD4D054F9AE0530A0100 4918113 47 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 48 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 49 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 50 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 51 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 52 +DATA/DRATMDB/86018EEAAB2218F9E0530A0100 4552203 53 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 FILE_NUM SUBSTR(HXFNM,1,40) FHSCN ---------- ---------------------------------------- -------------------- 54 +DATA/DRATMDB/86018EEAAB1F18F9E0530A0100 4677086 55 +DATA/DRATMDB/DATAFILE/globaltbs.319.100 4918116 46 rows selected.
RMAN> restore standby controlfile from service atmdb; Starting restore at 10-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=493 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: using network backup set from service atmdb channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:02 output file name=+DATA/DRATMDB/CONTROLFILE/current.306.1005239021 output file name=+FRA/DRATMDB/CONTROLFILE/current.383.1005239023 Finished restore at 10-APR-19
RMAN> alter database mount; released channel: ORA_DISK_1 Statement processed
RMAN> CATALOG START WITH '+DATA/DRATMDB/'; Starting implicit crosscheck backup at 10-APR-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=831 device type=DISK Crosschecked 4 objects Finished implicit crosscheck backup at 10-APR-19 Starting implicit crosscheck copy at 10-APR-19 using channel ORA_DISK_1 Finished implicit crosscheck copy at 10-APR-19 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_184.373.1005239337 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_185.372.1005239339 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_186.371.1005239873 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_201.370.1005240151 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_202.369.1005243231 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_203.368.1005243233 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_204.367.1005243233 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_205.366.1005243233 File Name: +FRA/DRATMDB/ARCHIVELOG/2019_04_10/thread_1_seq_207.365.1005245177 File Name: +FRA/DRATMDB/CONTROLFILE/current.258.1004986085 searching for all files that match the pattern +DATA/DRATMDB/ List of Files Unknown to the Database ===================================== File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/system.262.1005239151 File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/sysaux.261.1005239155 File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/undotbs1.316.1005239159 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/system.265.1005239143 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/sysaux.264.1005239147 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/undotbs1.263.1005239151 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs.317.1005239159 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs2.318.1005239161 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/system.269.1005239135 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/sysaux.268.1005239139 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/undotbs1.267.1005239141 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/system.272.1005239127 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/sysaux.271.1005239131 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/undotbs1.270.1005239133 File Name: +DATA/DRATMDB/ONLINELOG/group_1.291.1004986181 File Name: +DATA/DRATMDB/ONLINELOG/group_2.292.1004986183 File Name: +DATA/DRATMDB/ONLINELOG/group_3.293.1004986183 File Name: +DATA/DRATMDB/ONLINELOG/group_4.294.1004986183 File Name: +DATA/DRATMDB/ONLINELOG/group_5.295.1004986185 File Name: +DATA/DRATMDB/ONLINELOG/group_10.296.1004986185 File Name: +DATA/DRATMDB/ONLINELOG/group_11.297.1004986187 File Name: +DATA/DRATMDB/ONLINELOG/group_12.298.1004986187 File Name: +DATA/DRATMDB/ONLINELOG/group_13.299.1004986187 File Name: +DATA/DRATMDB/ONLINELOG/group_14.300.1004986189 File Name: +DATA/DRATMDB/ONLINELOG/group_15.301.1004986189 File Name: +DATA/DRATMDB/ONLINELOG/group_16.302.1004986191 File Name: +DATA/DRATMDB/ONLINELOG/group_1.320.1005239173 File Name: +DATA/DRATMDB/ONLINELOG/group_2.321.1005239173 File Name: +DATA/DRATMDB/ONLINELOG/group_3.322.1005239175 File Name: +DATA/DRATMDB/ONLINELOG/group_4.323.1005239175 File Name: +DATA/DRATMDB/ONLINELOG/group_5.324.1005239177 File Name: +DATA/DRATMDB/ONLINELOG/group_10.325.1005239179 File Name: +DATA/DRATMDB/ONLINELOG/group_11.326.1005239179 File Name: +DATA/DRATMDB/ONLINELOG/group_12.327.1005239179 File Name: +DATA/DRATMDB/ONLINELOG/group_13.328.1005239181 File Name: +DATA/DRATMDB/ONLINELOG/group_14.329.1005239183 File Name: +DATA/DRATMDB/ONLINELOG/group_15.330.1005239183 File Name: +DATA/DRATMDB/ONLINELOG/group_16.331.1005239185 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/system.278.1005239091 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/sysaux.277.1005239095 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/undotbs1.276.1005239097 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/intbank_data.275.1005239099 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/kooktbs.266.1005239143 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/system.283.1005239081 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/sysaux.282.1005239085 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/undotbs1.281.1005239087 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/intbank_data.280.1005239089 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/pdb_intbank_default.273.1005239125 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/system.287.1005239073 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/sysaux.286.1005239075 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/undotbs1.285.1005239079 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/intbank_data.284.1005239079 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/system.310.1005239063 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/sysaux.290.1005239067 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/undotbs1.289.1005239069 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/users.288.1005239071 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/pdb2tbs.279.1005239091 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/system.314.1005239053 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/sysaux.313.1005239057 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/undotbs1.312.1005239061 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/users.311.1005239061 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/fakari.274.1005239101 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/system.305.1005239045 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/sysaux.304.1005239049 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/undotbs1.315.1005239053 File Name: +DATA/DRATMDB/DATAFILE/system.307.1005239033 File Name: +DATA/DRATMDB/DATAFILE/sysaux.308.1005239041 File Name: +DATA/DRATMDB/DATAFILE/undotbs1.309.1005239043 File Name: +DATA/DRATMDB/DATAFILE/users.303.1005239051 File Name: +DATA/DRATMDB/DATAFILE/globaltbs.319.1005239161 File Name: +DATA/DRATMDB/PARAMETERFILE/spfile.260.1005238985 File Name: +DATA/DRATMDB/CONTROLFILE/current.257.1004980757 File Name: +DATA/DRATMDB/CONTROLFILE/current.259.1004986047 File Name: +DATA/DRATMDB/CONTROLFILE/current.258.1005238985 Do you really want to catalog the above files (enter YES or NO)? yes cataloging files... cataloging done List of Cataloged Files ======================= File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/system.262.1005239151 File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/sysaux.261.1005239155 File Name: +DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/undotbs1.316.1005239159 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/system.265.1005239143 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/sysaux.264.1005239147 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/undotbs1.263.1005239151 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs.317.1005239159 File Name: +DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs2.318.1005239161 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/system.269.1005239135 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/sysaux.268.1005239139 File Name: +DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/undotbs1.267.1005239141 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/system.272.1005239127 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/sysaux.271.1005239131 File Name: +DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/undotbs1.270.1005239133 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/system.278.1005239091 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/sysaux.277.1005239095 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/undotbs1.276.1005239097 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/intbank_data.275.1005239099 File Name: +DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/kooktbs.266.1005239143 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/system.283.1005239081 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/sysaux.282.1005239085 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/undotbs1.281.1005239087 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/intbank_data.280.1005239089 File Name: +DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/pdb_intbank_default.273.1005239125 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/system.287.1005239073 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/sysaux.286.1005239075 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/undotbs1.285.1005239079 File Name: +DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/intbank_data.284.1005239079 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/system.310.1005239063 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/sysaux.290.1005239067 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/undotbs1.289.1005239069 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/users.288.1005239071 File Name: +DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/pdb2tbs.279.1005239091 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/system.314.1005239053 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/sysaux.313.1005239057 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/undotbs1.312.1005239061 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/users.311.1005239061 File Name: +DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/fakari.274.1005239101 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/system.305.1005239045 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/sysaux.304.1005239049 File Name: +DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/undotbs1.315.1005239053 File Name: +DATA/DRATMDB/DATAFILE/system.307.1005239033 File Name: +DATA/DRATMDB/DATAFILE/sysaux.308.1005239041 File Name: +DATA/DRATMDB/DATAFILE/undotbs1.309.1005239043 File Name: +DATA/DRATMDB/DATAFILE/users.303.1005239051 File Name: +DATA/DRATMDB/DATAFILE/globaltbs.319.1005239161 List of Files Which Were Not Cataloged ======================================= File Name: +DATA/DRATMDB/ONLINELOG/group_1.291.1004986181 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_2.292.1004986183 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_3.293.1004986183 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_4.294.1004986183 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_5.295.1004986185 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_10.296.1004986185 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_11.297.1004986187 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_12.298.1004986187 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_13.299.1004986187 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_14.300.1004986189 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_15.301.1004986189 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_16.302.1004986191 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_1.320.1005239173 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_2.321.1005239173 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_3.322.1005239175 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_4.323.1005239175 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_5.324.1005239177 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_10.325.1005239179 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_11.326.1005239179 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_12.327.1005239179 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_13.328.1005239181 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_14.329.1005239183 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_15.330.1005239183 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/ONLINELOG/group_16.331.1005239185 RMAN-07529: Reason: catalog is not supported for this file type File Name: +DATA/DRATMDB/PARAMETERFILE/spfile.260.1005238985 RMAN-07518: Reason: Foreign database file DBID: 0 Database Name: File Name: +DATA/DRATMDB/CONTROLFILE/current.257.1004980757 RMAN-07517: Reason: The file header is corrupted File Name: +DATA/DRATMDB/CONTROLFILE/current.259.1004986047 RMAN-07517: Reason: The file header is corrupted File Name: +DATA/DRATMDB/CONTROLFILE/current.258.1005238985 RMAN-07517: Reason: The file header is corrupted
RMAN> SWITCH DATABASE TO COPY; datafile 1 switched to datafile copy "+DATA/DRATMDB/DATAFILE/system.307.1005239033" datafile 3 switched to datafile copy "+DATA/DRATMDB/DATAFILE/sysaux.308.1005239041" datafile 4 switched to datafile copy "+DATA/DRATMDB/DATAFILE/undotbs1.309.1005239043" datafile 5 switched to datafile copy "+DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/system.305.1005239045" datafile 6 switched to datafile copy "+DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/sysaux.304.1005239049" datafile 7 switched to datafile copy "+DATA/DRATMDB/DATAFILE/users.303.1005239051" datafile 8 switched to datafile copy "+DATA/DRATMDB/81ADA5E315E66798E0530A01000ADFEC/DATAFILE/undotbs1.315.1005239053" datafile 9 switched to datafile copy "+DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/system.314.1005239053" datafile 10 switched to datafile copy "+DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/sysaux.313.1005239057" datafile 11 switched to datafile copy "+DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/undotbs1.312.1005239061" datafile 12 switched to datafile copy "+DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/users.311.1005239061" datafile 13 switched to datafile copy "+DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/system.310.1005239063" datafile 14 switched to datafile copy "+DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/sysaux.290.1005239067" datafile 15 switched to datafile copy "+DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/undotbs1.289.1005239069" datafile 16 switched to datafile copy "+DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/users.288.1005239071" datafile 21 switched to datafile copy "+DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/system.287.1005239073" datafile 22 switched to datafile copy "+DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/sysaux.286.1005239075" datafile 23 switched to datafile copy "+DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/undotbs1.285.1005239079" datafile 24 switched to datafile copy "+DATA/DRATMDB/81CB41E668B624DAE0530A01000A4B00/DATAFILE/intbank_data.284.1005239079" datafile 29 switched to datafile copy "+DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/system.283.1005239081" datafile 30 switched to datafile copy "+DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/sysaux.282.1005239085" datafile 31 switched to datafile copy "+DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/undotbs1.281.1005239087" datafile 32 switched to datafile copy "+DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/intbank_data.280.1005239089" datafile 33 switched to datafile copy "+DATA/DRATMDB/81AEDFF3025C2508E0530A01000AE9DB/DATAFILE/pdb2tbs.279.1005239091" datafile 34 switched to datafile copy "+DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/system.278.1005239091" datafile 35 switched to datafile copy "+DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/sysaux.277.1005239095" datafile 36 switched to datafile copy "+DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/undotbs1.276.1005239097" datafile 37 switched to datafile copy "+DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/intbank_data.275.1005239099" datafile 38 switched to datafile copy "+DATA/DRATMDB/81ADBC7C185B7319E0530A01000A3B17/DATAFILE/fakari.274.1005239101" datafile 39 switched to datafile copy "+DATA/DRATMDB/81CAF86A2D121661E0530A01000AF377/DATAFILE/pdb_intbank_default.273.1005239125" datafile 40 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/system.272.1005239127" datafile 41 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/sysaux.271.1005239131" datafile 42 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1818F9E0530A01000A23EA/DATAFILE/undotbs1.270.1005239133" datafile 43 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/system.269.1005239135" datafile 44 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/sysaux.268.1005239139" datafile 45 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1C18F9E0530A01000A23EA/DATAFILE/undotbs1.267.1005239141" datafile 46 switched to datafile copy "+DATA/DRATMDB/850EE7FD4D054F9AE0530A01000A9F85/DATAFILE/kooktbs.266.1005239143" datafile 47 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/system.265.1005239143" datafile 48 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/sysaux.264.1005239147" datafile 49 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/undotbs1.263.1005239151" datafile 50 switched to datafile copy "+DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/system.262.1005239151" datafile 51 switched to datafile copy "+DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/sysaux.261.1005239155" datafile 52 switched to datafile copy "+DATA/DRATMDB/86018EEAAB2218F9E0530A01000A23EA/DATAFILE/undotbs1.316.1005239159" datafile 53 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs.317.1005239159" datafile 54 switched to datafile copy "+DATA/DRATMDB/86018EEAAB1F18F9E0530A01000A23EA/DATAFILE/mehditbs2.318.1005239161" datafile 55 switched to datafile copy "+DATA/DRATMDB/DATAFILE/globaltbs.319.1005239161"
RMAN> alter database open; Statement processed
SQL> select PROCESS,status,thread#,sequence#,block#,blocks from v$managed_standby; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- RFS IDLE 1 0 0 0 DGRD ALLOCATED 0 0 0 0 ARCH CONNECTED 0 0 0 0 DGRD ALLOCATED 0 0 0 0 ARCH CLOSING 1 213 1 132 ARCH CLOSING 1 211 6144 1720 ARCH CLOSING 1 212 4096 1616 RFS IDLE 1 214 638 1 RFS IDLE 0 0 0 0 RFS IDLE 0 0 0 0 MRP0 APPLYING_LOG 1 214 638 409600 11 rows selected.