Home » RDBMS Server » Backup & Recovery » dB can't produce archived log files (Oracle 10g R2, Solaris 10)
dB can't produce archived log files [message #480790] Wed, 27 October 2010 03:56 Go to next message
reym21
Messages: 178
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.
Re: dB can't produce archived log files [message #480791 is a reply to message #480790] Wed, 27 October 2010 04:02 Go to previous messageGo to next message
Littlefoot
Messages: 19540
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that your database is in NOARCHIVELOG mode. Is it?
Re: dB can't produce archived log files [message #480794 is a reply to message #480791] Wed, 27 October 2010 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...or maybe the archived log destination is not "/u1archive".

Regards
Michel
Re: dB can't produce archived log files [message #480798 is a reply to message #480791] Wed, 27 October 2010 04:47 Go to previous messageGo to next message
reym21
Messages: 178
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.




Re: dB can't produce archived log files [message #480800 is a reply to message #480798] Wed, 27 October 2010 05:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10621
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
Re: dB can't produce archived log files [message #480809 is a reply to message #480798] Wed, 27 October 2010 06:33 Go to previous message
Michel Cadot
Messages: 58959
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
Previous Topic: How to Take Backup on every 30 Min
Next Topic: Datafile recovery concept
Goto Forum:
  


Current Time: Tue Sep 02 19:38:21 CDT 2014

Total time taken to generate the page: 0.47861 seconds