| taha |
Posted: Oct 23, 2005 04:17:40 AM |
Total Post: 4
Joined: Oct, 2005
|
Hi All,
Any body can help me please,
I Have an Oracle Database on WIN2000 Server, the PC gets unproper shutdown, and after that, the databse never started, It's Giving Errors
ORA-01122 and ORA-01267
Please help me gitting My Database Up.
regards
|
|
|
 Vigyan |
| Posted: Oct 23, 2005 05:23:54 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Mount the database with "Startup mount" option then follow the steps below.
Alter database backup controlfile to trace;
Create a control file creation script from the tracefile generated in user_dump_dest dir. Remember to use the Noresetlogs option.
shutdown the database and start it NOMOUNT mode as follows.
shutdown abort;
startup NoMount;
Recover database;
Finally, recover the database.
Alter database open;
Hope it helps.
Vigyan
|
|
|
|
|
| taha |
| Posted: Oct 24, 2005 04:00:00 AM | |
|
Total Post: 4
Joined: Oct, 2005
|
Thank you very much Mr.Vigyan,
I've done the steps, but I've got another error
ORA-01113: file 1 need media recovery
ORA-01110: data file 1: 'c:\oracle\oradata\gnr\system01.DBF'
Can you advice please,
hashims
|
|
|
|
|
| Vigyan |
| Posted: Oct 24, 2005 11:09:34 PM | |
|
Total Post: 386
Joined: May, 2001
|
If this is your not a production database and you are not worry about the point in time recovery then try to create control file with Resetlogs option.
Write me back with the all steps that you are following if you have problem.
Good Luck.
Vigyan
|
|
|
|
|
| taha |
| Posted: Oct 25, 2005 07:28:44 PM | |
|
Total Post: 4
Joined: Oct, 2005
|
Hi Mr. Vajian
Sory for disturbing you,
I'm trying to get what ever the best i can get out of my database, some thing better than nothing !!!
I Have Done the following steps :
ALter database backup controlfile to trace;
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "GNR" RESETLOGS NOARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'C:\ORACLE\ORADATA\GNR\REDO01.LOG' SIZE 100M,
GROUP 2 'C:\ORACLE\ORADATA\GNR\REDO02.LOG' SIZE 100M,
GROUP 3 'C:\ORACLE\ORADATA\GNR\REDO03.LOG' SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'C:\ORACLE\ORADATA\GNR\SYSTEM01.DBF',
'C:\ORACLE\ORADATA\GNR\UNDOTBS01.DBF',
'C:\ORACLE\ORADATA\GNR\CWMLITE01.DBF',
'C:\ORACLE\ORADATA\GNR\DRSYS01.DBF',
'C:\ORACLE\ORADATA\GNR\EXAMPLE01.DBF',
'C:\ORACLE\ORADATA\GNR\INDX01.DBF',
'C:\ORACLE\ORADATA\GNR\ODM01.DBF',
'C:\ORACLE\ORADATA\GNR\TOOLS01.DBF',
'C:\ORACLE\ORADATA\GNR\USERS01.DBF',
'C:\ORACLE\ORADATA\GNR\XDB01.DBF'
CHARACTER SET AR8MSWIN1256
;
RECOVER DATABASE USING BACKUP CONTROLFILE
All the above statments were executed successfully
But :-(
When I Executed the command
ALTER DATABASE OPEN RESETLOGS;
I've got the Error ...
*
Error at Line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
----------------
What shull i do,
please advice
regards and very sory to distureb you
hashims
|
|
|
|
|
| taha |
| Posted: Oct 30, 2005 02:26:42 AM | |
|
Total Post: 4
Joined: Oct, 2005
|
Any Body can help me to get my data please ...........
Hashims
|
|
|
|
|
| Vigyan |
| Posted: Dec 30, 2005 10:38:33 AM | |
|
Total Post: 386
Joined: May, 2001
|
Sorry, I didn't saw your reply.
Not sure if you still have this problem. If you do then can you let me know the error message from your alert.log file?
Vigyan
|
|
|
|
|
| Yogesh |
| Posted: Jan 02, 2006 10:26:03 PM | |
|
Total Post: 10
Joined: Dec, 2005
|
Hi,
I am facing the Table autoextend problem. When I try to add some record in a table then I am getting the following error:
DATABASE ERROR:
Database Error Message - ^ORA-01653: unable to extend table TBAADM.ACCT_MASTER_TABLE by 32 in^
DBLayer Error Code = ^[DBL-1653]^ Operation: ^[I] ^Database Query - ^[Not available] ^Bind Variables - ^Not available ^
I tried the following with users as system/manager and also by sysdba:
SQL>update dba_data_files set AUTOEXTENSIBLE ='YES' where TABLESPACE_NAME ='ACCT_DETAILS';
But, I got the following error:
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
Even after resizing the tablespace I am not able to resolve this issue. Kindly help me in resolving the issue.
Regards.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
