Re: questiones

<alexberi_at_my-deja.com> wrote in message news:968fie$o9o$1_at_nnrp1.deja.com...
>
>
> Hi,
> I have some simple questions, but I couldn't find the answers by now:
> -How can I see if I use o password file and where it is?
> -For a COLD backup of whole database, do I need to backup Redo Logs?

You don't "need" to, but nearly everyone does, and it makes sense to do so. If you are doing cold backups because you are NOT in archivelog mode, then they come in VERY useful. If you are doing hotbackups, then I question the practice, only because I have seen people restore *.*, and thus over-write perfectly good online redo logs.

> -When I want to delete some old ArchiveLog files, how do I delete
> references to them from Control File and RMAN recovery catalog?

Don't worry about the Control File -it will forget about them after 7 days (by default) anyway. Use the "CHANGE" command in RMAN to uncatalog archivelogs -but again, if you just let things rip, RMAN will forget about it naturally anyway (everytime it does a backup, for example, it resynchs with the control file -so if the control file has forgotten about a log, so will RMAN).

> -Finaly, where I find the Alert Log?

It's in the BACKGROUND_DUMP_DEST. Work out what actual directory that maps to by reading your init.ora.

Regards
HJR
>
> Thx, Alex.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Feb 12 2001 - 05:42:28 CST