سلام به همه دوستان

یکی از ویژگی هایی که از اوراکل 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.
و همچنین  با دستور زیر مشاهده میکنیم که مقدار 13 archive دیتاگارد ما gap دارد
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
فقط اگه در حین عملیات خطای زیر رو برخوردید در زمان recovery  راحل این خطا هم به این صورت که در زیر اجرا کردم هست
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
در داخل rman ‌که هستید دیتابیس را بیارید shutdown کرده و دوباره در حالت mount قرار بدید

خب حالا باز هدر دیتافایل هامونو چک میکنیم

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
. در standby هم باهم میبینیم
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.
خب حالا دیتابیس رو خاموش میکنیم تا controlfile  رو هم بازیابی کنیم
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
دیتابیس رو mount ‌میکنیم
RMAN> alter database mount;

released channel: ORA_DISK_1
Statement processed
نکته ای که باید دقت کنیم اینکه به علت اینکه ممکنه مسیر ها و نام فایل هامون در  دیتا گارد فرق بکنه ما اینجا مسیر رو catalog‌میکنیم تا controlfile مسیرهاش به روز بشه

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

خب حالا دستور switch رو میزنیم که تغییر نام فایل ها در کنترل فایل انجام بشه
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"

خب حالا دیتابیس رو open‌میکنیم
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.

موفق باشید