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.
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
|
|
|