Home » RDBMS Server » Server Administration » Archive log issue (Oracle 10g,Linux)
Archive log issue [message #606059] Sat, 18 January 2014 12:48 Go to next message
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,
Re: Archive log issue [message #606062 is a reply to message #606059] Sat, 18 January 2014 13:24 Go to previous messageGo to next message
Frank Naude
Messages: 4412
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.

[Updated on: Sat, 18 January 2014 13:25]

Report message to a moderator

Re: Archive log issue [message #606065 is a reply to message #606059] Sat, 18 January 2014 14:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Archive log issue [message #606087 is a reply to message #606065] Sun, 19 January 2014 12:41 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22500
Registered: January 2009
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?
Re: Archive log issue [message #606091 is a reply to message #606087] Sun, 19 January 2014 13:13 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
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.



Re: Archive log issue [message #606092 is a reply to message #606091] Sun, 19 January 2014 13:45 Go to previous messageGo to next message
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
Re: Archive log issue [message #606093 is a reply to message #606092] Sun, 19 January 2014 13:58 Go to previous messageGo to next message
Michel Cadot
Messages: 58558
Registered: March 2007
Location: Nanterre, France, http://...
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?


Re: Archive log issue [message #606102 is a reply to message #606087] Sun, 19 January 2014 17:31 Go to previous messageGo to next message
EdStevens
Messages: 227
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.

Re: Archive log issue [message #606532 is a reply to message #606102] Sat, 25 January 2014 15:21 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thanks Stevens
Previous Topic: Creating PeopleSoft Environment
Next Topic: Module not getting populated in V$SESSION
Goto Forum:
  


Current Time: Fri Jul 25 09:34:00 CDT 2014

Total time taken to generate the page: 0.94012 seconds