OraFAQ Forum: Backup & Recovery » Rman cloning

Home » RDBMS Server » Backup & Recovery » Rman cloning - different node

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman cloning - different node [message #274869]

Wed, 17 October 2007 08:43

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

Rman cloning - diffeent node

I am running 10gR2 on HP-UX in production and testing server also same config and file structure.
I have weekly offline and incremental backup in production. I need to clone this rman back to testing server,

I want to restore it to another node, under another db name.

How do I do this:
Do I use ftp to move the rman backupfiles and data files to diffrent node and later do the normal cloning.
Is it the right way to cloning on diffrent node??

Please help me out in best way to do this!

Report message to a moderator

Re: Rman cloning - different node [message #274910 is a reply to message #274869]

Wed, 17 October 2007 11:32

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

If you have same structure and same things juts SCP or FTP the files and perform full restore on the new machine,
or if you have different file structure then use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameter

[Updated on: Wed, 17 October 2007 11:32]

Report message to a moderator

Re: Rman cloning - different node [message #275912 is a reply to message #274869]

Tue, 23 October 2007 06:08

kudur_kv
Messages: 75
Registered: February 2005

Member

1. Use the RMAN duplicate DB for your cloning.

2. About the RMAN backups, are they being taken to a tape device or to the disk.

In either case, do both the 'nodes' have access to that particular destination?

If RMAN can access the backup destination from either nodes, then you can simply use the duplicate DB command. The detailed steps are provided in the documentation.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1008564

KV

Report message to a moderator

Re: Rman cloning - different node [message #276250 is a reply to message #275912]

Wed, 24 October 2007 09:00

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

thanking you

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

$ORACLE_SID=ukrdb; export ORACLE_SID
$rman TARGET sys/excel\@\exceldb CATALOG rman/rman\@\exceldb AUXILIARY /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 24 06:26:41 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: excelDB (DBID=3175678959)
connected to recovery catalog database
connected to auxiliary database: ukrdb (not mounted)

RMAN>
RUN
{

ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;

DUPLICATE TARGET DATABASE TO ukrdb;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: aux1
channel aux1: sid=155 devtype=DISK
starting full resync of recovery catalog
full resync complete

allocated channel: aux2
channel aux2: sid=154 devtype=DISK

allocated channel: aux3
channel aux3: sid=153 devtype=DISK

Starting Duplicate Db at 24-OCT-07

contents of Memory Script:
{
set until scn 76757212;
set newname for datafile 1 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system01.dbf";
set newname for datafile 2 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/undotbs01.dbf";
set newname for datafile 3 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux01.dbf";
set newname for datafile 4 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users01.dbf";
set newname for datafile 5 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_cms.dbf";
set newname for datafile 6 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_data.dbf";
set newname for datafile 7 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wob.dbf";
set newname for datafile 8 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_idx.dbf";
set newname for datafile 9 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_ods.dbf";
set newname for datafile 10 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wof.dbf";
set newname for datafile 11 to "/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_auditor.dbf";
set newname for datafile 12 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system02.dbf";
set newname for datafile 13 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux02.dbf";
set newname for datafile 14 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users02.dbf";
set newname for datafile 15 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_data.dbf";
set newname for datafile 16 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_idx.dbf";
set newname for datafile 17 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_etlscheduler_data.dbf";
set newname for datafile 18 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/rman.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 24-OCT-07

channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system01.dbf
restoring datafile 00002 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/undotbs01.dbf
restoring datafile 00003 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux01.dbf
restoring datafile 00004 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users01.dbf
restoring datafile 00005 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_cms.dbf
restoring datafile 00006 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_data.dbf
restoring datafile 00007 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wob.dbf
restoring datafile 00008 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_idx.dbf
restoring datafile 00009 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_ods.dbf
restoring datafile 00010 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wof.dbf
restoring datafile 00011 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_auditor.dbf
restoring datafile 00012 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system02.dbf
restoring datafile 00013 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux02.dbf
restoring datafile 00014 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users02.dbf
restoring datafile 00015 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_data.dbf
restoring datafile 00016 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_idx.dbf
restoring datafile 00017 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_etlscheduler_data.dbf
channel aux1: reading from backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00018 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/rman.dbf
channel aux2: reading from backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp
ORA-19870: error reading backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp
ORA-19505: failed to identify file "/oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp
ORA-19505: failed to identify file "/oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup

released channel: aux1
released channel: aux2
released channel: aux3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLwoS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/24/2007 06:28:25
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Report message to a moderator

Re: Rman cloning - different node [message #276253 is a reply to message #274910]

Wed, 24 October 2007 09:19

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

cloning production db :exceldb --to-- clodback db : ukrdb

1) I have the production weekly offline and incr backups in the location ;

/oracle/flash_recovery_area/excelDB/backupset/2007_10_23

2). ftpd all the backup pieces to the coldback path

oraclesan/flash_recovery_area/ukrDB/backupset/2007_10_23

3) I made the changes to Init paramaeter file

*.DB_FILE_NAME_CONVERT=(/oraclesan/app/oracle/oracle/product/10.2.0/db_1/odata/exceldb/,/oracle/app/oracle/oracle/product/10.2.0/db_1 /odata/ukrdb/)
*.LOG_FILE_NAME_CONVERT=(/oraclesan/app/oracle/oracle/product/10.2.0/db_1/odata/exceldb/,/oracle/app/oracle/oracle/product/10.2.0/db_ 1/odata/ukrdb/)

4)follwoed the cloning procedure, but i got the error to locate the backup copy in cold bac. It pointing twoards prodution.

Pls help me to sort out this error

thanking you

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

$ORACLE_SID=ukrdb; export ORACLE_SID
$rman TARGET sys/excel\@\exceldb CATALOG rman/rman\@\exceldb AUXILIARY /

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Oct 24 06:26:41 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: excelDB (DBID=3175678959)
connected to recovery catalog database
connected to auxiliary database: ukrdb (not mounted)

RMAN>
RUN
{

ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;
ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;

DUPLICATE TARGET DATABASE TO ukrdb;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9>

allocated channel: aux1
channel aux1: sid=155 devtype=DISK
starting full resync of recovery catalog
full resync complete

allocated channel: aux2
channel aux2: sid=154 devtype=DISK

allocated channel: aux3
channel aux3: sid=153 devtype=DISK

Starting Duplicate Db at 24-OCT-07

contents of Memory Script:
{
set until scn 76757212;
set newname for datafile 1 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system01.dbf";
set newname for datafile 2 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/undotbs01.dbf";
set newname for datafile 3 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux01.dbf";
set newname for datafile 4 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users01.dbf";
set newname for datafile 5 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_cms.dbf";
set newname for datafile 6 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_data.dbf";
set newname for datafile 7 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wob.dbf";
set newname for datafile 8 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_idx.dbf";
set newname for datafile 9 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_ods.dbf";
set newname for datafile 10 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wof.dbf";
set newname for datafile 11 to "/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_auditor.dbf";
set newname for datafile 12 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system02.dbf";
set newname for datafile 13 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux02.dbf";
set newname for datafile 14 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users02.dbf";
set newname for datafile 15 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_data.dbf";
set newname for datafile 16 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_idx.dbf";
set newname for datafile 17 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_etlscheduler_data.dbf";
set newname for datafile 18 to
"/oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/rman.dbf";
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 24-OCT-07

channel aux1: starting datafile backupset restore
channel aux1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system01.dbf
restoring datafile 00002 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/undotbs01.dbf
restoring datafile 00003 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux01.dbf
restoring datafile 00004 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users01.dbf
restoring datafile 00005 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_cms.dbf
restoring datafile 00006 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_data.dbf
restoring datafile 00007 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wob.dbf
restoring datafile 00008 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_dw_idx.dbf
restoring datafile 00009 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_ods.dbf
restoring datafile 00010 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_wof.dbf
restoring datafile 00011 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_auditor.dbf
restoring datafile 00012 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/system02.dbf
restoring datafile 00013 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/sysaux02.dbf
restoring datafile 00014 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/users02.dbf
restoring datafile 00015 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_data.dbf
restoring datafile 00016 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_tws_idx.dbf
restoring datafile 00017 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/tbsp_etlscheduler_data.dbf
channel aux1: reading from backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp
channel aux2: starting datafile backupset restore
channel aux2: specifying datafile(s) to restore from backup set
restoring datafile 00018 to /oracle/app/oracle/oracle/product/10.2.0/db_1/odata/ukrdb/rman.dbf
channel aux2: reading from backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp
ORA-19870: error reading backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp
ORA-19505: failed to identify file "/oracle/flash_recovery_area/excelDB/backupset/2007_10_21/o1_mf_nnnd0_WEEKLY_OFFLINE_COL_1_3kp5ctt9_.bkp"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp
ORA-19505: failed to identify file "/oracle/flash_recovery_area/excelDB/backupset/2007_10_23/o1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup

released channel: aux1
released channel: aux2
released channel: aux3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLwoS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/24/2007 06:28:25
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Report message to a moderator

Re: Rman cloning - different node [message #276283 is a reply to message #276253]

Wed, 24 October 2007 11:29

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did You bounce your database after editing PFILE??

Report message to a moderator

Re: Rman cloning - different node [message #276532 is a reply to message #276283]

Thu, 25 October 2007 07:45

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

yes, i did.

pls have a look at my servers directory structure.

Production

1) Data files are located in
Path : (/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/exceldb/tbsp_owf.dbf)

---------------------------------------------------------------------------------------------------------------
2) (flash_recovery_area)

Path :(oracle/flash_recovery_area/excelDB/backupset/2007_10_24/ 1_mf_nnnd1_DAILYINCREMENTALBA_1_3kwz8919_.bkp)

################################################################################################################

Coldback :

1) Path : /oracle/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/

----------------------------------------------------------------------------------------------------------------
2) (flash_recovery_area)

Path : /oraclesan/flash_recovery_area/ukrDB/backupset/2007_10_23

-----------------------------------------------------------------
cloning production db :exceldb --to-- clodback db : ukrdb

1) I have the production weekly offline and incr backups in the location ;

/oracle/flash_recovery_area/excelDB/backupset/2007_10_23

2). ftpd all the backup pieces to the coldback path

oraclesan/flash_recovery_area/ukrDB/backupset/2007_10_23

3) I made the changes to Init paramaeter file

*.DB_FILE_NAME_CONVERT=(/oraclesan/app/oracle/oracle/product/10.2.0/db_1/odata/exceldb/,/oracle/app/oracle/oracle/product/10.2.0/db_1 /odata/ukrdb/)
*.LOG_FILE_NAME_CONVERT=(/oraclesan/app/oracle/oracle/product/10.2.0/db_1/odata/exceldb/,/oracle/app/oracle/oracle/product/10.2.0/db_ 1/odata/ukrdb/)

4)follwoed the cloning procedure, but i got the error to locate the backup copy in cold bac. It pointing twoards prodution.

Pls help me to sort out this error

thanking you

Report message to a moderator

Re: Rman cloning - different node [message #276640 is a reply to message #276532]

Thu, 25 October 2007 13:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Post the errors you got?

Report message to a moderator

Re: Rman cloning - different node [message #276695 is a reply to message #276640]

Fri, 26 October 2007 00:44

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Report message to a moderator

Re: Rman cloning - different node [message #276833 is a reply to message #276640]

Fri, 26 October 2007 07:28

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

I have reached to final stage, restored all data file. At the time of creating control file i got the following error.
===========================================================
Fri Oct 26 06:34:53 2007
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Fri Oct 26 06:34:56 2007
Errors in file /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc:
ORA-00200: control file could not be created
ORA-00202: control file: '/oraclesan/app/oracle/oracl
e/product/10.2.0/db_1/oradata/ukrdb/control02.ctl'
ORA-27040: file create error, unable to create file
HPUX-ia64 Error: 2: No such file or directory
ORA-1503 signalled during: CREATE CONTROLFILE REUSE SET DATABASE "ukrDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 584
LOGFILE
GROUP 4 ( '/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/redo4.log', '/oraclesan/app/oracle/oracle/pro
duct/10.2.0/db_1/oradata/ukrdb/redo0401.log' ) SIZE 100 M REUSE,
GROUP 5 ( '/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/redo0501.log', '/oraclesan/app/oracle/oracle/
product/10.2.0/db_1/oradata/ukrdb/redo5.log' ) SIZE 100 M REUSE,
GROUP 6 ( '/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/redo0601.log', '/oraclesan/app/oracle/oracle/
product/10.2.0/db_1/oradata/ukrdb/redo6.log' ) SIZE 100 M REUSE
DATAFILE
'/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/system01.dbf'
CHARACTER SET WE8ISO8859P1
...
Fri Oct 26 06:48:21 2007
alter database open
Fri Oct 26 06:48:21 2007
ORA-1507 signalled during: alter database open
...
Fri Oct 26 06:48:33 2007
alter database mount
Fri Oct 26 06:48:33 2007
ORA-00218: block size 0 of control file '/oraclesan/app/oracle/oracle/product/10.2.0/db_1/oradata/ukrdb/control01.ctl' doe
s not match DB_BLOCK_SIZE (0)
Fri Oct 26 06:48:36 2007
ORA-218 signalled during: alter database mount
...
:q
$cd /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc:
sh: /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc:: not found.
$cd /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc:
sh: /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc:: not found.
$vi /oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc
"/oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc" 23 lines, 952 characters
/oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/udump/ukrdb_ora_17582.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
O00200exitexit/oracle/app/oracle/oracle/product/10.2.0/db_1
sh: ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^ [[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[ [A^[[A^[[A^[[A^[[A00200exitexit: not found.
$/oraclesan/app/oracle/oracle/product/10.2.0/db_1/admin/ukrdb/bdump
Machine: ia64
Instance name: ukrdb
Redo thread mounted by this instance: 0 <none>
Oracle process number: 16
Unix process pid: 17582, image: oracle@ukrux (TNS V1-V3)

*** 2007-10-26 06:34:56.143
*** ACTION NAME:(0000044 FINISHED64) 2007-10-26 06:34:56.142
*** SERVICE NAME:() 2007-10-26 06:34:56.142
*** SESSION ID:(157.3) 2007-10-26 06:34:56.142
ORA-00200: control file could not be created
ORA-00202: control file: '/oraclesan/app/oracle/oracl
e/product/10.2.0/db_1/oradata/ukrdb/control02.ctl'
ORA-27040: file create error, unable to create file
HPUX-ia64 Error: 2: No such file or directory

Report message to a moderator

Re: Rman cloning - different node [message #276927 is a reply to message #276833]

Sat, 27 October 2007 00:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-27040: file create error, unable to create file
HPUX-ia64 Error: 2: No such file or directory
Fix this error first then try...

Report message to a moderator

Re: Rman cloning - different node [message #277305 is a reply to message #276927]

Mon, 29 October 2007 08:38

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

could any one help me to fix this error.I tried all the possible ways. Not able to trace and make out.

Report message to a moderator

Re: Rman cloning - different node [message #277330 is a reply to message #277305]

Mon, 29 October 2007 11:07

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Why don't you take new backup and perform the cloning again or by using DUPLICATE DATABASE command?

Report message to a moderator

Re: Rman cloning - different node [message #277412 is a reply to message #277330]

Tue, 30 October 2007 00:14

karkad
Messages: 12
Registered: July 2007
Location: CHENNAI

Junior Member

Backup which i'm using OEM scheduled backup. Weekly offline and incremental backup.I'm taking all the pieces offline + incremental backup peieces. I need to impliment the cloning with the same scheduled backup

Report message to a moderator

Previous Topic:	controlfile autobackup format
Next Topic:	RMAN Connect nocatalog in Legato

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:42:40 CST 2024