Home » RDBMS Server » Backup & Recovery » TSPITR problem
TSPITR problem [message #251312] Thu, 12 July 2007 19:40 Go to next message
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 #251313 is a reply to message #251312] Thu, 12 July 2007 19:44 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
'e:\new folder (3)'


I GUESS THE PROBLEM IS SPACE use like

e:\backup
icon13.gif  Re: TSPITR problem [message #253427 is a reply to message #251313] Mon, 23 July 2007 19:16 Go to previous messageGo to next message
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 Go to previous message
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); 
Previous Topic: ORA-01180 & ORA-01110 errors with incremental level 0 backup
Next Topic: how to recover after lost of currnet redo log file (merged)
Goto Forum:
  


Current Time: Sat Dec 10 22:21:57 CST 2016

Total time taken to generate the page: 0.04393 seconds