| R21.1.1 Clone Database Refresh [message #451517] |
Thu, 15 April 2010 03:23 |
zakisays
Messages: 6
Registered: June 2008
|
Junior Member |
|
|
i cloned the application and database tier to another machine and the clone is working fine
i am trying to refresh the database of the clone by using the rman backup of the source but getting error output
RMAN> run
2> {
3> allocate auxiliary channel d1 device type disk;
4> set newname for tempfile 1 to '/oravis/db/apps_st/data/temp01.dbf';
5> set newname for tempfile 2 to '/oravis/db/apps_st/data/temp02.dbf';
6> duplicate target database to VIS;
7> }
allocated channel: d1
channel d1: SID=384 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 15-APR-10
contents of Memory Script:
{
set until scn 5965142928341;
set newname for datafile 1 to
"/oravis/db/apps_st/data/system01.dbf";
set newname for datafile 2 to
"/oravis/db/apps_st/data/system02.dbf";
set newname for datafile 3 to
"/oravis/db/apps_st/data/system03.dbf";
set newname for datafile 4 to
"/oravis/db/apps_st/data/system04.dbf";
set newname for datafile 5 to
"/oravis/db/apps_st/data/system05.dbf";
set newname for datafile 6 to
"/oravis/db/apps_st/data/ctxd01.dbf";
set newname for datafile 7 to
"/oravis/db/apps_st/data/owad01.dbf";
set newname for datafile 8 to
"/oravis/db/apps_st/data/a_queue02.dbf";
set newname for datafile 9 to
"/oravis/db/apps_st/data/odm.dbf";
set newname for datafile 10 to
"/oravis/db/apps_st/data/olap.dbf";
set newname for datafile 11 to
"/oravis/db/apps_st/data/sysaux01.dbf";
set newname for datafile 12 to
"/oravis/db/apps_st/data/apps_ts_tools01.dbf";
set newname for datafile 13 to
"/oravis/db/apps_st/data/system12.dbf";
set newname for datafile 14 to
"/oravis/db/apps_st/data/a_txn_data04.dbf";
set newname for datafile 15 to
"/oravis/db/apps_st/data/a_txn_ind06.dbf";
set newname for datafile 16 to
"/oravis/db/apps_st/data/a_ref03.dbf";
set newname for datafile 17 to
"/oravis/db/apps_st/data/a_int02.dbf";
set newname for datafile 18 to
"/oravis/db/apps_st/data/sysaux02.dbf";
set newname for datafile 19 to
"/oravis/db/apps_st/data/olap01.dbf";
set newname for datafile 20 to
"/oravis/db/apps_st/data/undo2.dbf";
set newname for datafile 21 to
"/oravis/db/apps_st/data/xxnfgb01.dbf";
set newname for datafile 22 to
"/oravis/db/apps_st/data/sysaux03.dbf";
set newname for datafile 288 to
"/oravis/db/apps_st/data/system10.dbf";
set newname for datafile 295 to
"/oravis/db/apps_st/data/system06.dbf";
set newname for datafile 314 to
"/oravis/db/apps_st/data/portal01.dbf";
set newname for datafile 351 to
"/oravis/db/apps_st/data/system07.dbf";
set newname for datafile 352 to
"/oravis/db/apps_st/data/system09.dbf";
set newname for datafile 353 to
"/oravis/db/apps_st/data/system08.dbf";
set newname for datafile 354 to
"/oravis/db/apps_st/data/system11.dbf";
set newname for datafile 379 to
"/oravis/db/apps_st/data/undo01.dbf";
set newname for datafile 392 to
"/oravis/db/apps_st/data/a_txn_data01.dbf";
set newname for datafile 393 to
"/oravis/db/apps_st/data/a_txn_ind01.dbf";
set newname for datafile 394 to
"/oravis/db/apps_st/data/a_ref01.dbf";
set newname for datafile 395 to
"/oravis/db/apps_st/data/a_int01.dbf";
set newname for datafile 396 to
"/oravis/db/apps_st/data/a_summ01.dbf";
set newname for datafile 397 to
"/oravis/db/apps_st/data/a_nolog01.dbf";
set newname for datafile 398 to
"/oravis/db/apps_st/data/a_archive01.dbf";
set newname for datafile 399 to
"/oravis/db/apps_st/data/a_queue01.dbf";
set newname for datafile 400 to
"/oravis/db/apps_st/data/a_media01.dbf";
set newname for datafile 401 to
"/oravis/db/apps_st/data/a_txn_data02.dbf";
set newname for datafile 402 to
"/oravis/db/apps_st/data/a_txn_data03.dbf";
set newname for datafile 403 to
"/oravis/db/apps_st/data/a_txn_ind02.dbf";
set newname for datafile 404 to
"/oravis/db/apps_st/data/a_txn_ind03.dbf";
set newname for datafile 405 to
"/oravis/db/apps_st/data/a_txn_ind04.dbf";
set newname for datafile 406 to
"/oravis/db/apps_st/data/a_txn_ind05.dbf";
set newname for datafile 407 to
"/oravis/db/apps_st/data/a_ref02.dbf";
restore
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
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
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 15-APR-10
channel d1: starting datafile backup set restore
channel d1: specifying datafile(s) to restore from backup set
channel d1: restoring datafile 00001 to /oravis/db/apps_st/data/system01.dbf
channel d1: restoring datafile 00002 to /oravis/db/apps_st/data/system02.dbf
channel d1: restoring datafile 00003 to /oravis/db/apps_st/data/system03.dbf
channel d1: restoring datafile 00004 to /oravis/db/apps_st/data/system04.dbf
channel d1: restoring datafile 00005 to /oravis/db/apps_st/data/system05.dbf
channel d1: restoring datafile 00006 to /oravis/db/apps_st/data/ctxd01.dbf
channel d1: restoring datafile 00007 to /oravis/db/apps_st/data/owad01.dbf
channel d1: restoring datafile 00008 to /oravis/db/apps_st/data/a_queue02.dbf
channel d1: restoring datafile 00009 to /oravis/db/apps_st/data/odm.dbf
channel d1: restoring datafile 00010 to /oravis/db/apps_st/data/olap.dbf
channel d1: restoring datafile 00011 to /oravis/db/apps_st/data/sysaux01.dbf
channel d1: restoring datafile 00012 to /oravis/db/apps_st/data/apps_ts_tools01.dbf
channel d1: restoring datafile 00013 to /oravis/db/apps_st/data/system12.dbf
channel d1: restoring datafile 00014 to /oravis/db/apps_st/data/a_txn_data04.dbf
channel d1: restoring datafile 00015 to /oravis/db/apps_st/data/a_txn_ind06.dbf
channel d1: restoring datafile 00016 to /oravis/db/apps_st/data/a_ref03.dbf
channel d1: restoring datafile 00017 to /oravis/db/apps_st/data/a_int02.dbf
channel d1: restoring datafile 00018 to /oravis/db/apps_st/data/sysaux02.dbf
channel d1: restoring datafile 00019 to /oravis/db/apps_st/data/olap01.dbf
channel d1: restoring datafile 00020 to /oravis/db/apps_st/data/undo2.dbf
channel d1: restoring datafile 00021 to /oravis/db/apps_st/data/xxnfgb01.dbf
channel d1: restoring datafile 00022 to /oravis/db/apps_st/data/sysaux03.dbf
channel d1: restoring datafile 00288 to /oravis/db/apps_st/data/system10.dbf
channel d1: restoring datafile 00295 to /oravis/db/apps_st/data/system06.dbf
channel d1: restoring datafile 00314 to /oravis/db/apps_st/data/portal01.dbf
channel d1: restoring datafile 00351 to /oravis/db/apps_st/data/system07.dbf
channel d1: restoring datafile 00352 to /oravis/db/apps_st/data/system09.dbf
channel d1: restoring datafile 00353 to /oravis/db/apps_st/data/system08.dbf
channel d1: restoring datafile 00354 to /oravis/db/apps_st/data/system11.dbf
channel d1: restoring datafile 00379 to /oravis/db/apps_st/data/undo01.dbf
channel d1: restoring datafile 00392 to /oravis/db/apps_st/data/a_txn_data01.dbf
channel d1: restoring datafile 00393 to /oravis/db/apps_st/data/a_txn_ind01.dbf
channel d1: restoring datafile 00394 to /oravis/db/apps_st/data/a_ref01.dbf
channel d1: restoring datafile 00395 to /oravis/db/apps_st/data/a_int01.dbf
channel d1: restoring datafile 00396 to /oravis/db/apps_st/data/a_summ01.dbf
channel d1: restoring datafile 00397 to /oravis/db/apps_st/data/a_nolog01.dbf
channel d1: restoring datafile 00398 to /oravis/db/apps_st/data/a_archive01.dbf
channel d1: restoring datafile 00399 to /oravis/db/apps_st/data/a_queue01.dbf
channel d1: restoring datafile 00400 to /oravis/db/apps_st/data/a_media01.dbf
channel d1: restoring datafile 00401 to /oravis/db/apps_st/data/a_txn_data02.dbf
channel d1: restoring datafile 00402 to /oravis/db/apps_st/data/a_txn_data03.dbf
channel d1: restoring datafile 00403 to /oravis/db/apps_st/data/a_txn_ind02.dbf
channel d1: restoring datafile 00404 to /oravis/db/apps_st/data/a_txn_ind03.dbf
channel d1: restoring datafile 00405 to /oravis/db/apps_st/data/a_txn_ind04.dbf
channel d1: restoring datafile 00406 to /oravis/db/apps_st/data/a_txn_ind05.dbf
channel d1: restoring datafile 00407 to /oravis/db/apps_st/data/a_ref02.dbf
channel d1: reading from backup piece /oraprod/rmanbackup/BKUP140410/PROD_2clb4tsn_1_1.dfbkup
channel d1: ORA-19870: error while restoring backup piece /oraprod/rmanbackup/BKUP140410/PROD_2clb4tsn_1_1.dfbkup
ORA-19505: failed to identify file "/oraprod/rmanbackup/BKUP140410/PROD_2clb4tsn_1_1.dfbkup"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/15/2010 10:19:17
RMAN-01005: not all datafiles have backups that can be recovered to scn 5965142928341
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 407 found to restore
RMAN-06023: no backup or copy of datafile 406 found to restore
RMAN-06023: no backup or copy of datafile 405 found to restore
RMAN-06023: no backup or copy of datafile 404 found to restore
RMAN-06023: no backup or copy of datafile 403 found to restore
RMAN-06023: no backup or copy of datafile 402 found to restore
RMAN-06023: no backup or copy of datafile 401 found to restore
RMAN-06023: no backup or copy of datafile 400 found to restore
RMAN-06023: no backup or copy of datafile 399 found to restore
RMAN-06023: no backup or copy of datafile 398 found to restore
RMAN-06023: no backup or copy of datafile 397 found to restore
RMAN-06023: no backup or copy of datafile 396 found to restore
RMAN-06023: no backup or copy of datafile 395 found to restore
RMAN-06023: no backup or copy of datafile 394 found to restore
RMAN-06023: no backup or copy of datafile 393 found to restore
RMAN-06023: no backup or copy of datafile 392 found to restore
RMAN-06023: no backup or copy of datafile 379 found to restore
RMAN-06023: no backup or copy of datafile 354 found to restore
RMAN-06023: no backup or copy of datafile 353 found to restore
RMAN-06023: no backup or copy of datafile 352 found to restore
RMAN-06023: no backup or copy of datafile 351 found to restore
RMAN-06023: no backup or copy of datafile 314 found to restore
RMAN-06023: no backup or copy of datafile 295 found to restore
RMAN-06023: no backup or copy of datafile 288 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to 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
the database of clone was droped and then made to nomount state
the the rman command was given
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
