Re: questiones

In article <968fie$o9o$1_at_nnrp1.deja.com>,   alexberi_at_my-deja.com wrote:
>
>
> 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?
> -When I want to delete some old ArchiveLog files, how do I delete
> references to them from Control File and RMAN recovery catalog?
> -Finaly, where I find the Alert Log?
>
> Thx, Alex.
>
> Sent via Deja.com
> http://www.deja.com/
>

1 As you don't mention your platform this is a bit difficult to answer. The default for Unix is $ORACLE_HOME/dbs/orapw<SID> You always use a password file
2 yes.
3 Obviously you can delete old archivelog files only *after* a cold,consistent backup, and after a separate backup during your hotbackup. You should not manipulate the controlfile nor RMAN as the software is already taking into account which archivelogs it needs and which it doesn't. Manipulating the controlfile or the RMAN catalog yourself is one of the most efficient Career Limiting Moves (tm) 4 The alert is by design in the background_dump_dest directory.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/