Home » RDBMS Server » Backup & Recovery » TSPITR - ORA-1955
TSPITR - ORA-1955 [message #155377] Sun, 15 January 2006 12:05
sphinxo
Messages: 4
Registered: January 2006
Location: Jakarta
Junior Member

Dear Oracle Expert,

I struggling with tablespace poin in time recovery again.
the last one still not solve,
and now i have a problem again. Sad

i do this 2 RMAN command :

run {
set until scn 588144;
restore ( tablespace 'EXAMPLE' );
}

and

RMAN> run {
allocate channel Channel1 type disk format 'C:\ORACLE\ORADATA\NVTEST\B_07H8LDK0_1_1';
sql 'alter tablespace "EXAMPLE" offline immediate';
set until scn 588144;
restore ( tablespace 'EXAMPLE' );
}


and those syntax gives me an error :

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/12/2006 09:57:10
ORA-19505: failed to identify file "C:\ORACLE\ORADATA\NVTEST\B_01H81GAC_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Do you know how to change the file reference when doing restore another tablespace??
because this filename (B_01H81GAC_1_1) refer to another TEST TableSpace.

Thanks and Regards,
Novianto


Previous Topic: help confirm this procedure
Next Topic: how to couple archived redo logs backup and cold backup together
Goto Forum:
  


Current Time: Mon Dec 23 04:07:35 CST 2024