on 08-31-2009 8:04 AM
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
>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Select "AUTO"
Press Enter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
73 | |
11 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.