Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: OK here is the scenario
Well, here is a new question. I completed the recovery of the
database... however I had no access to the enterprise database console
via IExplorer..... so I guessed :) I went to database configuration and
got it set up in there... it asked what password to use for everyone
and I entered the same password.... oddly it will no longer let me into
the database... it says my password is invalid.... is there a way to
reset the password?
Doug
Questions never end......
hpuxrac wrote:
> Doug Jones wrote:
> > Well I have been reading and I know I need to continue to spend time in
> > doing so.
> > My question about the RMAN backup command is not asking for all the
> > backup scenarios, but rather a 'catch all' backup. I am at backup
> > attempt 11, and no matter what I backup I am missing "something" first
> > it was control file, etc etc etc..... but now it seems that I can't
> > recover after the restore because my log files aren't present... so,
> > what do I need to include in RMAN's backup command to get the log files
> > backed up? The only thing I have found usable was when I went into the
> > Enterprise console in IE and performed that backup there... but I want
> > to familiarize myself with RMAN..... This is all in a test environment,
> > so no one worry about "bad advice".......... I learn more from doing
> > than I do from reading.....
> >
> > Thanks All...
>
> For doing what you are attempting to do, I would recommend using a
> recovery catalog.
>
> Something like this ...
>
> 1) backup the database including the current control file ...
> 2) switch archive logs then ...
> 3) backup the archive logs
> 4) export the recovery catalog
>
> On your recovery machine ...
>
> 1) build a recovery catalog database and import the exported recovery
> catalog
> 2) do some pre setup for the database you are going to restore/recover
> 3) restore the archive logs
> 4) restore the database
> 5) recover the database until no more archive logs
>
> Or I go back to my other question ... have you followed the steps that
> whatever article that you are following told you to do exactly?
>
> Have you contacted the authors?
>
> It is not rocket science but it can be tricky complicated and
> frustrating.
>
> Have fun.
Received on Tue Oct 03 2006 - 15:26:09 CDT