Re: OK here is the scenario

Thanks for the info....

Is there a "backup" command that will allow me to have all the files I need to for the recovery of the database on a new host? This question doesn't seem like it would need more information, but does it? If so, why? :) I feel like a 2 yr old.. why why why why... It seems that is all I can say and "huh?"

Thanks

Doug

Not having much fun yet... learning new things sucks...

hpuxrac wrote:
> Doug Jones wrote:
> > Fair enough - just do remember that I have been working with Oracle for
> > 3 weeks. No prior experience.
> >
> >
> > > Where in this post is version information?
> > This is for Oracle 10g 10.2 (enough info?)
> >
> > > Where in this post is information on the nature of the backup?
> > Nature of the backup is part of my question. If I am wanting to create
> > a backup that I can use to restore to a new host, what would be the
> > full syntax for the backup command.
> >
> > > Where in this post is the actual error message?
> > Well this changes frequently. It isn't so much of an error message that
> > is the problem as it is my lack of knowledge. I am attempting to
> > restore data from a backup I created on to a new host. I am using a
> > walk through I found on the internet. The walk through does not include
> > what to enter for the backup command and I end up with insufficient
> > backups to restore. Missing logs, or not backed up in a way that RMAN
> > can use them.
> >
> > > Where in this post is the script used to create the backup?
> > That is one of my questions. What script should I use to get a complete
> > back up that I can relocate to a new host.
> >
> > > Where in this post is the script used to perform the restore?
> > http://www.orafusion.com/art_rman3.htm
> >
> >
> > Hope that is enough information.
> >
>
> Here is what I think you might want to consider. RMAN is a powerful
> but complicated tool. You might want to extensively read the oracle
> documentation ( http://tahiti.oracle.com ) or buy and read acouple of
> books. Robert Freeman has a good 9i RMAN book with a 10g one coming
> out in less than a month.
>
> I would recommend sitting down with that documenation and read it until
> you have a feeling for whats going on. Try some things on a test
> machine ... get comfortable with how the product works and thinks.
>
> As far as doing exactly what you are trying to do I would ask a couple
> of questions. Did you follow the instructions exactly as they are in
> the articles? One or two changes in how you did things versus how the
> authors proceeded can be fatal.
>
> Finally the authors provided an email address. Since you are having
> problems apparently following their instructions maybe you could
> contact them?
>
> Have fun.
Received on Tue Oct 03 2006 - 13:32:37 CDT