Help me to startup my DB.....

[Former Member]

  Hi Friend,

I have stuck in to startup the db from SQL prompt.

Actually I have restore the full Offline backup into diff SID for preparing the Pre Prod server.

I have completed the my restoration part successfully.

When I try to startup command
from orasid its giving error massage.

ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/AQT/sapdata4/system_1/system.data1'

SQL> alter database open NORESETLOGS;
alter database open NORESETLOGS
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/AQT/sapdata4/system_1/system.data1'

SQL> alter database recover datafile '/oracle/AQT/sapdata4/system_1/system.data1';
alter database recover datafile '/oracle/AQT/sapdata4/system_1/system.data1'
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 754029472 generated at 02/10/2014 12:08:37 needed for thread
1
ORA-00289: suggestion : /oracle/AQT/oraarch/AQTarch1_1_839160509.dbf
ORA-00280: change 754029472 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/oracle/AQT/oraarch/AQTarch1_1_839160509.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/oracle/AQT/oraarch/AQTarch1_1_839160509.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/AQT/sapdata4/system_1/system.data1'

SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/AQT/sapdata4/system_1/system.data1'

SQL> alter database recover datafile '/oracle/AQT/sapdata4/system_1/system.data1';
alter database recover datafile '/oracle/AQT/sapdata4/system_1/system.data1'
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL>
SP2-0734: unknown command beginning "sele..." - rest of line ignored.
SQL>
SQL>
SQL>
  2
SQL>
SQL> select status from v$instnace;
select status from v$instnace
                   *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only

SQL> select status from v$instance;

STATUS
------------
MOUNTED

Some please help me for this
issue 

Thanks & Regards,

Mohd Zaheer Parveaz

[bxiv]

I think you have the wrong space on SCN, TDMS is for data refreshes; try posting in your DB specific or a Netweaver space.