Re: Oracle Backup Recovery and Roles Questions ?

Tapas

It looks as if the database is not in Archive log mode or the archive logs are not going into the directory you expect. RMAN does not backup online redo logs only archived redo logs. You can only do complete recovery if the required archive redo logs are available.
Have you backed up the Archive redo logs? If so can you recover them? As far as I am aware RMAN will control doing the archive log all commands as part of an archive log backup.

For the roles question. There is an init parameter that sets the prefix for OS role authentication - OS_AUTHENT_PREFIX usually this is set to OPS$. Therefore when you create an OS authenticated user the Oracle username is prefixed with OPS$. The oracle user also has to identified externally.

Hope this is a start

Nathan

"Tapas Guha" <tguha_at_hotmail.com> wrote in message news:uGF48.25587$KC1.4725937_at_news20.bellglobal.com...
> Hi All,
> I have 2 issues i would like to know the solutions.
> Environment : OS-Windows/NT40 Server
> Database: Oracle Datbase 8.1.6
>
> I am trying to restore database in the following scenario.
> I have a complete database backup (level0)
> I have a incremental database backup (level1)
> I have no files in archive log directory.
> Before backup the database i have archived log all.
>
> Now I restored the complete database and then i restored the incremental
> backup using noredo command.
> After that, oracle is asking for redo log files for media recovery.
>
> My question is
> 1. Does RMAN doesn't back up the current redo logs during comple database
 or
> incremental database backup ?
>
> How possibly I can backup online redo logs ?
>
> Roles Question
> I want to test the feature of Enabling OS roles feature.
> When i enable os roles paramter in init.ora files, I don't see the
> corresponding roles being granted to the user.
>
> Can anyone explain the steps of enabling OS roles features in NT
> environments ?
>
> Thanx in advance for clues/suggestions.
> Email:tguha_at_hotmail.com
>
>
Received on Sun Jan 27 2002 - 13:23:28 CET