Oracle Database Discussions

Hi

i have copied database from 11g --> 11g

and recovered target db until poin in time

but cannot open db due to worng undo tablespace name in target pfile than in source database, so i have changed undo name in parameter file of target . when i try to open db i get below error


SQL> select distinct status from v$datafile;

STATUS
-------
ONLINE
SYSTEM


SQL> select * from v$recover_file;

no rows selected



SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/N6Q/sapdata1/system_1/system.data1'



SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 43200
undo_tablespace string PSAPUNDO2

SQL> select NAME from v$tablespace where NAME='PSAPUNDO2';

NAME
------------------------------
PSAPUNDO2


pelase help me .. Thanks