Database Software

Hi ,

I have come accross many threads related to this topic but could not help myself to reach to correct issue, so raising fresh one.
I am creating Physical standby DB for the first time. It is in the same host. Though I have worked a little on standby but did not get a chance to create new. I used RMAN cold backup for restoring the Primary database backup. The DB version is 11.2.0.3(32bit) and I am creating on Windows 7. The problem is Logs are not applied on standby side though I am unable to see any error in alert log. Previously password file related error was coming but I have resolved that one.

In the Alert of Standby The parameters look like:
processes = 150
memory_target = 500M
memory_max_target = 700M
control_files = "D:\EDRIVE\STANDBY\STANDBY\CONTROL01.CTL"
control_files = "D:\EDRIVE\STANDBY\STANDBY\CONTROL02.CTL"
db_file_name_convert = "D:\EDrive\PRIMARY\primary"
db_file_name_convert = "D:\EDrive\STANDBY\standby"
log_file_name_convert = "D:\EDrive\PRIMARY\primary"
log_file_name_convert = "D:\EDrive\STANDBY\standby"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=D:\EDrive\STANDBY\Arc"
log_archive_dest_2 = "SERVICE=PRIMARY VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIMARY"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "DEFER"
fal_client = "STANDBY"
fal_server = "PRIMARY"
log_archive_config = "DG_CONFIG=(PRIMARY, STANDBY)"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
db_recovery_file_dest_size= 4152M
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
audit_trail = "DB"
db_name = "primary"
db_unique_name = "STANDBY"
open_cursors = 300
-----
In the Primary side the parameters looks like while starting:

processes = 150
memory_target = 712M
control_files = "D:\EDRIVE\PRIMARY\PRIMARY\CONTROL01.CTL"
control_files = "D:\EDRIVE\PRIMARY\PRIMARY\CONTROL02.CTL"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=D:\EDrive\PRIMARY\Arc"
log_archive_dest_2 = "SERVICE=PRIMARY NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STANDBY"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "ENABLE"
fal_client = "PRIMARY"
fal_server = "STANDBY"
log_archive_config = "DG_CONFIG=(PRIMARY, STANDBY)"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
db_recovery_file_dest = "D:\app\fast_recovery_area"
db_recovery_file_dest_size= 4152M
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=primaryXDB)"
audit_file_dest = "D:\APP\ADMIN\PRIMARY\ADUMP"
audit_trail = "DB"
db_name = "primary"
open_cursors = 300
diagnostic_dest = "D:\APP"

For RMAN Backup and Duplicate below are the commands I used.
While backup in mount mode
Rman target=/
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup database format 'D:\EDrive\RMANBACKUP\primary\%U';
backup archivelog all format 'D:\EDrive\RMANBACKUP\primary\%U';
backup current controlfile for standby format 'D:\EDrive\RMANBACKUP\primary\standby.ctl';
}

While Restoration

RMAN target sys/sys@PRIMARY auxiliary /

Duplicate target database for standby dorecover;

Also I added standby Redolog 1 extra on standby side later as It was not showing any after querying select * from v$standby_log;.
Now it is showing one.
On the standby side I heard RMAN creates it.
Please see below:

On Standby Side
--------

SQL> alter database add standby logfile group 1 'D:\EDrive\STANDBY\standby\stb_redo01.log' size 100M;
alter database add standby logfile group 1 'D:\EDrive\STANDBY\standby\stb_redo01.log' size 100M
*
ERROR at line 1:
ORA-01184: logfile group 1 already exists


SQL> alter database add standby logfile group 2 'D:\EDrive\STANDBY\standby\stb_redo02.log' size 100M;
alter database add standby logfile group 2 'D:\EDrive\STANDBY\standby\stb_redo02.log' size 100M
*
ERROR at line 1:
ORA-01184: logfile group 2 already exists


SQL>
SQL>
SQL> alter database add standby logfile group 3 'D:\EDrive\STANDBY\standby\stb_redo03.log' size 100M;

Database altered.

Please guide me to understand the problem that why logs are not applied?

Thanks a ton for your help in advance.

-Regards,
Saha