I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby controlfile and transferred it to the standby.
scp test_sdy firstname.lastname@example.org:/u03/app/oracle/oradata/TEST1/control01.ctl cp /u03/app/oracle/oradata/TEST1/control01.ctl \ /u03/app/oracle/flash_recover_area/TEST1/control02.ctl
When I start up the standby database using pfile, I get this error:
ORA-10458: standby database requires recovery ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u03/app/oracle/oradata/TEST1_SDY/system01.dbf'
Did I do something wrong with the standby control file? How can I fix this?