Re: OK here is the scenario

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 - 12:42:37 CDT