| TSPITR problem [message #251312] |
Thu, 12 July 2007 19:40  |
abo_mahmoud
Messages: 31
Registered: May 2006
Location: UAE
|
Member |
|
|
I'm trying to make a TSPITR recovery adn I had a problem with the auxiliary instance as shoen in the following code . . .
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 12 22:28:23 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1149657212)
RMAN> RUN
2> {
3> ALLOCATE CHANNEL MY_CHANNEL TYPE DISK;
4> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
5> SET NEWNAME FOR DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MYDATAFILE.DBF' TO 'e:\new folder (3)\MYDATAFILE.DBF';
6> RECOVER TABLESPACE 'MYTABLESPACE' UNTIL TIME "TO_DATE('2007-07-12 10:27:00','YYYY-MM-DD HH24:MI:SS')" AUXILIARY DESTINATION 'e:\new folder (3)';
7> SQL 'ALTER TABLESPACE "MYTABLESPACE" ONLINE';
8> }
9>
using target database control file instead of recovery catalog
allocated channel: MY_CHANNEL
channel MY_CHANNEL: sid=132 devtype=DISK
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
executing command: SET NEWNAME
Starting recover at 12-JUL-07
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified point in time
List of tablespaces expected to have UNDO segments
tablespace SYSTEM
tablespace UNDOTBS1
Creating automatic instance, with SID='jmkx'
released channel: MY_CHANNEL
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/12/2007 22:28:36
ORA-19852: error creating services for auxiliary instance jmkx (error 0)
ORA-27302: failure occurred at:
ORA-27303: additional information: failed to start instance
Recovery Manager complete.
Where is the problem?
|
|
|
|
|
|
 Re: TSPITR problem [message #253427 is a reply to message #251313] |
Mon, 23 July 2007 19:16  |
orapro
Messages: 1
Registered: July 2007
Location: syria
|
Junior Member |
|
|
Hello again ...
believe me, i tried to change all the parameters associated to the TSPITR but it didn't worked, the problem is that ORACLE can't create an auxiliary database for the recovery completion, and i'm stuck in the middle of no where, and i don't know how to solve this problem, please help me .... any one!!!
[Updated on: Mon, 23 July 2007 19:20] Report message to a moderator |
|
|
|
| Re: TSPITR problem [message #253430 is a reply to message #253427] |
Mon, 23 July 2007 19:45 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
If you already tried to do a TSPITR and it failed, then you may need to clean up the old attempt with:
SQL> exec dbms_backup_restore.manageauxinstance ('TSPITR',1); |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
