RMAN-04014: startup failed: ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated ORA-09291: sksachk: invalid device specified for archive destination
While performing RMAN refresh to 12.2.0.1.0 from 12.1.0.2.0, below error was encountered:
Recovery Manager: Release 12.2.0.1.0 – Production on Tue Nov 14 11:45:26 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.connected to auxiliary database: DEVDB (not mounted)RMAN> run{DUPLICATE TARGET DATABASE TO 'DEVDB'SPFILEparameter_value_convert ('PRODB','DEVDB')set db_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'set log_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'set audit_file_dest='D:\app\Oracle\admin\DEVDB\adump'set core_dump_dest='D:\app\Oracle\admin\DEVDB\cdump'set control_files='D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O1_MF_F06L807F_.CTL','D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O2_MF_F06L807F_.CTL','D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O3_MF_F06L807F_.CTL'set db_name='DEVDB'BACKUP LOCATION 'D:\app\Oracle\Backup\RMAN'NOFILENAMECHECK; }
Starting Duplicate Db at 14-NOV-17-------
Oracle instance shut down
connected to auxiliary database (not started)RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of Duplicate Db command at 11/14/2017 11:46:16RMAN-05501: aborting duplication of target databaseRMAN-03015: error occurred in stored script Memory ScriptRMAN-04014: startup failed: ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translatedORA-09291: sksachk: invalid device specified for archive destinationOSD-04018: Unable to access the specified directory or device.O/S-Error: (OS 3) The system cannot find the path specified.
Recovery Manager complete.
run
{
DUPLICATE TARGET DATABASE TO 'DEVDB'
SPFILE
parameter_value_convert ('PRODB','DEVDB')
set db_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'
set log_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'
set audit_file_dest='D:\app\Oracle\admin\DEVDB\adump'
# set core_dump_dest='D:\app\Oracle\admin\DEVDB\cdump'
set log_archive_dest_1='location=D:\app\Oracle\fast_recovery_area\DEVDB\DEVDB\ARCHIVELOG'
set control_files='D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O1_MF_F06L807F_.CTL','D:\APP\ORACLE\FAST_RECOVERY_AREA\DEVDB\DEVDB\CONTROLFILE\O1_MF_F06L808F_.CTL','D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O3_MF_F06L807F_.CTL'
set db_name='DEVDB'
BACKUP LOCATION 'D:\app\Oracle\Backup\RMAN'
NOFILENAMECHECK;
}
run
{
DUPLICATE TARGET DATABASE TO 'DEVDB'
SPFILE
parameter_value_convert ('PRODB','DEVDB')
set db_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'
set log_file_name_convert='D:\APP\ORACLE\ORADATA\PRODB\DATAFILE\','D:\APP\ORACLE\ORADATA\DEVDB\DATAFILE\'
set audit_file_dest='D:\app\Oracle\admin\DEVDB\adump'
# set core_dump_dest='D:\app\Oracle\admin\DEVDB\cdump'
set log_archive_dest_1='location=D:\app\Oracle\fast_recovery_area\DEVDB\DEVDB\ARCHIVELOG'
set control_files='D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O1_MF_F06L807F_.CTL','D:\APP\ORACLE\FAST_RECOVERY_AREA\DEVDB\DEVDB\CONTROLFILE\O1_MF_F06L808F_.CTL','D:\APP\ORACLE\ORADATA\DEVDB\CONTROLFILE\O3_MF_F06L807F_.CTL'
set db_name='DEVDB'
BACKUP LOCATION 'D:\app\Oracle\Backup\RMAN'
NOFILENAMECHECK;
}
Solution:
Amend set log_archive_dest_1=’location=D:\app\Oracle\fast_recovery_area\DEVDB\DEVDB\ARCHIVELOG’
No comments:
Post a Comment