Re: Trying to restore RMAN backup in new server, got error RMAN-06172

From: Big George <>
Date: Wed, 22 Jun 2011 12:41:11 -0700 (PDT)
Message-ID: <>

Thank you John, I could mount my database in target server. Now I'm facing another problem with RMAN backups, they don't get recognized. I will open a new question for that.

> If your existing server that this backup is based on is still running
> I would create a copy of the spfile from that server and startup your
> instance with a startup pfile= type thing.
> You can always recreate the spfile from a pfile.
> I follow all my rman backups with ( at least ) 2 commands ...
> sqlplus based ...
> create pfile='/somewhere/something_pfile_backup.ora' from spfile;
> rman based ...
> copy current controlfile to '/somewhere/something_ctrlfile_copy.ctl';
> This gives you a file based copy of both the spfile and the control
> file.  You probably want a copy of both of these after each backup.
Received on Wed Jun 22 2011 - 14:41:11 CDT

Original text of this message