While trying to restore my controlfile backed up for standby, its getting restores as controlfile_type=backup instead of standby and the database_role shows as primary instead of physical_standby.
Backup controlfile on primary
RMAN> backup current controlfile for standby format='/ora/bkup/DBASEA/DBASEA_standby_ctlfl.bak' tag='STANDBY_CTLFILE_BAK';
scp it to standby server:
RMAN> restore controlfile from '/ora/bkup/DBASEB/DBASEA_standby_ctlfl.bak';
Starting restore at 16-MAY-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA_DBASE_32/DBASEB/control01.ctl
output file name=+FRA_DBASE_32/DBASEB/control02.ctl
Finished restore at 16-MAY-16
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> exit
oracle > sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Mon May 16 23:03:01 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management and Real Application Testing options
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PRIMARY
SQL> SELECT controlfile_type FROM V$database;
CONTROL
-------
BACKUP