1 2 Previous Next 16 Replies Latest reply: May 1, 2012 11:43 PM by kuljeet singh - RSS

    unable to make db up due to undo issue

    873236
      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
        1 2 Previous Next