Home » RDBMS Server » Backup & Recovery » Rman cloning - different node
Rman cloning - different node [message #274869] Wed, 17 October 2007 08:43 Go to next message
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!
Re: Rman cloning - different node [message #274910 is a reply to message #274869] Wed, 17 October 2007 11:32 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Rman cloning - different node [message #276250 is a reply to message #275912] Wed, 24 October 2007 09:00 Go to previous messageGo to next message
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 Sad

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>
Re: Rman cloning - different node [message #276253 is a reply to message #274910] Wed, 24 October 2007 09:19 Go to previous messageGo to next message
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>
Re: Rman cloning - different node [message #276283 is a reply to message #276253] Wed, 24 October 2007 11:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did You bounce your database after editing PFILE??
Re: Rman cloning - different node [message #276532 is a reply to message #276283] Thu, 25 October 2007 07:45 Go to previous messageGo to next message
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
Re: Rman cloning - different node [message #276640 is a reply to message #276532] Thu, 25 October 2007 13:20 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Post the errors you got?
Re: Rman cloning - different node [message #276695 is a reply to message #276640] Fri, 26 October 2007 00:44 Go to previous messageGo to next message
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

Re: Rman cloning - different node [message #276833 is a reply to message #276640] Fri, 26 October 2007 07:28 Go to previous messageGo to next message
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
Re: Rman cloning - different node [message #276927 is a reply to message #276833] Sat, 27 October 2007 00:55 Go to previous messageGo to next message
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...
Re: Rman cloning - different node [message #277305 is a reply to message #276927] Mon, 29 October 2007 08:38 Go to previous messageGo to next message
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.
Re: Rman cloning - different node [message #277330 is a reply to message #277305] Mon, 29 October 2007 11:07 Go to previous messageGo to next message
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?
Re: Rman cloning - different node [message #277412 is a reply to message #277330] Tue, 30 October 2007 00:14 Go to previous message
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


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


Current Time: Sat Dec 03 16:03:51 CST 2016

Total time taken to generate the page: 0.09554 seconds