cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

System copy using RMAN online backup

Former Member

on ‎05-05-2011 12:03 PM

0 Kudos

Hi,

I'm doing system from PRD to QAS (Oracle version 11g with RMAN online backup).I get the following error message.

Also I'm using the higher version of BRTOOLS 7.20 (13).Iu2019ve done several system copies successfully with normal backup.

Is there any specific method for system copy using RMAN backup ?

BR0401I BRRESTORE 7.20 (13)

BR0405I Start of file restore: refurbeg.rsb 2011-05-04 12.38.02

BR0484I BRRESTORE log file: J:\oracle\SMA\sapbackup\refurbeg.rsb

BR0101I Parameters

Name Value

oracle_sid SMA

oracle_home G:\oracle\SMA\112

oracle_profile G:\oracle\SMA\112\database\initSMA.ora

sapdata_home J:\oracle\SMA

sap_profile G:\oracle\SMA\112\database\initSMA.sap

recov_interval 30

restore_mode ALL

backup_dev_type disk

compress no

disk_copy_cmd rman_set

exec_parallel 1

system_info smaadm ATT14SAP99 Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info SMA 11.2.0.1.0

make_info NTAMD64 OCI_10201_SHARE Mar 7 2011

command_line brrestore

BR0454W Values of sapdata_home are different: current 'J:\oracle\SMA', backup befpjaeb.and 'I:\oracle\SMA'

BR0455W Value 'J:\oracle\SMA' of sapdata_home will be used for restore

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.02

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

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.03

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0427I Files from the old sapdata_home I:\oracle\SMA will be restored into the new sapdata_home J:\oracle\SMA

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_1\SR3.DATA1 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_2\SR3.DATA2 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_3\SR3.DATA3 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_4\SR3.DATA4 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_5\SR3.DATA5 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_7\SR3.DATA7 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_8\SR3.DATA8 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA2\SR3_9\SR3.DATA9 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA4\SR3DB_1\SR3DB.DATA1 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA4\SR3DB_2\SR3DB.DATA2 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA4\SR3DB_3\SR3DB.DATA3 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA4\SR3USR_1\SR3USR.DATA1 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA1\UNDO_1\UNDO.DATA1 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA1\SYSAUX_1\SYSAUX.DATA1 will be overwritten

BR0428W File K:\ORACLE\SMA\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 will be overwritten

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.03

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

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.04

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.04

BR0407I Restore of database: SMA

BR0408I BRRESTORE action ID: refurbeg

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: ALL

BR0419I Files will be restored from backup: befpjaeb.and 2011-04-06 10.41.53

BR0416I 24 files found to restore, total size 40896.961 MB

BR1398I Files will be decompressed by RMAN

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: R:\oracle\SMA\sapbackup\befpjaeb

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.04

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

BR0280I BRRESTORE time stamp: 2011-05-04 12.38.05

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0351I Restoring K:\ORACLE\SMA\SAPDATA2\SR3_10\SR3.DATA10

BR0355I from R:\oracle\SMA\sapbackup\befpjaeb\SR3.DATA10.S ...

BR0278E Command output of 'G:\oracle\SMA\112\BIN\rman nocatalog':

Recovery Manager: Release 11.2.0.1.0 - Production on Wed May 4 12:38:05 2011

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

RMAN>

RMAN> connect target *

connected to target database: SMA (DBID=1327012385, 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=135 device type=DISK

RMAN>

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

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

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

RMAN-03002: failure of available command at 05/04/2011 12:38:07

RMAN-20215: backup set not found

RMAN-06159: error while looking up backup set

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

volker_borowski2
Active Contributor
‎05-05-2011 9:50 PM
0 Kudos

Hi,

rman requires a binary controlfile to access the backup information.

A binary controlfile belonging to a DB can only be opened by this very same DB, not by another DB.

So no way to initialize the target SID first and proceed then with restore!

The restore has to be done with a DB of the source SID !! (sounds freaky, I know)

This is why your approach will not work. Since all the aspects involved are

tricke to be handled manually, you should not use brrestore to do a systemcopy

restore with SID change on your own.

Use brrecover instead! It is fully capable of handling all the required steps, including handling of

online_cons backups and applying restores of INCR backups in systemcopies as well. *** CHEEEER ***

The steps executed by brrecover will be

- restore binary controlfile of the backup

- start temporary instance with the source sid on target system (from target ORACLE_HOME !) to access binary controlfile

- do the restore of level 0 backup utilize the backup information from the binary source controlfile.

- if required: do a restore of an INCR backup

- recover redologs as needed

- rename datafiles and reconfigure SID to fit target system and creat new controlfiles for real target SID

- open db

I strongly suggest to try brrecover, to make sure you don manually mess up the sequence of the required steps !

Hope this helps

Volker

Show replies
Show replies
Former Member
‎05-05-2011 12:33 PM
0 Kudos

Hello Premkumar,

I don't have much experience with brtools/RMAN system copies, but the error message

states that the target database doesn't know of the backup set. Compare the output

of this command of both the source and target database:

C:\> rman target / nocatalog
RMAN> list backup;

I guess this will return on the target database: specification does not match any backup in the repository

If your online backup is known in the controlfiles of the source but not the target,

then you could make it known via the RMAN CATALOG command:

[http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta008.htm#i79811|http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta008.htm#i79811]

Regards,

Mark

Show replies
Show replies
Former Member
‎05-05-2011 12:54 PM
0 Kudos

Thanks Mark.

I know the backup set no, but not sure with command how to change it on the Target system. Iu2019ve read the link but unable to understand it. Can you provide the exact steps to be followed to change the catalogue or backup set.

Former Member
‎05-05-2011 1:21 PM
0 Kudos

Hello Premkumar,

theoretically the BR*tools should be handling all this. I don't know why this fails in the first place.

Anyway you cannot move the backup history from the source to the target system. Please

list the output of "list backup" from the source (formatted in the code-tags for readability),

then I might be able to help registering the backup also on the target.

Regards,

Mark

Former Member
‎05-05-2011 4:20 PM
0 Kudos

The output of RMAN for the backup tag BEFPJAEB.

Recovery Manager11.2.0.1.0

RMAN>

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74138 Full 1.53G DISK 00:08:35 06-APR-11

BP Key: 74138 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA10.S

List of Datafiles in backup set 74138

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

13 Full 1144394258 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_10\SR3.DATA10

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74139 Full 2.35G DISK 00:10:50 06-APR-11

BP Key: 74139 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA11.S

List of Datafiles in backup set 74139

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

22 Full 1144395803 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_11\SR3.DATA11

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74140 Full 1.94G DISK 00:09:03 06-APR-11

BP Key: 74140 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA12.S

List of Datafiles in backup set 74140

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

23 Full 1144404396 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_12\SR3.DATA12

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74141 Full 1.92G DISK 00:09:31 06-APR-11

BP Key: 74141 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA1.S

List of Datafiles in backup set 74141

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

4 Full 1144406368 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_1\SR3.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74142 Full 2.16G DISK 00:10:30 06-APR-11

BP Key: 74142 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA2.S

List of Datafiles in backup set 74142

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

5 Full 1144410456 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_2\SR3.DATA2

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74143 Full 1.84G DISK 00:10:43 06-APR-11

BP Key: 74143 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA3.S

List of Datafiles in backup set 74143

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

6 Full 1144412342 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_3\SR3.DATA3

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74144 Full 2.29G DISK 00:13:26 06-APR-11

BP Key: 74144 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA4.S

List of Datafiles in backup set 74144

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

7 Full 1144413893 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_4\SR3.DATA4

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74148 Full 1.93G DISK 00:09:38 06-APR-11

BP Key: 74148 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA5.S

List of Datafiles in backup set 74148

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

8 Full 1144416147 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_5\SR3.DATA5

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74149 Full 1.99G DISK 00:09:48 06-APR-11

BP Key: 74149 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA6.S

List of Datafiles in backup set 74149

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

9 Full 1144418182 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_6\SR3.DATA6

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74150 Full 1.81G DISK 00:09:04 06-APR-11

BP Key: 74150 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA7.S

List of Datafiles in backup set 74150

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

10 Full 1144422439 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_7\SR3.DATA7

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74151 Full 1.87G DISK 00:09:21 06-APR-11

BP Key: 74151 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA8.S

List of Datafiles in backup set 74151

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

11 Full 1144423895 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_8\SR3.DATA8

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74152 Full 3.31G DISK 00:15:43 06-APR-11

BP Key: 74152 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3.DATA9.S

List of Datafiles in backup set 74152

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

12 Full 1144427497 06-APR-11 K:\ORACLE\SMP\SAPDATA2\SR3_9\SR3.DATA9

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74153 Full 2.43G DISK 00:11:29 06-APR-11

BP Key: 74153 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3700.DATA1.S

List of Datafiles in backup set 74153

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

14 Full 1144432125 06-APR-11 K:\ORACLE\SMP\SAPDATA3\SR3700_1\SR3700.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74154 Full 2.39G DISK 00:11:23 06-APR-11

BP Key: 74154 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3700.DATA2.S

List of Datafiles in backup set 74154

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

15 Full 1144434277 06-APR-11 K:\ORACLE\SMP\SAPDATA3\SR3700_2\SR3700.DATA2

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74155 Full 2.47G DISK 00:11:40 06-APR-11

BP Key: 74155 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3700.DATA3.S

List of Datafiles in backup set 74155

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

16 Full 1144435809 06-APR-11 K:\ORACLE\SMP\SAPDATA3\SR3700_3\SR3700.DATA3

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74156 Full 3.00G DISK 00:14:08 06-APR-11

BP Key: 74156 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3700.DATA4.S

List of Datafiles in backup set 74156

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

17 Full 1144440222 06-APR-11 K:\ORACLE\SMP\SAPDATA3\SR3700_4\SR3700.DATA4

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74157 Full 1.30G DISK 00:05:44 06-APR-11

BP Key: 74157 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3DB.DATA1.S

List of Datafiles in backup set 74157

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

19 Full 1144442622 06-APR-11 K:\ORACLE\SMP\SAPDATA4\SR3DB_1\SR3DB.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74158 Full 1.31G DISK 00:05:59 06-APR-11

BP Key: 74158 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3DB.DATA2.S

List of Datafiles in backup set 74158

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

20 Full 1144443688 06-APR-11 K:\ORACLE\SMP\SAPDATA4\SR3DB_2\SR3DB.DATA2

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74159 Full 714.83M DISK 00:03:08 06-APR-11

BP Key: 74159 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3DB.DATA3.S

List of Datafiles in backup set 74159

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

21 Full 1144444925 06-APR-11 K:\ORACLE\SMP\SAPDATA4\SR3DB_3\SR3DB.DATA3

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74160 Full 686.45M DISK 00:02:47 06-APR-11

BP Key: 74160 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3DB.DATA4.S

List of Datafiles in backup set 74160

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

24 Full 1144445490 06-APR-11 K:\ORACLE\SMP\SAPDATA4\SR3DB_4\SR3DB.DATA4

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74161 Full 292.89M DISK 00:01:05 06-APR-11

BP Key: 74161 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SR3USR.DATA1.S

List of Datafiles in backup set 74161

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

18 Full 1144445996 06-APR-11 K:\ORACLE\SMP\SAPDATA4\SR3USR_1\SR3USR.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74162 Full 274.80M DISK 00:02:06 06-APR-11

BP Key: 74162 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\UNDO.DATA1.S

List of Datafiles in backup set 74162

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

2 Full 1144446499 06-APR-11 K:\ORACLE\SMP\SAPDATA1\UNDO_1\UNDO.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74163 Full 55.58M DISK 00:00:19 06-APR-11

BP Key: 74163 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SYSAUX.DATA1.S

List of Datafiles in backup set 74163

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

3 Full 1144446849 06-APR-11 K:\ORACLE\SMP\SAPDATA1\SYSAUX_1\SYSAUX.DATA1

BS Key Type LV Size Device Type Elapsed Time Completion Time

-

-

-- -

-

-

-

74164 Full 141.98M DISK 00:00:42 06-APR-11

BP Key: 74164 Status: AVAILABLE Compressed: YES Tag: BEFPJAEB

Piece Name: R:\ORACLE\SMP\SAPBACKUP\BEFPJAEB\SYSTEM.DATA1.S

List of Datafiles in backup set 74164

File LV Type Ckp SCN Ckp Time Name

-

-- -

-

-

-

1 Full 1144447202 06-APR-11 K:\ORACLE\SMP\SAPDATA1\SYSTEM_1\SYSTEM.DATA1

Ask a Question