OraFAQ Forum: Backup & Recovery » dB can't produce archived log files

Home » RDBMS Server » Backup & Recovery » dB can't produce archived log files (Oracle 10g R2, Solaris 10)

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

dB can't produce archived log files [message #480790]

Wed, 27 October 2010 03:56

reym21
Messages: 167
Registered: February 2010
Location: Philippines

Senior Member

I'm wondering how our new production dB doesn't produce any archived log files since it was launch last August of this year. I can't see any of the said files specified at the /u1archive directory of the server.

Any advice would be highly appreciated.

Thank you.

Report message to a moderator

Re: dB can't produce archived log files [message #480791 is a reply to message #480790]

Wed, 27 October 2010 04:02

Littlefoot
Messages: 16967
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that your database is in NOARCHIVELOG mode. Is it?

Report message to a moderator

Re: dB can't produce archived log files [message #480794 is a reply to message #480791]

Wed, 27 October 2010 04:35

Michel Cadot
Messages: 54167
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

...or maybe the archived log destination is not "/u1archive".

Regards
Michel

Report message to a moderator

Re: dB can't produce archived log files [message #480798 is a reply to message #480791]

Wed, 27 October 2010 04:47

reym21
Messages: 167
Registered: February 2010
Location: Philippines

Senior Member

Thanks for this.

I tried selecting the v$archived_log and it shows "no rows selected". The init.ora file has no referenced for the NOARCHIVELOG MODE (whether TRUE or FALSE), but it had a log_dest_archive path and a log_archived_files format.

Report message to a moderator

Re: dB can't produce archived log files [message #480800 is a reply to message #480798]

Wed, 27 October 2010 05:28

Mahesh Rajendran
Messages: 10572
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post the output of archive log list command.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12007.htm

Report message to a moderator

Re: dB can't produce archived log files [message #480809 is a reply to message #480798]

Wed, 27 October 2010 06:33

Michel Cadot
Messages: 54167
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I tried selecting the v$archived_log and it shows "no rows selected".

So nothing has been generated in the database as this view is filled whatever is the archive log mode.

Quote:

The init.ora file has no referenced for the NOARCHIVELOG MODE

This is not an instance property but a database one and so is not in the (instance) configuration file.
See v$database.

Regards
Michel

Report message to a moderator

Previous Topic:	How to Take Backup on every 30 Min
Next Topic:	Datafile recovery concept

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 18:48:03 CDT 2013

Total time taken to generate the page: 0.18801 seconds