Home » RDBMS Server » Backup & Recovery » Auxiliary database (Oracle Database 10g R2 on windows 2003)
Auxiliary database [message #334862] Fri, 18 July 2008 07:37 Go to next message
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 Go to previous messageGo to next message
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 #334881 is a reply to message #334865] Fri, 18 July 2008 09:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Is the clone instance in the same node or other node?
If in other node, are the backupsets made visisble as if it is local?
Re: Auxiliary database [message #334899 is a reply to message #334881] Fri, 18 July 2008 10:18 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi

This is on Remote Machine
Re: Auxiliary database [message #334900 is a reply to message #334899] Fri, 18 July 2008 10:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You still did not answer to the second question.
How did make the backupsets visible to second server.
Re: Auxiliary database [message #334901 is a reply to message #334900] Fri, 18 July 2008 10:24 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Backup set in on remote location or on Primary database

it is visiable on network

Re: Auxiliary database [message #334902 is a reply to message #334901] Fri, 18 July 2008 10:30 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Waiting for you are reply
Re: Auxiliary database [message #334903 is a reply to message #334901] Fri, 18 July 2008 10:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>it is visiable on network
You mean to say,
you have shared the "D:\ORACLE\PRODUCT\10.2.0..."? (in primary) to
auxillary server?
Even if this works, it seems like an ORACLE_HOME. You do not want to share this.
Always create backups (or FRA) in a separate disk

These files should like a local filesystem in your remote node,
you are also trying to restore to the same filesystem?
Quote:
set newname for datafile 1 to
"D:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF";

Please make sure you have adhered to basic requirements
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov002.htm#sthref723

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtroub004.htm#sthref1227

[Updated on: Fri, 18 July 2008 10:36]

Report message to a moderator

Re: Auxiliary database [message #334904 is a reply to message #334862] Fri, 18 July 2008 10:37 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

NOBODY owes you any response.

You claim files should be 'visible'.
Oracle reports it can not find necessary files.
I believe Oracle more accurately reports reality.
It is your task to absolutely, positively, & with 100% certainty that Oracle can locate the files it needs.
Only YOU can do that on YOUR systems.
Please proceed to do so.
Re: Auxiliary database [message #334906 is a reply to message #334904] Fri, 18 July 2008 10:50 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Backup Set on seprate disk but on network
Re: Auxiliary database [message #334910 is a reply to message #334906] Fri, 18 July 2008 11:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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 Go to previous messageGo to next message
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
Re: Auxiliary database [message #334915 is a reply to message #334862] Fri, 18 July 2008 11:15 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14193/toc.htm
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/toc.htm

When all else fails, Read The Fine Manual.
Re: Auxiliary database [message #334916 is a reply to message #334912] Fri, 18 July 2008 11:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>1. My Backup set on remote location or on the target server.
Is that a question, or an answer to our question or just a statement?
>>3. Should i map the drive of Backup set on Axuiliary Database Machine.
yes.
that is what we are trying to say.
The backupsets should be "visible" to the axillary server like a local disk.
You can map/share the drive
or
copy the backupsets to a local drive.
Also you may want to use TSPITR duplication by specifying TIME or SCN.
Re: Auxiliary database [message #335035 is a reply to message #334912] Sat, 19 July 2008 15:53 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
seems like ths forum is getting more and more like oracle.com/technology forums. people moaning all the time about the questions.

It is quite simple

read the question, if you do not consider it worthy of a response, then dont respond.

If you do respond please be pleasant about it and guide the OP

to the OP

I will look at this for you on monday

regards

Alan
Re: Auxiliary database [message #335313 is a reply to message #334862] Mon, 21 July 2008 17:18 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I will look at this for you on monday
or not. schedule slip?
Previous Topic: Change Backup Destination
Next Topic: looking 4 links for practice
Goto Forum:
  


Current Time: Fri Dec 09 05:43:57 CST 2016

Total time taken to generate the page: 0.18500 seconds