| Auxiliary database [message #334862] |
Fri, 18 July 2008 07:37  |
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
|
Senior Member |
|
|
Hi
I m trying to create the axuilary database using rman backup
but after connecting with target database i am getting follwoing error
==================================STEP 1=========================
rman target sys/oracle@laptop auxiliary sys/oracle@dup
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jul 18 17:59:58 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1187935989)
connected to auxiliary database: DUP (not mounted)
=================================STEP 2==========================
RMAN> DUPLICATE TARGET DATABASE TO DUP;
Starting Duplicate Db at 18-JUL-08
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=157 devtype=DISK
contents of Memory Script:
{
set until scn 832346;
set newname for datafile 1 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF";
set newname for datafile 2 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF";
set newname for datafile 3 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF";
set newname for datafile 4 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF";
set newname for datafile 5 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\EXAMPLE01.DBF";
set newname for datafile 6 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SPCDEMO01_159.DBF";
set newname for datafile 7 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SPCDEMO02_159.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
Starting restore at 18-JUL-08
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
restoring datafile 00004 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
restoring datafile 00005 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\EXAMPLE01.DBF
restoring datafile 00006 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SPCDEMO01_159.D
BF
restoring datafile 00007 to D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SPCDEMO02_159.D
BF
channel ORA_AUX_DISK_1: reading from backup piece D:\ORACLE\PRODUCT\10.2.0\FLASH
_RECOVERY_AREA\ORCL\BACKUPSET\2008_07_18\O1_MF_NNNDF_TAG20080718T175152_4812Q37T
_.BKP
ORA-19870: error reading backup piece D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AR
EA\ORCL\BACKUPSET\2008_07_18\O1_MF_NNNDF_TAG20080718T175152_4812Q37T_.BKP
ORA-19505: failed to identify file "D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA
\ORCL\BACKUPSET\2008_07_18\O1_MF_NNNDF_TAG20080718T175152_4812Q37T_.BKP"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified
failover to previous backup
=====================================================
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ========
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/18/2008 18:00:08
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 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
=====================================END=================
Kindly suggest
|
|
|
|
| Re: Auxiliary database [message #334865 is a reply to message #334862] |
Fri, 18 July 2008 07:40  |
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
|
Senior Member |
|
|
Hi
However i checked backup is exist using
===================================
crosscheck backup
===================================
also i checked at O/s level
still i m getting same error kindly suggest
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Auxiliary database [message #334910 is a reply to message #334906] |
Fri, 18 July 2008 11:00 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
| tkmittal1 wrote on Fri, 18 July 2008 08:50 | Backup Set on seprate disk but on network
|
While the above is likely true, it does not signify that RMAN has necessary permissions to "see" or access these files.
[Updated on: Fri, 18 July 2008 11:01] by Moderator Report message to a moderator |
|
|
|
| Re: Auxiliary database [message #334912 is a reply to message #334910] |
Fri, 18 July 2008 11:10 |
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
|
Senior Member |
|
|
Sorry, But i am unable to understand what you want to say. what i understand that
1. My Backup set on remote location or on the target server.
2. But i am unable to read the backup set if i restore and recover any data file on target database itself from remote location or from catalog PC.
3. Should i map the drive of Backup set on Axuiliary Database Machine.
I also checked the basic requirments.
Kindly guide me
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
