OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Archive log issue (Oracle 10g,Linux)

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

Archive log issue [message #606059]

Sat, 18 January 2014 12:48

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

There is an incident when archive log files in /u03 mount point is missing due to unavailability of space and because of this issue , i am facing problem with bring up the database.Now how to recover the database ?

Regards,
Jack,

Report message to a moderator

Re: Archive log issue [message #606062 is a reply to message #606059]

Sat, 18 January 2014 13:24

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

sqlplus / as SYSDBA
SQL> STARTUP MOUNT
SQL> RECOVER DATABASE;
SQL> ALTER DATABASE OPEN;

And, if you get errors post them here.

Report message to a moderator

Re: Archive log issue [message #606065 is a reply to message #606059]

Sat, 18 January 2014 14:05

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

Senior Member
Account Moderator

Quote:

i am facing problem with bring up the database.

Which error exactly?

Quote:

Now how to recover the database ?

There is no need to recover a database because an archive log destination is full.

Report message to a moderator

Re: Archive log issue [message #606087 is a reply to message #606065]

Sun, 19 January 2014 12:41

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you all for answering my question in a decent manner.

I think my question is incomplete.let me rewrite it.

There is a full backup taken on sunday and everday we take incremental backup.Suddently on thursday archive log files
unable to occupy on archive log destination due to unavailability of space and at that time database got crashed all of a sudden.Now how to recover the database with thursday backup where archive log files are missing?

Thanks,
Jack

[Updated on: Sun, 19 January 2014 12:48]

Report message to a moderator

Re: Archive log issue [message #606088 is a reply to message #606087]

Sun, 19 January 2014 12:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

is COPY & PASTE broken for you?

Report message to a moderator

Re: Archive log issue [message #606091 is a reply to message #606087]

Sun, 19 January 2014 13:13

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

Senior Member
Account Moderator

Did you try what Frank wrote?
If yes, then copy and paste what you did and got.
If no, then do it.

Report message to a moderator

Re: Archive log issue [message #606092 is a reply to message #606091]

Sun, 19 January 2014 13:45

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Michel,

I am just asking this question in general.If Frank answer is correct, then i got answer to my question.

Regards,
jack

Report message to a moderator

Re: Archive log issue [message #606093 is a reply to message #606092]

Sun, 19 January 2014 13:58

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

Senior Member
Account Moderator

It depends on the actual, sometimes it is enough, sometimes not and as I said before, you don't need to recover the database just because your archive log destination is full.

And if this is a "question in general" why you said "There is an incident when archive log files in /u03 mount point is missing due to unavailability of space and because of this issue , i am facing problem with bring up the database."
You were lying?

Report message to a moderator

Re: Archive log issue [message #606102 is a reply to message #606087]

Sun, 19 January 2014 17:31

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Jack14 wrote on Sun, 19 January 2014 12:41

Thank you all for answering my question in a decent manner.

I think my question is incomplete.let me rewrite it.

There is a full backup taken on sunday and everday we take incremental backup.Suddently on thursday archive log files
unable to occupy on archive log destination due to unavailability of space and at that time database got crashed all of a sudden.Now how to recover the database with thursday backup where archive log files are missing?

Thanks,
Jack

your database is not/did not crash. It is simply refusing to do any more work until it can archive the redo logs. And that is pretty well spelled out in the alert log if you'd care to check it. resolve that and the database will go right back to work.

When you take your DB backups you should be also backing up and deleting the archivelogs. you may also need to have more frequent jobs to back up and delete just the accumulated archivelogs.

Report message to a moderator

Re: Archive log issue [message #606532 is a reply to message #606102]

Sat, 25 January 2014 15:21

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks Stevens

Report message to a moderator

Previous Topic:	Creating PeopleSoft Environment
Next Topic:	Module not getting populated in V$SESSION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 21:39:59 CST 2024