recover database

[Former Member]

Dear all

PLease help urgen basis

what is the next step , i have follows please advise

mens auto,cancel or file name please advise

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\devadm>CD\

C:\>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Aug 31 12:19:19 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn /as sysdba

Connected.

SQL> SELECT NAME FROM V$DATAFILE WHERE STATUS = 'OFFLINE';

no rows selected

SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE STATUS = 'OFFLINE';

no rows selected

SQL> SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';

NAME

-

---

J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1

SQL> RECOVER DATAFILE 'J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1'

ORA-00283: recovery session canceled due to errors

ORA-01124: cannot recover data file 2 - file is in use or recovery

ORA-01110: data file 2: 'J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1'

SQL> shutdown immediate

ORA-00376: file 2 cannot be read at this time

ORA-01110: data file 2: 'J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1'

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 4580179968 bytes

Fixed Size 2059600 bytes

Variable Size 1308623536 bytes

Database Buffers 3254779904 bytes

Redo Buffers 14716928 bytes

Database mounted.

Database opened.

SQL> SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';

NAME

-

---

J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1

SQL> RECOVER DATAFILE 'J:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1'

ORA-00279: change 2190697390 generated at 08/28/2009 12:31:16 needed for thread

1

ORA-00289: suggestion : C:\ORACLE\DEV\ORAARCH\DEVARCHARC39639_0562173838.001

ORA-00280: change 2190697390 for thread 1 is in sequence #39639

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

thanks

with best regards

venkat

[anindya_bose · Accepted solution]

>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Select "AUTO"

Press Enter

[Former Member · Accepted solution]

Hi

You can select auto or recover until time 'xxxx:xxxx:xxxx:xxxx'