Re: could not log into database

Hi Tim,

thanks for your answer.

I will change the place of the archived log files to another disk. We make backup every day using export and rman and it's save, we needed it more than once.
The archive logs are written only to one place in the filesystem and from there written to tape
during the nightly filesystem backup.

regards
uwe

"Tim Kearsley" <tim.kearsley_at_milton-keynes.gov.uk> schrieb im Newsbeitrag news:725736ef.0210310157.5c55c60d_at_posting.google.com...
>
> Hi Uwe,
>
> Several points from your posting:
>
> It's definitely a BAD idea to have your archived redo logs in the same
> filesystem as your database files, both from a security and, to a
> lesser extent, from a performance perspective. I realise you may not
> be in a position to change that immediately, but it's worth bearing in
> mind to do so if you possibly can.
>
> The fact that you say that most of the time there is 25 GBytes free in
> the filesystem suggests to me that you have a scheduled job which is
> moving archive logs elsewhere at regular intervals. Increasing the
> frequency of that job would help alleviate the space problems. As to
> how large the space allocated to archive logs should be, well that's a
> matter for your own judgement really. We normally keep about 14 days
> of logs online, even though we backup the databases every night.
> Beyond that, we would have to restore logs from tape. But it really
> does depend on your own situation. The more frequently you do backups
> of your database the less archive logs you will need to recover.
> Obviously if you need to restore logs from tape your downtime during
> recovery will be greater.
>
> Bear in mind how *critical* archive logs are in ensuring the security
> of your data. Are your logs written to multiple locations (the
> LOG_ARCHIVE_DEST_n parameter in your init.ora file) and/or are the
> logs mirrored in hardware? Sorry if I'm teaching you to suck eggs,
> but I know from bitter experience how important archive logs are!
>
> All the best.
>
> Tim Kearsley
> Database Manager
> Milton Keynes Council
Received on Thu Oct 31 2002 - 08:11:57 CST