This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Dec 13, 2012 5:00 AM by EdStevens RSS

Oracle Restore

979144 Newbie
Currently Being Moderated
Dear Gurus,

Issue: Unable to recover database from an online backup

We have a production Oracle 10 G database ; Solaris. An online backup is performed everyday (No offline backups as it a HA environment). We are trying to validate the online backup of the production database by restoring it onto another test oracle database.

Backup execution:
- Alter database begin backup is issued in the production database
- The oracle database disks are split and a copy is mounted to another server. This is the location from where the backup is taken
- Alter database endbackup is issued in the production database. (As a split copy is used for the database backup, the time frame between 'begin backup and 'end backup' is only about 3 mins.)

Backup validation:
- We wiped out the existing data from the test database. Basically, erased the datafiles from the filesystem.
- Restored the online backup of the production database to the test database
- Restored the control file
- Restored the archived logs that were generated from the time the online backup was started until the backup ended
- Take the database off from the backup mode (As the 'end backup' is issued only in the production database, the restored files are in the backup mode)
- Tried to recover the database using 'recover database until cancel' . The result is that we are continuously being asked to supply the redo logs and when we get an error that the database needs more recovery before it can be opened if we cancel the recovery process.

The SCN numbers from the V$datafile and V$datafile_header is higher than the SCN number in the V$database.

select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
--------------------
49577611114


select checkpoint_change# from v$datafile_header;
CHECKPOINT_CHANGE#
--------------------
49577611114

select checkpoint_change# from v$database;
CHECKPOINT_CHANGE#
--------------------
49577193822

The system SCN is lower to those in the v$datafile and v$datafile_header. Any ideas on where the problem could be? Thanks for your time

Regards,
  • 1. Re: Oracle Restore
    moreajays Pro
    Currently Being Moderated
    Hi,

    try using "recover database using backup controlfile until cancel;" pass cancel from where you dont have further archives , let me know if it ask for system file recovery or says "Media Recovery Complete" & provide o/p of below

    select distinct checkpoint_change# from v$datafile_header;
    select hxfil file_id, fhscn scn, fhthr thread, fhrba_seq sequence, fhsta status from x$kcvfh;
    select distinct fhscn from x$kcvfh;
    select hxfil file_id, fhtnm tablespace_name from x$kcvfh;
    alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
    set feedback on
    set heading on
    set pagesize 1000
    set linesize 175
    column checkpoint_change# format 999999999999999999999
    select status, checkpoint_change#, fuzzy,
    to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
    count(*)
    from v$datafile_header
    group by status, checkpoint_change#, fuzzy, checkpoint_time
    order by status, checkpoint_change#, fuzzy, checkpoint_time;
    Thanks,
    Ajay More
    http://moreajays.blogspot.com
  • 2. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi Ajay,

    Thanks for the reply. We tried the recover using the backup controlfile but failed to open the database. My suspicion is largely on the system SCN. The test database had data in it before we wiped it off. So, I believe the test database had an SCN number at that point in time. We then restored the online backup from our production database and restored to the test database server. Now, these datafiles' SCN would be different to the SCN of the test database and hence the trouble in bringing the DB up. Pls correct me if I am wrong.

    The output of the script is quiet lengthy. pls bear with me. Thanks Ajay.

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning and Data Mining options


    CHECKPOINT_CHANGE#
    ------------------
         4.9578E+10


    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         1 49577611114          1     278472     8196
         2 49577611114          1     278472     4
         3 49577611114          1     278472     4
         4 49577611114          1     278472     4
         5 49577611114          1     278472     4
         6 49577611114          1     278472     4
         7 49577611114          1     278472     4
         8 49577611114          1     278472     4
         9 49577611114          1     278472     4
         10 49577611114          1     278472     4
         11 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         12 49577611114          1     278472     4
         13 49577611114          1     278472     4
         14 49577611114          1     278472     4
         15 49577611114          1     278472     4
         16 49577611114          1     278472     4
         17 49577611114          1     278472     4
         18 49577611114          1     278472     4
         19 49577611114          1     278472     4
         20 49577611114          1     278472     4
         21 49577611114          1     278472     4
         22 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         23 49577611114          1     278472     4
         24 49577611114          1     278472     4
         25 49577611114          1     278472     4
         26 49577611114          1     278472     4
         27 49577611114          1     278472     4
         28 49577611114          1     278472     4
         29 49577611114          1     278472     4
         30 49577611114          1     278472     4
         31 49577611114          1     278472     4
         32 49577611114          1     278472     4
         33 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         34 49577611114          1     278472     4
         35 49577611114          1     278472     4
         36 49577611114          1     278472     4
         37 49577611114          1     278472     4
         38 49577611114          1     278472     4
         39 49577611114          1     278472     4
         40 49577611114          1     278472     4
         41 49577611114          1     278472     4
         42 49577611114          1     278472     4
         43 49577611114          1     278472     4
         44 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         45 49577611114          1     278472     4
         46 49577611114          1     278472     4
         47 49577611114          1     278472     4
         48 49577611114          1     278472     4
         49 49577611114          1     278472     4
         50 49577611114          1     278472     4
         51 49577611114          1     278472     4
         52 49577611114          1     278472     4
         53 49577611114          1     278472     4
         54 49577611114          1     278472     4
         55 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         56 49577611114          1     278472     4
         57 49577611114          1     278472     4
         58 49577611114          1     278472     4
         59 49577611114          1     278472     4
         60 49577611114          1     278472     4
         61 49577611114          1     278472     4
         62 49577611114          1     278472     4
         63 49577611114          1     278472     4
         64 49577611114          1     278472     4
         65 49577611114          1     278472     4
         66 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         67 49577611114          1     278472     4
         68 49577611114          1     278472     4
         69 49577611114          1     278472     4
         70 49577611114          1     278472     4
         71 49577611114          1     278472     4
         72 49577611114          1     278472     4
         73 49577611114          1     278472     4
         74 49577611114          1     278472     4
         75 49577611114          1     278472     4
         76 49577611114          1     278472     4
         77 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         78 49577611114          1     278472     4
         79 49577611114          1     278472     4
         80 49577611114          1     278472     4
         81 49577611114          1     278472     4
         82 49577611114          1     278472     4
         83 49577611114          1     278472     4
         84 49577611114          1     278472     4
         85 49577611114          1     278472     4
         86 49577611114          1     278472     4
         87 49577611114          1     278472     4
         88 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
         89 49577611114          1     278472     4
         90 49577611114          1     278472     4
         91 49577611114          1     278472     4
         92 49577611114          1     278472     4
         93 49577611114          1     278472     4
         94 49577611114          1     278472     4
         95 49577611114          1     278472     4
         96 49577611114          1     278472     4
         97 49577611114          1     278472     4
         98 49577611114          1     278472     4
         99 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    100 49577611114          1     278472     4
    101 49577611114          1     278472     4
    102 49577611114          1     278472     4
    103 49577611114          1     278472     4
    104 49577611114          1     278472     4
    105 49577611114          1     278472     4
    106 49577611114          1     278472     4
    107 49577611114          1     278472     4
    108 49577611114          1     278472     4
    109 49577611114          1     278472     4
    110 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    111 49577611114          1     278472     4
    112 49577611114          1     278472     4
    113 49577611114          1     278472     4
    114 49577611114          1     278472     4
    115 49577611114          1     278472     4
    116 49577611114          1     278472     4
    117 49577611114          1     278472     4
    118 49577611114          1     278472     4
    119 49577611114          1     278472     4
    120 49577611114          1     278472     4
    121 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    122 49577611114          1     278472     4
    123 49577611114          1     278472     4
    124 49577611114          1     278472     4
    125 49577611114          1     278472     4
    126 49577611114          1     278472     4
    127 49577611114          1     278472     4
    128 49577611114          1     278472     4
    129 49577611114          1     278472     4
    130 49577611114          1     278472     4
    131 49577611114          1     278472     4
    132 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    133 49577611114          1     278472     4
    134 49577611114          1     278472     4
    135 49577611114          1     278472     4
    136 49577611114          1     278472     4
    137 49577611114          1     278472     4
    138 49577611114          1     278472     4
    139 49577611114          1     278472     4
    140 49577611114          1     278472     4
    141 49577611114          1     278472     4
    142 49577611114          1     278472     4
    143 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    144 49577611114          1     278472     4
    145 49577611114          1     278472     4
    146 49577611114          1     278472     4
    147 49577611114          1     278472     4
    148 49577611114          1     278472     4
    149 49577611114          1     278472     4
    150 49577611114          1     278472     4
    151 49577611114          1     278472     4
    152 49577611114          1     278472     4
    153 49577611114          1     278472     4
    154 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    155 49577611114          1     278472     4
    156 49577611114          1     278472     4
    157 49577611114          1     278472     4
    158 49577611114          1     278472     4
    159 49577611114          1     278472     4
    160 49577611114          1     278472     4
    161 49577611114          1     278472     4
    162 49577611114          1     278472     4
    163 49577611114          1     278472     4
    164 49577611114          1     278472     4
    165 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    166 49577611114          1     278472     4
    167 49577611114          1     278472     4
    168 49577611114          1     278472     4
    169 49577611114          1     278472     4
    170 49577611114          1     278472     4
    171 49577611114          1     278472     4
    172 49577611114          1     278472     4
    173 49577611114          1     278472     4
    174 49577611114          1     278472     4
    175 49577611114          1     278472     4
    176 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    177 49577611114          1     278472     4
    178 49577611114          1     278472     4
    179 49577611114          1     278472     4
    180 49577611114          1     278472     4
    181 49577611114          1     278472     4
    182 49577611114          1     278472     4
    183 49577611114          1     278472     4
    184 49577611114          1     278472     4
    185 49577611114          1     278472     4
    186 49577611114          1     278472     4
    187 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    188 49577611114          1     278472     4
    189 49577611114          1     278472     4
    190 49577611114          1     278472     4
    191 49577611114          1     278472     4
    192 49577611114          1     278472     4
    193 49577611114          1     278472     4
    194 49577611114          1     278472     4
    195 49577611114          1     278472     4
    196 49577611114          1     278472     4
    197 49577611114          1     278472     4
    198 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    199 49577611114          1     278472     4
    200 49577611114          1     278472     4
    201 49577611114          1     278472     4
    202 49577611114          1     278472     4
    203 49577611114          1     278472     4
    204 49577611114          1     278472     4
    205 49577611114          1     278472     4
    206 49577611114          1     278472     4
    207 49577611114          1     278472     4
    208 49577611114          1     278472     4
    209 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    210 49577611114          1     278472     4
    211 49577611114          1     278472     4
    212 49577611114          1     278472     4
    213 49577611114          1     278472     4
    214 49577611114          1     278472     4
    215 49577611114          1     278472     4
    216 49577611114          1     278472     4
    217 49577611114          1     278472     4
    218 49577611114          1     278472     4
    219 49577611114          1     278472     4
    220 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    221 49577611114          1     278472     4
    222 49577611114          1     278472     4
    223 49577611114          1     278472     4
    224 49577611114          1     278472     4
    225 49577611114          1     278472     4
    226 49577611114          1     278472     4
    227 49577611114          1     278472     4
    228 49577611114          1     278472     4
    229 49577611114          1     278472     4
    230 49577611114          1     278472     4
    231 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    232 49577611114          1     278472     4
    233 49577611114          1     278472     4
    234 49577611114          1     278472     4
    235 49577611114          1     278472     4
    236 49577611114          1     278472     4
    237 49577611114          1     278472     4
    238 49577611114          1     278472     4
    239 49577611114          1     278472     4
    240 49577611114          1     278472     4
    241 49577611114          1     278472     4
    242 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    243 49577611114          1     278472     4
    244 49577611114          1     278472     4
    245 49577611114          1     278472     4
    246 49577611114          1     278472     4
    247 49577611114          1     278472     4
    248 49577611114          1     278472     4
    249 49577611114          1     278472     4
    250 49577611114          1     278472     4
    251 49577611114          1     278472     4
    252 49577611114          1     278472     4
    253 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    254 49577611114          1     278472     4
    255 49577611114          1     278472     4
    256 49577611114          1     278472     4
    257 49577611114          1     278472     4
    258 49577611114          1     278472     4
    259 49577611114          1     278472     4
    260 49577611114          1     278472     4
    261 49577611114          1     278472     4
    262 49577611114          1     278472     4
    263 49577611114          1     278472     4
    264 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    265 49577611114          1     278472     4
    266 49577611114          1     278472     4
    267 49577611114          1     278472     4
    268 49577611114          1     278472     4
    269 49577611114          1     278472     4
    270 49577611114          1     278472     4
    271 49577611114          1     278472     4
    272 49577611114          1     278472     4
    273 49577611114          1     278472     4
    274 49577611114          1     278472     4
    275 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    276 49577611114          1     278472     4
    277 49577611114          1     278472     4
    278 49577611114          1     278472     4
    279 49577611114          1     278472     4
    280 49577611114          1     278472     4
    281 49577611114          1     278472     4
    282 49577611114          1     278472     4
    283 49577611114          1     278472     4
    284 49577611114          1     278472     4
    285 49577611114          1     278472     4
    286 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    287 49577611114          1     278472     4
    288 49577611114          1     278472     4
    289 49577611114          1     278472     4
    290 49577611114          1     278472     4
    291 49577611114          1     278472     4
    292 49577611114          1     278472     4
    293 49577611114          1     278472     4
    294 49577611114          1     278472     4
    295 49577611114          1     278472     4
    296 49577611114          1     278472     4
    297 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    298 49577611114          1     278472     4
    299 49577611114          1     278472     4
    300 49577611114          1     278472     4
    301 49577611114          1     278472     4
    302 49577611114          1     278472     4
    303 49577611114          1     278472     4
    304 49577611114          1     278472     4
    305 49577611114          1     278472     4
    306 49577611114          1     278472     4
    307 49577611114          1     278472     4
    308 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    309 49577611114          1     278472     4
    310 49577611114          1     278472     4
    311 49577611114          1     278472     4
    312 49577611114          1     278472     4
    313 49577611114          1     278472     4
    314 49577611114          1     278472     4
    315 49577611114          1     278472     4
    316 49577611114          1     278472     4
    317 49577611114          1     278472     4
    318 49577611114          1     278472     4
    319 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    320 49577611114          1     278472     4
    321 49577611114          1     278472     4
    322 49577611114          1     278472     4
    323 49577611114          1     278472     4
    324 49577611114          1     278472     4
    325 49577611114          1     278472     4
    326 49577611114          1     278472     4
    327 49577611114          1     278472     4
    328 49577611114          1     278472     4
    329 49577611114          1     278472     4
    330 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    331 49577611114          1     278472     4
    332 49577611114          1     278472     4
    333 49577611114          1     278472     4
    334 49577611114          1     278472     4
    335 49577611114          1     278472     4
    336 49577611114          1     278472     4
    337 49577611114          1     278472     4
    338 49577611114          1     278472     4
    339 49577611114          1     278472     4
    340 49577611114          1     278472     4
    341 49577611114          1     278472     4

    FILE_ID SCN               THREAD     SEQUENCE STATUS
    ---------- ---------------- ---------- ---------- ----------
    342 49577611114          1     278472     4
    343 49577611114          1     278472     4
    344 49577611114          1     278472     4
    345 49577611114          1     278472     4
    346 49577611114          1     278472     4
    347 49577611114          1     278472     4
    348 49577611114          1     278472     4

    348 rows selected.


    FHSCN
    ----------------
    49577611114



    Session altered.


    STATUS     CHECKPOINT_CHANGE# FUZ CHECKPOINT_TIME     COUNT(*)
    ------- ---------------------- --- -------------------- ----------
    ONLINE          49577611114 YES 17-AUG-2012 00:06:05 348
  • 3. Re: Oracle Restore
    moreajays Pro
    Currently Being Moderated
    Hi,

    Its showing Fuzzy datafiles .. Db files still in Backup mode on clonned db & need some more archives to perfrom recovery

    1. What is the next archive log sequence after end hotbackup (Check in source alert log)

    2. check this

    select distinct status from v$backup;

    3. When you executed "recover database using backupcontrolfile until cancel:" did you suplied all archivelogs ? , What was the o/p when you supplied cancel ?

    Also do not try to open or open resetlogs database until Media Recovery is Successful

    Thanks,
    Ajay More
    http://moreajays.blogspot.com
  • 4. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi Ajay,

    The next archivelog sequence is 278471. We applied this log and we were prompted to enter the next sequence. We applied 278472.

    select distinct status from v$backup;
    sql>
    STATUS
    Not active

    We got the following error while we tried to recover using backup controlfile.

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: '/oracle/PR1/sapdata1/system_1/system.data1'

    Regards,
  • 5. Re: Oracle Restore
    Santosh Pradhan Explorer
    Currently Being Moderated
    Can u try 1 thing. Just take a new backup of controlfile and use this on the test database. try opening and recovering with this controlfile.
  • 6. Re: Oracle Restore
    moreajays Pro
    Currently Being Moderated
    Hi,

    You need check what was the next sequence generated when Hot back was ended on source database (check in alert log), need to pass all the archivelogs till that sequence

    Thanks,
    Ajay More
    http://moreajays.blogspot.com
  • 7. Re: Oracle Restore
    Dude! Guru
    Currently Being Moderated
    Are you using sqlplus or rman to recover the database?
  • 8. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi,

    We created a new control file and tried to open the database. That didn't work either.

    Regards,
  • 9. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi,

    I am using sqlplus to recover the database. The test database had data in it but there was no activity in the database. The test database has an SCN #. This SCN #, lets call it as 100. Now, I restored the datafiles of a production database to the test database (after deleting all the datafiles in the test database). The SCN numbers of these datafiles, lets say is 500. As there is a mis-match between the database SCN (100) and the SCN of the datafiles (500), oracle concludes that the database requires a recovery to be consistent and therefore, prompts for the archive logs. We supplied all the archivelogs, even those that were generated way past the time the backup ended but unable to open the database. Is such a recovery ever possible?. I mean where the database SCN is lesser to that of the SCN of the datafiles?. Thanks much for your time.

    Regards,
  • 10. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi Ajay,

    We supplied the archive logs that were generated after the backup was completed and even those generated way past the time the backup ended but that doesn't help to open the database. Oracle continues to prompt for more archive logs and upon canceling the recovery, it warns that the database cannot be opened.

    Regards,
  • 11. Re: Oracle Restore
    Santosh Pradhan Explorer
    Currently Being Moderated
    U took a binary backup of the control file and restrored it to the clone database location. What was the error it give then.
  • 12. Re: Oracle Restore
    Santosh Pradhan Explorer
    Currently Being Moderated
    Seeing at ur previous post it seems the database is not using the fresh controlfile.

    On ur production database issue the command

    alter database backup controlfile to 'any location u want to give'

    Now save this controlfile in ur clone db location as mentioned in control_files parameter in ur pfile. If there are two or three entries of control file entry then make the neccesary copies and save with the same name as in pfile. make a spfile from this pfile.


    Now bounce the database.

    Then startup mount

    recover database using backup controlfile.
    select auto

    It will recover upto the archives which u have saved in the archive destination. And then it will ask for next sequence which is not present.

    At this moment cancel the recovery.

    Then

    alter database open resetlogs.


    This should work.

    Plz revert asap
  • 13. Re: Oracle Restore
    979144 Newbie
    Currently Being Moderated
    Hi,

    I created a new SPFILE and tried to recover as per your note. The recovery is not successfull. Warnings on the presence of fuzzy files are being logged to the alert log:

    WARNING! Recovering data file 347 from a fuzzy file. If not the current file it might be an online backup taken without entering the begin backup command

    The recovery process shows ORA-0110 error "system.data1" needs more recovery.

    What are your thoughts on the difference between the database SCN and the datafile SCN?

    regards,
  • 14. Re: Oracle Restore
    Santosh Pradhan Explorer
    Currently Being Moderated
    The control file which is being used is of the previous test database while the datafiles are belonging to other database. Also as per the error the the datafiles u copied were not in the begin backup mode while copying

    Instead of breaking ur head on this i suggest u to take a fresh hot backup.

    Instead of putting ur database in begin backup mode go for tablespace begin backup mode and copy the datafiles belonging to that tablespace. Once finished end backup mode of the tablespace.
    Do this for all tablespaces.

    Also take a binary backup of ur control file and if u want take a copy of ur production pfile to the clone site.

    Carefully edit the pfile.

    If u have any queries please revert
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points