Hi Friends,
I was trying to create physical standby database without duplicate command through RMAN (As per Doc 469493.1). But during restoration, redo log files are not creating. I used below command to restore the database.
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK ;
set newname for datafile 1 to '/u02/ORADATA/ORCLS/system01.dbf' ;
set newname for datafile 2 to '/u02/ORADATA/ORCLS/sysaux01.dbf' ;
set newname for datafile 3 to '/u02/ORADATA/ORCLS/undotbs01.dbf';
set newname for datafile 4 to '/u02/ORADATA/ORCLS/users01.dbf' ;
set newname for datafile 5 to '/u02/ORADATA/ORCLS/example01.dbf';
SQL "ALTER DATABASE RENAME FILE ''/u02/ORADATA/ORCL/redo03.log'' TO ''/u02/ORADATA/ORCLS/redo03.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u02/ORADATA/ORCL/redo02.log'' TO ''/u02/ORADATA/ORCLS/redo02.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/u02/ORADATA/ORCL/redo01.log'' TO ''/u02/ORADATA/ORCLS/redo01.log'' ";
restore database;
switch datafile all ;
}
But I got below error.
sql statement: ALTER DATABASE RENAME FILE ''/u02/ORADATA/ORCL/redo03.log'' TO ''/u02/ORADATA/ORCLS/redo03.log''
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 02/05/2017 20:06:17
RMAN-11003: failure during parse/execution of SQL statement: ALTER DATABASE RENAME FILE '/u02/ORADATA/ORCL/redo03.log' TO '/u02/ORADATA/ORCLS/redo03.log'
ORA-01511: error in renaming log/data files
ORA-01516: nonexistent log file, data file, or temporary file "/u02/ORADATA/ORCL/redo03.log"
I tried to run the restore command without any alter database command. It got completed. But redo log files were not created. Also I have checked v$logfile in standby side, it is showing some results, that redo log files are present. I have checked the log file location in primary side. There is no issue to log file name in primary side. So is there anything I am missing?
Please suggest me to resolve the issue.
Thanks in Advance..
Regards,
Smruti