Trying to configure the dataguard in wndows for 11g, but at a step got the following error,
Database Buffers 50331648 bytes
Redo Buffers 5267456 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> shutdown abort
ORACLE instance shut down.
SQL> create spfile from pfile;
File created.
SQL> startup mount
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2174320 bytes
Variable Size 159384208 bytes
Database Buffers 50331648 bytes
Redo Buffers 5267456 bytes
Database mounted.
SQL> set logsource 'G:\app\sony\flash_recovery_area\ ' ;
SQL> recover standby database until cancel using bckup controlfile;
ORA-01906: BACKUP keyword expected
SQL> recover standby database until cancel using backup controlfile;
ORA-00279: change 9760060 generated at 03/03/2012 19:36:13 needed for thread 1
ORA-00289: suggestion : G:\APP\SONY\FLASH_RECOVERY_AREA\
\ARC0000000424_0758477901.0001
ORA-00280: change 9760060 for thread 1 is in sequence #424
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'G:\APP\SONY\ORADATA\RND2\SYSTEM01.DBF'
SQL> recover managed standby database disconnect session;
ORA-16034: Recovery could not be started.
SQL>
but later when i open the db, am not able to open the db, when checked the alert log,
Current log# 1 seq# 430 mem# 0: G:\APP\SONY\ORADATA\RND\REDO01.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Mar 07 10:13:40 2012
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Archived Log entry 6 added for thread 1 sequence 429 ID 0x52332e48 dest 1:
Wed Mar 07 10:13:50 2012
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Mar 07 10:14:02 2012
Starting background process QMNC
Wed Mar 07 10:14:02 2012
QMNC started with pid=26, OS id=1564
Wed Mar 07 10:14:14 2012
Completed: alter database open
Wed Mar 07 10:14:25 2012
Starting background process CJQ0
Wed Mar 07 10:14:25 2012
CJQ0 started with pid=31, OS id=3580
Wed Mar 07 10:14:26 2012
db_recovery_file_dest_size of 3912 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Mar 07 10:19:04 2012
Starting background process SMCO
Wed Mar 07 10:19:04 2012
SMCO started with pid=20, OS id=840
Wed Mar 07 11:43:27 2012
ALTER SYSTEM SET log_archive_dest_2='service=rnd2 valid_for=(online_log_files,primary_role) db_unique_name=rnd2' SCOPE=SPFILE;
Wed Mar 07 12:42:42 2012
Thread 1 advanced to log sequence 431 (LGWR switch)
Current log# 2 seq# 431 mem# 0: G:\APP\SONY\ORADATA\RND\REDO02.LOG
Wed Mar 07 12:42:42 2012
Archived Log entry 7 added for thread 1 sequence 430 ID 0x52332e48 dest 1:
Wed Mar 07 12:47:24 2012
***********************************************************************
Fatal NI connect error 12638, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 07-MAR-2012 12:47:24
Tracing not turned on.
Tns error struct:
ns main err code: 12638
TNS-12638: Credential retrieval failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Thu Mar 08 09:43:08 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Thu Mar 08 09:43:19 2012
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3696.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Thu Mar 08 10:50:36 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3848.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Fri Mar 09 07:48:49 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_4180.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Fri Mar 09 23:30:56 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3664.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sat Mar 10 05:24:17 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3684.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 09:39:47 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3708.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:24:09 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_7108.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:25:58 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_8140.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:26:55 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_1932.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:31:31 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_8252.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:40:08 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_4692.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:45:14 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_7092.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:46:50 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_9036.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 12:46:56 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_3012.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 13:08:08 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_8584.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 21:31:40 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_2944.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
Sun Mar 11 21:58:26 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors in file g:\app\sony\diag\rdbms\rnd\rnd\trace\rnd_ora_6668.trc:
ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes
please advice about how to proceed..,