This post applies to 12c and 19c as well, it introduced two popular ways for creating a standby database: RMAN DUPLICATE and from primary database backup
This post demonstrates how to build an Oracle 18c physical standby database managed by data guard. The method should also apply to 12c and 19c as well.
Read more of this content when you subscribe today.
While creating a new physical standby database by using RMAN duplicate command, the following errors occur:
RMAN> run {
allocate channel prim1 type disk;
allocate channel prim2 type disk;
allocate auxiliary channel standby1 type disk;
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
...
..
.
RMAN-03009: failure of backup command on prim2 channel
ORA-17628: Oracle error 19505 returned by remote Oracle server
ORA-19505: failed to identify file ""
Read more of this content when you subscribe today.
While run RMAN “duplicate target database for standby from active database nofilenamecheck” in 11g database, then got below errors:
... .. . set newname for datafile 3 to "/u02/oradata/TESTDBSTY/undotbs01.dbf"; ... .. . channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u02/oradata/TESTDB/undotbs01.dbf RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 15:53:17 ORA-17628: Oracle error 19505 returned by remote Oracle server continuing other job steps, job failed will not be re-run ... .. .
Read more of this content when you subscribe today.
RMAN “duplicate target database for standby from active database” failed with below errors:
Connection from target database server to the auxiliary database fails with error: ORA-12528: TNS:listener: all appropriate instances are blocking new connections.
It is a little bit tricky in RAC environment, this post will provide the solution for both single and RAC environment.
Read more of this content when you subscribe today.
Make DBA Life Easy 