OraFAQ Forum: Backup & Recovery » How to startup Oracle without backups of archive log & control file

Home » RDBMS Server » Backup & Recovery » How to startup Oracle without backups of archive log & control file (Oracle 10g R2, RHEL4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to startup Oracle without backups of archive log & control file [message #293523]

Sun, 13 January 2008 22:23

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'

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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'

Report message to a moderator

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Archive log before full backup
Next Topic:	target database connection error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:00:43 CST 2024