Home » RDBMS Server » Backup & Recovery » How to startup Oracle without backups of archive log & control file (Oracle 10g R2, RHEL4)
How to startup Oracle without backups of archive log & control file [message #293523] Sun, 13 January 2008 22:23 Go to next message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Hi all,

There's was a problem in disk7, after restart the server. It was accessible & can write to it. But Oracle can't still startup. We have no backup of control & archive log files.

Please help how to startup Oracle without backups of archive log & control file?

[oracle@localhost disk7]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jan 14 12:57:32 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> alter database open;
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: '/home/oracle/oradata/UCCS/system01.dbf'

Re: How to startup Oracle without backups of archive log & control file [message #293533 is a reply to message #293523] Mon, 14 January 2008 00:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't need to have a backup of control file as it is still there.
You need the archived logs in order to recover.
If you have none of them then you have to restore from a cold backup.

Regards
Michel
Re: How to startup Oracle without backups of archive log & control file [message #293536 is a reply to message #293523] Mon, 14 January 2008 00:12 Go to previous messageGo to next message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

Thanks Michel,

I haven't any of the cold backups. I need to open the database urgently, how can I ignore this error & last database changes to startup?
Re: How to startup Oracle without backups of archive log & control file [message #293542 is a reply to message #293536] Mon, 14 January 2008 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on why you have tbis message:
Quote:

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

That is on what you did before startup or what is missing.

Regards
Michel
Re: How to startup Oracle without backups of archive log & control file [message #293640 is a reply to message #293523] Mon, 14 January 2008 06:10 Go to previous messageGo to next message
bbmonster
Messages: 47
Registered: June 2007
Location: UB
Member

I opened the database by changing the undo_management=manual,
now I want to delete corrupted datafile's tablespace.

SQL> drop tablespace DAT10200712 including contents;
drop tablespace DAT10200712 including contents
*
ERROR at line 1:
ORA-14404: partitioned table contains partitions in a different tablespace

Then I moving partitions to another tablespace, partitions in the corrupted data file's don't work. The following error occurs what should I do in order to delete corrupted tablespace?
ORA-00376: file 120 cannot be read at this time
ORA-01110: data file 120: '/disk7/DATA10200712_3'
Re: How to startup Oracle without backups of archive log & control file [message #293645 is a reply to message #293640] Mon, 14 January 2008 06:31 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not mean the partition is corrupted but your file cannot be read by Oracle.
Investigate the reason.

Regards
Michel
Previous Topic: Archive log before full backup
Next Topic: target database connection error
Goto Forum:
  


Current Time: Fri Dec 09 13:25:18 CST 2016

Total time taken to generate the page: 0.19511 seconds