Am I missing something entirely, or doesnt he need to specify the location
of the control files in the spfile or pfile? He is only specifying the
autobackup location in his rman command.
On Mon, Oct 23, 2017 at 3:35 PM, Gus Spier <gus.spier@xxxxxxxxx> wrote:
Please check the path to the location of the control files. One command
appears to put the control file in a subdirectory called
"/zfs/prod_backups/..." and the next tries to access the control file from
"/zfs/prod_backup/..." (note the term "backup" is not the same as
"backups".
Regards,
Gus
On Mon, Oct 23, 2017 at 4:28 PM, Chris Stephens <cstephens16@xxxxxxxxx>
wrote:
it does. however the controlfile isn't actually restored to the
specified location.
channel c1: control file restore from AUTOBACKUP complete
Finished restore at 17-10-23 15:27
released channel: c1
On Mon, Oct 23, 2017 at 3:25 PM Seth Miller <sethmiller.sm@xxxxxxxxx>
wrote:
Chris,
Does the run block succeed without the ALTER DATABASE MOUNT?
Seth Miller
On Mon, Oct 23, 2017 at 3:20 PM, Chris Stephens <cstephens16@xxxxxxxxx>
wrote:
Oracle 12.1.0.2 on Linux 6.
I am automating the restore of a database to a new host following
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89831.
I'm trying to change the location of the controlfiles prior to
restore. the documentation indicates all that is necessary is to alter the
parameter file value for control_files prior to restore controlfile
command:
"Change any location-specific parameters, for example, those ending in
_DEST, to reflect the new directory structure. For example, edit the
following parameters:
- IFILE
- LOG_ARCHIVE_DEST_1
- CONTROL_FILES"
I did that but when I run:
"run
{ ALLOCATE CHANNEL c1 DEVICE TYPE disk;
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/zfs/prod_backups/dbname/cf_%F';
RESTORE CONTROLFILE FROM AUTOBACKUP;
ALTER DATABASE MOUNT;
}"
It restores the controlfiles to the original location.
Further, when i try the following:
"run
{ ALLOCATE CHANNEL c1 DEVICE TYPE disk;
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/zfs/prod_backup/dbname/cf_%F';
RESTORE CONTROLFILE TO '+DATAC1/pd_restore/CONTROLFILE/dbname.ctl'
from autobackup;
ALTER DATABASE MOUNT;
}"
I get:
"released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 10/23/2017 15:08:49
ORA-00205: error in identifying control file, check alert log for more
info
"
and '+DATAC1/pd_restore/CONTROLFILE/dbname.ctl' doesn't exist after
execution as the error message indicates.
what am i doing wrong? what do i need to do to restore the controlfile
to a new location?
Sorry in advance for the recovery 101 question.
chris
