Error while restoring incremental backup

[Former Member]

Hi expert,

We are doing system copy using online and incremental backup.we had follow the this link  for restoring our system. As per the above doc we had restored the control file from incremental backup and data from online backup but while restoring incremental backup we are facing below issue.

>brrestore -b beqjflnm.ind -m incr

BR0401I BRRESTORE 7.20 (39)

BR0405I Start of file restore: reqmpleh.rsb 2015-05-13 17.26.59

BR0484I BRRESTORE log file: E:\oracle\SID\sapbackup\reqmpleh.rsb

BR0460W Termination message not found in E:\oracle\SID\sapbackup\beqjflnm.ind -

log file incomplete (this is OK if the log file has been restored)

BR0280I BRRESTORE time stamp: 2015-05-13 17.27.14

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2015-05-13 17.28.00

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0456I Probably the database must be recovered due to restore from online backu

p

BR0280I BRRESTORE time stamp: 2015-05-13 17.28.00

BR0407I Restore of database: SID

BR0408I BRRESTORE action ID: reqmpinc

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: INCR

BR0411I Database file for restore: BEQJFLNM.INCR

BR0419I Files will be restored from backup: beqjflnm.ind 2015-04-25 20.22.50

BR0416I 1 file found to restore, size 1580.383 MB

BR0513I Last full database backup (level 0): beqjenwb.fnd 2015-04-25 15.56.09

BR0424I Files will not be decompressed

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: K:\OL_Backup\incr\beqjflnm

BR0280I BRRESTORE time stamp: 2015-05-13 17.28.00

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

c

BR0280I BRRESTORE time stamp: 2015-05-13 17.28.09

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2015-05-13 17.28.09

BR0557I Starting restore of incremental database backup using RMAN...

BR0351I Restoring BEQJFLNM.INCR

BR0355I from K:\OL_Backup\incr\beqjflnm\BEQJFLNM.INCR ...

BR0278E Command output of 'D:\oracle\SID\11203\BIN\rman nocatalog':

Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 13 17:28:10 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>

RMAN> connect target *

connected to target database: SID (DBID=3473728770, not open)

using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>

host command complete

RMAN>

allocated channel: ORA_MAINT_DISK_1

channel ORA_MAINT_DISK_1: SID=201 device type=DISK

RMAN>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of available command at 05/13/2015 17:29:13

RMAN-20215: backup set not found

RMAN-06159: error while looking up backup set

RMAN>

released channel: ORA_MAINT_DISK_1

RMAN> 2> 3>

allocated channel: dsk

channel dsk: SID=201 device type=DISK

Starting recover at 13-MAY-15

Finished recover at 13-MAY-15

released channel: dsk

RMAN>

Recovery Manager complete.

BR0280I BRRESTORE time stamp: 2015-05-13 17.29.17

BR0279E Return code from 'D:\oracle\SID\11203\BIN\rman nocatalog': 1

BR0536E RMAN call for database instance SID failed

BR0200I BR_TRACE: location BrRmanCall-56, commands for RMAN in: E:\oracle\SID\sa

pbackup\.reqmpinc.cmd

@E:\oracle\SID\sapbackup\..reqmpinc..cmd

host 'F:\usr\sap\SID\SYS\exe\uc\NTAMD64\brtools.exe -f delete E:\oracle\SID\sapb

ackup\..reqmpinc..cmd';

allocate channel for maintenance device type disk;

change backupset 28761 available;

release channel;

run { allocate channel dsk device type disk;

recover database from tag beqjflnm, noredo;

release channel dsk; }

exit;

BR0280I BRRESTORE time stamp: 2015-05-13 17.29.17

BR0559E Restore of incremental database backup using RMAN failed

BR0359E Restore of BEQJFLNM.INCR from E:\oracle\SID\sapbackup\..reqmpinc..cmd fa

iled due to previous errors

BR0406I End of file restore: reqmpinc.rsb 2015-05-13 17.29.17

BR0280I BRRESTORE time stamp: 2015-05-13 17.29.17

BR0404I BRRESTORE terminated with errors

Please let me know how to resolve this error and restore the incremental backup properly.

Thanks,

Pradeep

[JamesZ]

Hi Pradeep,

The problem here should be wrong control file was restored. Control file records the backup information. So you should restore the control file which was backed up after the backup you you used.

In other words, please make sure the control file includes the backup.

Best regards,
James

[Former Member]

Hi james,

We restored control file from incremental backup, after we restored the data backup.

Please let me know how to can i check control file contain which backup.

Thanks,

Pradeep

[JamesZ]

Hi Pradeep,

As already mentioned, the control file is after incremental backup.

I mean:

1. you have a complete backup

2. control file

3. incremental backup

4. control file

you should use the 4th control file.

Are you sure you used right control file?

Best regards,

James

[Former Member]

Hi James,

We are restoring production to quality, So SID are different. We have restored fourth control file from incremental backup. Once we have restore the control file we are trying to start oracle with mount option. But we are getting error "ora-01103 database name xxx in controlfile is not yyy". Then we have generated control.sql file from production server and executed the control.sql in quality server. Now the system is in mounted mode and we are able to execute the restore command of incremental backup. But still we are getting the same error.

Please let me know if am following the correct procedure to restore the incremental backup.

Thanks,

Pradeep

[Brindavan_M]

Hello Pradeep,

Have you checked the backup file which your storing all backup in disk, and how about the channel used. The error log say the backup set not found.

Have you placed the backlog file from quality to PRD and gave the required owner permission. For restore the system using RMAN system need in mount mode and control required to restore the rman backup. have you place one full backup as well in same directory?. Let me know your system OS platform and DB as well. Based on that will provide the solution. have you restore the full backup?

Your following the document is steps to restore on same system.

Thanks,

BM

[Former Member]

Hi Brindavan,

We are using windows server 2003 and Oracle 11g. We are restored Full online backup successfully and after that we are trying to restore incremental backup.

Thanks,

Pradeep

[Brindavan_M]

Hello Pradeep ,

Is the database is in mount mode?  if not then then database need to be in mount mode to restore the incremental backup

kindly attach the restore log file.

The error message show RMAN is not connected to DB.

Thanks,

BM