HI,
I have my standby database has been crashed as I have opened the standby database in R/W mode by enabling the flashback and creating a guaranteed restore point.
My standby database has been crashed while I was reverting it to a restore point that I have created. I couldn't find any specific reason why and where it went wrong in alert log file.
Please find the below for the DB alert log content and help me in finding the root cause for the same.
Mon Apr 07 13:58:34 2014
Archived Log entry 7146 added for thread 1 sequence 102175 rlc 775827861 ID 0xe157d7d5 dest 2:
RFS[32]: No standby redo logfiles created
RFS[32]: Opened log for thread 1 sequence 102176 dbid -514335787 branch 775827861
Mon Apr 07 13:58:37 2014
Media Recovery Log +DATA4/xxxxdr/archivelog/2014_04_07/thread_1_seq_102175.359.844263313
Mon Apr 07 13:59:03 2014
Media Recovery Waiting for thread 1 sequence 102176 (in transit)
Mon Apr 07 14:28:00 2014
Archived Log entry 7147 added for thread 1 sequence 102176 rlc 775827861 ID 0xe157d7d5 dest 2:
RFS[32]: No standby redo logfiles created
RFS[32]: Opened log for thread 1 sequence 102177 dbid -514335787 branch 775827861
Mon Apr 07 14:28:03 2014
Media Recovery Log +DATA4/xxxxdr/archivelog/2014_04_07/thread_1_seq_102176.475.844264715
Mon Apr 07 14:28:21 2014
Media Recovery Waiting for thread 1 sequence 102177 (in transit)
Mon Apr 07 14:40:00 2014
ALTER SYSTEM SET db_recovery_file_dest_size='250G' SCOPE=MEMORY;
ALTER SYSTEM SET db_recovery_file_dest='+DATA4' SCOPE=MEMORY;
Mon Apr 07 14:40:00 2014
db_recovery_file_dest_size of 256000 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.
Mon Apr 07 15:00:41 2014
Archived Log entry 7148 added for thread 1 sequence 102177 rlc 775827861 ID 0xe157d7d5 dest 2:
RFS[32]: No standby redo logfiles created
RFS[32]: Opened log for thread 1 sequence 102178 dbid -514335787 branch 775827861
Mon Apr 07 15:00:42 2014
Media Recovery Log +DATA4/xxxxdr/archivelog/2014_04_07/thread_1_seq_102177.306.844266481
Mon Apr 07 15:01:04 2014
Media Recovery Waiting for thread 1 sequence 102178 (in transit)
Mon Apr 07 15:36:42 2014
Archived Log entry 7149 added for thread 1 sequence 102178 rlc 775827861 ID 0xe157d7d5 dest 2:
RFS[32]: No standby redo logfiles created
RFS[32]: Opened log for thread 1 sequence 102179 dbid -514335787 branch 775827861
Mon Apr 07 15:36:45 2014
Media Recovery Log +DATA4/xxxxdr/archivelog/2014_04_07/thread_1_seq_102178.487.844268443
Mon Apr 07 15:37:04 2014
Media Recovery Waiting for thread 1 sequence 102179 (in transit)
Mon Apr 07 15:47:44 2014
alter database recover managed standby database cancel
Mon Apr 07 15:47:44 2014
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_pr00_7012626.trc:
ORA-16037: user requested cancel of managed recovery operation
Recovery interrupted!
Mon Apr 07 15:47:49 2014
MRP0: Background Media Recovery process shutdown (xxxx)
Managed Standby Recovery Canceled (xxxx)
Completed: alter database recover managed standby database cancel
Mon Apr 07 15:48:32 2014
alter database flashback on
Starting background process RVWR
Mon Apr 07 15:48:37 2014
RVWR started with pid=41, OS id=20185258
Mon Apr 07 15:48:44 2014
Allocated 31874880 bytes in shared pool for flashback generation buffer
Mon Apr 07 15:48:55 2014
Flashback Database Enabled at SCN 11335207903374
Completed: alter database flashback on
Mon Apr 07 15:49:29 2014
Created guaranteed restore point BEFORE_OPEN_STANDBY
Mon Apr 07 15:49:52 2014
alter database activate standby database
ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (xxxx)
krsv_proc_kill: Killing 4 processes (all RFS)
Begin: Standby Redo Logfile archival
End: Standby Redo Logfile archival
RESETLOGS after incomplete recovery UNTIL CHANGE 11335207903374
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Resetting resetlogs activation ID 3780630485 (0xe157d7d5)
Online log +DATA3/xxxxdr/onlinelog/group_4.1988.839355967: Thread 1 Group 4 was previously cleared
Online log +DATA3/xxxxdr/onlinelog/group_5.1989.839355971: Thread 1 Group 5 was previously cleared
Online log +DATA3/xxxxdr/onlinelog/group_6.1990.839355973: Thread 1 Group 6 was previously cleared
Online log +DATA3/xxxxdr/onlinelog/group_7.1991.839355977: Thread 1 Group 7 was previously cleared
Online log +DATA3/xxxxdr/onlinelog/group_8.1992.839355979: Thread 1 Group 8 was previously cleared
Online log +DATA3/xxxxdr/onlinelog/group_9.1993.839355981: Thread 1 Group 9 was previously cleared
Standby became primary SCN: 11335207903372
Mon Apr 07 15:49:59 2014
Setting recovery target incarnation to 2
Mon Apr 07 15:50:02 2014
ACTIVATE STANDBY: Complete - Database mounted as primary
Completed: alter database activate standby database
Mon Apr 07 15:50:15 2014
alter database open
Using SCN growth rate of 16384 per second
Mon Apr 07 15:50:19 2014
Assigning activation ID 3844217615 (0xe5221b0f)
Thread 1 opened at log sequence 1
Current log# 4 seq# 1 mem# 0: +DATA3/xxxxdr/onlinelog/group_4.1988.839355967
Successful open of redo thread 1
Mon Apr 07 15:50:19 2014
SMON: enabling cache recovery
[5439980] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:646101669 end:646101817 diff:148 (1 seconds)
Dictionary check beginning
Mon Apr 07 15:50:27 2014
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3001 - see DBWR trace file
ORA-01110: data file 3001: '+DATA3/xxxx/tempfile/temp.265.775827871'
ORA-17503: ksfdopn:2 Failed to open file +DATA3/xxxx/tempfile/temp.265.775827871
ORA-15012: ASM file '+DATA3/xxxx/tempfile/temp.265.775827871' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3001 failed verification tests
ORA-01157: cannot identify/lock data file 3001 - see DBWR trace file
ORA-01110: data file 3001: '+DATA3/xxxx/tempfile/temp.265.775827871'
File 3001 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3002 - see DBWR trace file
ORA-01110: data file 3002: '+REDO_TEMP/xxxx/tempfile/temp.271.776866675'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.271.776866675
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.271.776866675' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3002 failed verification tests
ORA-01157: cannot identify/lock data file 3002 - see DBWR trace file
ORA-01110: data file 3002: '+REDO_TEMP/xxxx/tempfile/temp.271.776866675'
File 3002 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3003 - see DBWR trace file
ORA-01110: data file 3003: '+REDO_TEMP/xxxx/tempfile/temp.272.776866683'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.272.776866683
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.272.776866683' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3003 failed verification tests
ORA-01157: cannot identify/lock data file 3003 - see DBWR trace file
ORA-01110: data file 3003: '+REDO_TEMP/xxxx/tempfile/temp.272.776866683'
File 3003 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3004 - see DBWR trace file
ORA-01110: data file 3004: '+REDO_TEMP/xxxx/tempfile/temp.273.776866685'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.273.776866685
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.273.776866685' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3004 failed verification tests
ORA-01157: cannot identify/lock data file 3004 - see DBWR trace file
ORA-01110: data file 3004: '+REDO_TEMP/xxxx/tempfile/temp.273.776866685'
File 3004 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3005 - see DBWR trace file
ORA-01110: data file 3005: '+REDO_TEMP/xxxx/tempfile/temp.274.776866687'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.274.776866687
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.274.776866687' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3005 failed verification tests
ORA-01157: cannot identify/lock data file 3005 - see DBWR trace file
ORA-01110: data file 3005: '+REDO_TEMP/xxxx/tempfile/temp.274.776866687'
File 3005 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3006 - see DBWR trace file
ORA-01110: data file 3006: '+REDO_TEMP/xxxx/tempfile/temp.275.776866687'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.275.776866687
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.275.776866687' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3006 failed verification tests
ORA-01157: cannot identify/lock data file 3006 - see DBWR trace file
ORA-01110: data file 3006: '+REDO_TEMP/xxxx/tempfile/temp.275.776866687'
File 3006 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3007 - see DBWR trace file
ORA-01110: data file 3007: '+REDO_TEMP/xxxx/tempfile/temp.276.776866693'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.276.776866693
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.276.776866693' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3007 failed verification tests
ORA-01157: cannot identify/lock data file 3007 - see DBWR trace file
ORA-01110: data file 3007: '+REDO_TEMP/xxxx/tempfile/temp.276.776866693'
File 3007 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3008 - see DBWR trace file
ORA-01110: data file 3008: '+REDO_TEMP/xxxx/tempfile/temp.277.776866695'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.277.776866695
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.277.776866695' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3008 failed verification tests
ORA-01157: cannot identify/lock data file 3008 - see DBWR trace file
ORA-01110: data file 3008: '+REDO_TEMP/xxxx/tempfile/temp.277.776866695'
File 3008 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3009 - see DBWR trace file
ORA-01110: data file 3009: '+REDO_TEMP/xxxx/tempfile/temp.278.776866695'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.278.776866695
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.278.776866695' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3009 failed verification tests
ORA-01157: cannot identify/lock data file 3009 - see DBWR trace file
ORA-01110: data file 3009: '+REDO_TEMP/xxxx/tempfile/temp.278.776866695'
File 3009 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3010 - see DBWR trace file
ORA-01110: data file 3010: '+REDO_TEMP/xxxx/tempfile/temp.279.776866697'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.279.776866697
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.279.776866697' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3010 failed verification tests
ORA-01157: cannot identify/lock data file 3010 - see DBWR trace file
ORA-01110: data file 3010: '+REDO_TEMP/xxxx/tempfile/temp.279.776866697'
File 3010 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3011 - see DBWR trace file
ORA-01110: data file 3011: '+REDO_TEMP/xxxx/tempfile/temp.280.776866699'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.280.776866699
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.280.776866699' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3011 failed verification tests
ORA-01157: cannot identify/lock data file 3011 - see DBWR trace file
ORA-01110: data file 3011: '+REDO_TEMP/xxxx/tempfile/temp.280.776866699'
File 3011 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3012 - see DBWR trace file
ORA-01110: data file 3012: '+REDO_TEMP/xxxx/tempfile/temp.281.776866701'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.281.776866701
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.281.776866701' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3012 failed verification tests
ORA-01157: cannot identify/lock data file 3012 - see DBWR trace file
ORA-01110: data file 3012: '+REDO_TEMP/xxxx/tempfile/temp.281.776866701'
File 3012 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3013 - see DBWR trace file
ORA-01110: data file 3013: '+REDO_TEMP/xxxx/tempfile/temp.282.776866701'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.282.776866701
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.282.776866701' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3013 failed verification tests
ORA-01157: cannot identify/lock data file 3013 - see DBWR trace file
ORA-01110: data file 3013: '+REDO_TEMP/xxxx/tempfile/temp.282.776866701'
File 3013 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3014 - see DBWR trace file
ORA-01110: data file 3014: '+REDO_TEMP/xxxx/tempfile/temp.283.776866705'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.283.776866705
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.283.776866705' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3014 failed verification tests
ORA-01157: cannot identify/lock data file 3014 - see DBWR trace file
ORA-01110: data file 3014: '+REDO_TEMP/xxxx/tempfile/temp.283.776866705'
File 3014 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3015 - see DBWR trace file
ORA-01110: data file 3015: '+REDO_TEMP/xxxx/tempfile/temp.284.776866709'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.284.776866709
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.284.776866709' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3015 failed verification tests
ORA-01157: cannot identify/lock data file 3015 - see DBWR trace file
ORA-01110: data file 3015: '+REDO_TEMP/xxxx/tempfile/temp.284.776866709'
File 3015 not verified due to error ORA-01157
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01157: cannot identify/lock data file 3016 - see DBWR trace file
ORA-01110: data file 3016: '+REDO_TEMP/xxxx/tempfile/temp.285.776866711'
ORA-17503: ksfdopn:2 Failed to open file +REDO_TEMP/xxxx/tempfile/temp.285.776866711
ORA-15012: ASM file '+REDO_TEMP/xxxx/tempfile/temp.285.776866711' does not exist
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_dbw0_12845156.trc:
ORA-01186: file 3016 failed verification tests
ORA-01157: cannot identify/lock data file 3016 - see DBWR trace file
ORA-01110: data file 3016: '+REDO_TEMP/xxxx/tempfile/temp.285.776866711'
File 3016 not verified due to error ORA-01157
Mon Apr 07 15:50:27 2014
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.285.776866711 as +DATA3/xxxxdr/tempfile/temp.2152.844271427
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.284.776866709 as +DATA3/xxxxdr/tempfile/temp.2153.844271429
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.283.776866705 as +DATA3/xxxxdr/tempfile/temp.2154.844271431
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.282.776866701 as +DATA3/xxxxdr/tempfile/temp.2155.844271431
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.281.776866701 as +DATA3/xxxxdr/tempfile/temp.2156.844271433
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.280.776866699 as +DATA3/xxxxdr/tempfile/temp.2157.844271433
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.279.776866697 as +DATA3/xxxxdr/tempfile/temp.2158.844271433
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.278.776866695 as +DATA3/xxxxdr/tempfile/temp.2159.844271435
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.277.776866695 as +DATA3/xxxxdr/tempfile/temp.2160.844271435
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.276.776866693 as +DATA3/xxxxdr/tempfile/temp.2161.844271435
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.275.776866687 as +DATA3/xxxxdr/tempfile/temp.2162.844271437
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.274.776866687 as +DATA3/xxxxdr/tempfile/temp.2163.844271437
Mon Apr 07 15:50:38 2014
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.273.776866685 as +DATA3/xxxxdr/tempfile/temp.2164.844271437
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.272.776866683 as +DATA3/xxxxdr/tempfile/temp.2165.844271439
Re-creating tempfile +REDO_TEMP/xxxx/tempfile/temp.271.776866675 as +DATA3/xxxxdr/tempfile/temp.2166.844271439
Re-creating tempfile +DATA3/xxxx/tempfile/temp.265.775827871 as +DATA3/xxxxdr/tempfile/temp.2167.844271439
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
If files cannot be cataloged, then manually delete them
using OS command.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Mon Apr 07 15:50:42 2014
QMNC started with pid=38, OS id=9110014
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Mon Apr 07 15:50:45 2014
Starting background process EMNC
Mon Apr 07 15:50:45 2014
EMNC started with pid=39, OS id=15073514
Completed: alter database open
Mon Apr 07 15:50:58 2014
Starting background process CJQ0
Mon Apr 07 15:50:58 2014
CJQ0 started with pid=50, OS id=5439986
Mon Apr 07 15:51:00 2014
Active Session History (ASH) performed an emergency flush. This may mean that ASH is undersized. If emergency flushes are a recurring issue, you may consider increasing ASH size by setting the value of _ASH_SIZE to a sufficiently large value. Currently, ASH size is 67108864 bytes. Both ASH size and the total number of emergency flushes since instance startup can be monitored by running the following query:
select total_size,awr_flush_emergency_count from v$ash_info;
Mon Apr 07 15:51:03 2014
Starting background process SMCO
Mon Apr 07 15:51:03 2014
SMCO started with pid=51, OS id=17629200
Mon Apr 07 15:51:47 2014
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=MEMORY;
Mon Apr 07 15:53:53 2014
Shutting down instance (abort)
License high water mark = 44
USER (ospid: 4325652): terminating the instance
Instance terminated by USER, pid = 4325652
Mon Apr 07 15:53:55 2014
Instance shutdown complete
Mon Apr 07 15:53:55 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =499
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /Oracle_Home/oracle/ora_base/Ora11GHome
System name: AIX
Node name: SVHY0573
Release: 1
Version: 6
Machine: 00C59BE74C00
Using parameter settings in server-side spfile /Oracle_Home/oracle/ora_base/Ora11GHome/dbs/spfilexxxx.ora
System parameters with non-default values:
processes = 3000
resource_limit = TRUE
sga_max_size = 13G
shared_pool_size = 2G
large_pool_size = 512M
java_pool_size = 128M
filesystemio_options = "setall"
sga_target = 12G
memory_target = 18G
memory_max_target = 18G
control_files = "/Oracle_Home/oracle/ora_base/Ora11GHome/dbs/standby_control_12feb14.ctl"
db_block_size = 16384
_db_fast_obj_truncate = FALSE
db_cache_size = 7G
db_writer_processes = 4
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+DATA4"
log_archive_format = "arch_xxxx_%t_%s_%r.arc"
log_buffer = 52428800
log_checkpoint_timeout = 0
db_files = 3000
db_file_multiblock_read_count= 32
db_create_file_dest = "+DATA3"
fast_start_mttr_target = 900
undo_tablespace = "UNDOTBS1"
undo_retention = 3600
recyclebin = "off"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
audit_sys_operations = TRUE
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=xxxxXDB)"
local_listener = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xx.xx)(PORT=xxxx))))"
job_queue_processes = 10
cursor_sharing = "FORCE"
parallel_max_servers = 100
audit_file_dest = "/Oracle_Logs/oracle/diag/diag/rdbms/xxxx/xxxx/adump"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "xxxx"
db_unique_name = "xxxxDR"
open_cursors = 3000
query_rewrite_enabled = "FALSE"
pga_aggregate_target = 5G
optimizer_dynamic_sampling= 0
optimizer_secure_view_merging= FALSE
deferred_segment_creation= FALSE
sec_max_failed_login_attempts= 4
sec_return_server_release_banner= FALSE
diagnostic_dest = "/Oracle_Logs/oracle/diag"
Mon Apr 07 15:53:56 2014
PMON started with pid=2, OS id=9765180
Mon Apr 07 15:53:57 2014
PSP0 started with pid=3, OS id=20775126
Mon Apr 07 15:53:57 2014
VKTM started with pid=4, OS id=19529760 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Apr 07 15:53:57 2014
GEN0 started with pid=5, OS id=19071046
Mon Apr 07 15:53:57 2014
DIAG started with pid=6, OS id=9372056
Mon Apr 07 15:53:57 2014
DBRM started with pid=7, OS id=19595354
Mon Apr 07 15:53:57 2014
DIA0 started with pid=8, OS id=19923012
Mon Apr 07 15:53:57 2014
MMAN started with pid=9, OS id=4325664
Mon Apr 07 15:53:57 2014
DBW0 started with pid=10, OS id=5308874
Mon Apr 07 15:53:57 2014
DBW1 started with pid=11, OS id=6881604
Mon Apr 07 15:53:57 2014
DBW2 started with pid=12, OS id=18874518
Mon Apr 07 15:53:58 2014
DBW3 started with pid=13, OS id=18481332
Mon Apr 07 15:53:58 2014
LGWR started with pid=14, OS id=17826014
Mon Apr 07 15:53:58 2014
CKPT started with pid=15, OS id=17629202
Mon Apr 07 15:53:58 2014
SMON started with pid=16, OS id=17498148
Mon Apr 07 15:53:58 2014
RECO started with pid=17, OS id=6226268
Mon Apr 07 15:53:58 2014
RBAL started with pid=18, OS id=17432796
Mon Apr 07 15:53:58 2014
ASMB started with pid=19, OS id=16777322
Mon Apr 07 15:53:58 2014
MMON started with pid=20, OS id=16646318
Mon Apr 07 15:53:58 2014
MMNL started with pid=21, OS id=6160684
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
NOTE: initiating MARK startup
starting up 1 shared server(s) ...
Starting background process MARK
Mon Apr 07 15:53:58 2014
MARK started with pid=23, OS id=5636590
NOTE: MARK has subscribed
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Mon Apr 07 15:53:59 2014
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Mon Apr 07 15:54:03 2014
ARC0 started with pid=27, OS id=5439996
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Mon Apr 07 15:54:04 2014
ARC1 started with pid=28, OS id=13828210
Mon Apr 07 15:54:05 2014
ARC2 started with pid=29, OS id=5374260
Mon Apr 07 15:54:05 2014
ARC3 started with pid=30, OS id=13631692
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC0: Thread not mounted
ARC1: Becoming the heartbeat ARCH
ARC1: Thread not mounted
ARC3: Thread not mounted
ARC2: Thread not mounted
Successful mount of redo thread 1, with mount id 3849059927
Physical Standby Database mounted.
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
NOTE: Loaded library: System
SUCCESS: diskgroup DATA3 was mounted
Mon Apr 07 15:54:07 2014
ERROR: failed to establish dependency between database xxxxDR and diskgroup resource ora.DATA3.dg
Mon Apr 07 15:54:18 2014
flashback database to restore point before_open_standby
ORA-38780 signalled during: flashback database to restore point before_open_standby...
Mon Apr 07 15:55:05 2014
ARC1: Becoming the active heartbeat ARCH
Mon Apr 07 16:00:02 2014
db_recovery_file_dest_size of 256000 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.
Mon Apr 07 16:00:03 2014
SUCCESS: diskgroup DATA4 was mounted
Mon Apr 07 16:00:09 2014
ERROR: failed to establish dependency between database xxxxDR and diskgroup resource ora.DATA4.dg
Mon Apr 07 16:00:09 2014
Deleted Oracle managed file +data4/xxxxDR/FLASHBACK/log_1.348.844271317
Deleted Oracle managed file +data4/xxxxDR/FLASHBACK/log_2.500.844271335
Mon Apr 07 16:00:23 2014
Errors in file /Oracle_Logs/oracle/diag/diag/rdbms/xxxxdr/xxxx/trace/xxxx_ora_11076088.trc:
ORA-38870: cannot backup a control file that may have incorrect data file structure.
Mon Apr 07 17:11:54 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Mon Apr 07 17:11:56 2014
ARCH shutting down
ARC3: Archival stopped
Mon Apr 07 17:11:56 2014
ARCH shutting down
ARC2: Archival stopped
Mon Apr 07 17:11:56 2014
ARCH shutting down
ARC1: Relinquishing active heartbeat ARCH role
ARC1: Archival stopped
Mon Apr 07 17:11:56 2014
ARCH shutting down
ARC0: Archival stopped
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Apr 07 17:11:57 2014
Stopping background process VKTM
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Apr 07 17:11:58 2014
NOTE: force a map free for map id 7
NOTE: force a map free for map id 6
NOTE: force a map free for map id 5
NOTE: force a map free for map id 4
NOTE: force a map free for map id 3
NOTE: force a map free for map id 2
Mon Apr 07 17:11:58 2014
NOTE: Shutting down MARK background process
Mon Apr 07 17:12:02 2014
Instance shutdown complete
Mon Apr 07 17:12:38 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =499
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /Oracle_Home/oracle/ora_base/Ora11GHome
System name: AIX
Node name: SVHY0573
Release: 1
Version: 6
Machine: 00C59BE74C00
Using parameter settings in server-side spfile /Oracle_Home/oracle/ora_base/Ora11GHome/dbs/spfilexxxx.ora
System parameters with non-default values:
processes = 3000
resource_limit = TRUE
sga_max_size = 13G
shared_pool_size = 2G
large_pool_size = 512M
java_pool_size = 128M
filesystemio_options = "setall"
sga_target = 12G
memory_target = 18G
memory_max_target = 18G
control_files = "/Oracle_Home/oracle/ora_base/Ora11GHome/dbs/standby_control_12feb14.ctl"
db_block_size = 16384
_db_fast_obj_truncate = FALSE
db_cache_size = 7G
db_writer_processes = 4
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+DATA4"
log_archive_format = "arch_xxxx_%t_%s_%r.arc"
log_buffer = 52428800
log_checkpoint_timeout = 0
db_files = 3000
db_file_multiblock_read_count= 32
db_create_file_dest = "+DATA3"
db_recovery_file_dest = "+DATA4"
db_recovery_file_dest_size= 250G
fast_start_mttr_target = 900
undo_tablespace = "UNDOTBS1"
undo_retention = 3600
recyclebin = "off"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
audit_sys_operations = TRUE
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=xxxxXDB)"
local_listener = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xx.xx)(PORT=xxxx))))"
job_queue_processes = 10
cursor_sharing = "FORCE"
parallel_max_servers = 100
audit_file_dest = "/Oracle_Logs/oracle/diag/diag/rdbms/xxxx/xxxx/adump"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "xxxx"
db_unique_name = "xxxxDR"
open_cursors = 3000
query_rewrite_enabled = "FALSE"
pga_aggregate_target = 5G
optimizer_dynamic_sampling= 0
optimizer_secure_view_merging= FALSE
deferred_segment_creation= FALSE
sec_max_failed_login_attempts= 4
sec_return_server_release_banner= FALSE
diagnostic_dest = "/Oracle_Logs/oracle/diag"
Mon Apr 07 17:12:39 2014
PMON started with pid=2, OS id=5636352
Mon Apr 07 17:12:39 2014
PSP0 started with pid=3, OS id=8716734
Mon Apr 07 17:12:39 2014
VKTM started with pid=4, OS id=15204540 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Apr 07 17:12:39 2014
GEN0 started with pid=5, OS id=4915530
Mon Apr 07 17:12:39 2014
DIAG started with pid=6, OS id=5439746
Mon Apr 07 17:12:39 2014
DBRM started with pid=7, OS id=9765182
Mon Apr 07 17:12:39 2014
DIA0 started with pid=8, OS id=17104986
Mon Apr 07 17:12:39 2014
MMAN started with pid=9, OS id=6816008
Mon Apr 07 17:12:39 2014
DBW0 started with pid=10, OS id=19923042
Mon Apr 07 17:12:39 2014
DBW1 started with pid=11, OS id=6881608
Mon Apr 07 17:12:40 2014
DBW2 started with pid=12, OS id=5308876
Mon Apr 07 17:12:40 2014
DBW3 started with pid=13, OS id=19071048
Mon Apr 07 17:12:40 2014
LGWR started with pid=14, OS id=5374262
Mon Apr 07 17:12:40 2014
CKPT started with pid=15, OS id=15597696
Mon Apr 07 17:12:40 2014
SMON started with pid=16, OS id=19595362
Mon Apr 07 17:12:40 2014
RECO started with pid=17, OS id=18874520
Mon Apr 07 17:12:40 2014
RBAL started with pid=18, OS id=18481334
Mon Apr 07 17:12:40 2014
ASMB started with pid=19, OS id=17826016
Mon Apr 07 17:12:40 2014
MMON started with pid=20, OS id=17498150
NOTE: initiating MARK startup
Mon Apr 07 17:12:40 2014
MMNL started with pid=21, OS id=17432798
Starting background process MARK
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Apr 07 17:12:40 2014
MARK started with pid=22, OS id=19529766
NOTE: MARK has subscribed
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Mon Apr 07 17:12:41 2014
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Mon Apr 07 17:12:45 2014
ARC0 started with pid=27, OS id=14155846
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Mon Apr 07 17:12:46 2014
ARC1 started with pid=28, OS id=4325692
Mon Apr 07 17:12:47 2014
ARC2 started with pid=29, OS id=13631706
ARC1: Archival started
ARC2: Archival started
Mon Apr 07 17:12:47 2014
ARC3 started with pid=30, OS id=16580852
ARC2: Becoming the 'no FAL' ARCH
ARC2: Becoming the 'no SRL' ARCH
ARC2: Thread not mounted
Successful mount of redo thread 1, with mount id 3849097929
Physical Standby Database mounted.
Lost write protection disabled
ARC1: Becoming the heartbeat ARCH
ARC1: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
NOTE: Loaded library: System
SUCCESS: diskgroup DATA3 was mounted
Mon Apr 07 17:12:49 2014
ERROR: failed to establish dependency between database xxxxDR and diskgroup resource ora.DATA3.dg
Mon Apr 07 17:16:01 2014
Shutting down instance (abort)
License high water mark = 2
USER (ospid: 14811294): terminating the instance
Instance terminated by USER, pid = 14811294
Mon Apr 07 17:16:02 2014
Instance shutdown complete
Mon Apr 07 17:16:02 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =499
LICENSE_MAX_USERS = 0
SYS auditing is enabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /Oracle_Home/oracle/ora_base/Ora11GHome
System name: AIX
Node name: SVHY0573
Release: 1
Version: 6
Machine: 00C59BE74C00
Using parameter settings in server-side spfile /Oracle_Home/oracle/ora_base/Ora11GHome/dbs/spfilexxxx.ora
System parameters with non-default values:
processes = 3000
resource_limit = TRUE
sga_max_size = 13G
shared_pool_size = 2G
large_pool_size = 512M
java_pool_size = 128M
filesystemio_options = "setall"
sga_target = 12G
memory_target = 18G
memory_max_target = 18G
control_files = "/Oracle_Home/oracle/ora_base/Ora11GHome/dbs/standby_control_12feb14.ctl"
db_block_size = 16384
_db_fast_obj_truncate = FALSE
db_cache_size = 7G
db_writer_processes = 4
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=+DATA4"
log_archive_format = "arch_xxxx_%t_%s_%r.arc"
log_buffer = 52428800
log_checkpoint_timeout = 0
db_files = 3000
db_file_multiblock_read_count= 32
db_create_file_dest = "+DATA3"
db_recovery_file_dest = "+DATA4"
db_recovery_file_dest_size= 250G
fast_start_mttr_target = 900
undo_tablespace = "UNDOTBS1"
undo_retention = 3600
recyclebin = "off"
sec_case_sensitive_logon = FALSE
remote_login_passwordfile= "EXCLUSIVE"
audit_sys_operations = TRUE
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=xxxxXDB)"
local_listener = "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xx.xx.xx)(PORT=xxxx))))"
job_queue_processes = 10
cursor_sharing = "FORCE"
parallel_max_servers = 100
audit_file_dest = "/Oracle_Logs/oracle/diag/diag/rdbms/xxxx/xxxx/adump"
commit_logging = "BATCH"
audit_trail = "DB"
db_name = "xxxx"
db_unique_name = "xxxxDR"
open_cursors = 3000
query_rewrite_enabled = "FALSE"
pga_aggregate_target = 5G
optimizer_dynamic_sampling= 0
optimizer_secure_view_merging= FALSE
deferred_segment_creation= FALSE
sec_max_failed_login_attempts= 4
sec_return_server_release_banner= FALSE
diagnostic_dest = "/Oracle_Logs/oracle/diag"
Mon Apr 07 17:16:02 2014
PMON started with pid=2, OS id=19529768
Mon Apr 07 17:16:03 2014
PSP0 started with pid=3, OS id=11206972
Mon Apr 07 17:16:03 2014
VKTM started with pid=4, OS id=14811302 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Mon Apr 07 17:16:03 2014
GEN0 started with pid=5, OS id=18874522
Mon Apr 07 17:16:03 2014
DIAG started with pid=6, OS id=8585536
Mon Apr 07 17:16:03 2014
DBRM started with pid=7, OS id=18481336
Mon Apr 07 17:16:03 2014
DIA0 started with pid=8, OS id=17498152
Mon Apr 07 17:16:03 2014
MMAN started with pid=9, OS id=9765184
Mon Apr 07 17:16:03 2014
DBW0 started with pid=10, OS id=9371968
Mon Apr 07 17:16:03 2014
DBW1 started with pid=11, OS id=8716736
Mon Apr 07 17:16:03 2014
DBW2 started with pid=12, OS id=17432804
Mon Apr 07 17:16:04 2014
DBW3 started with pid=13, OS id=17104988
Mon Apr 07 17:16:04 2014
LGWR started with pid=14, OS id=8519974
Mon Apr 07 17:16:04 2014
CKPT started with pid=15, OS id=9109842
Mon Apr 07 17:16:04 2014
SMON started with pid=16, OS id=19595368
Mon Apr 07 17:16:04 2014
RECO started with pid=17, OS id=19071052
Mon Apr 07 17:16:04 2014
RBAL started with pid=18, OS id=16646322
Mon Apr 07 17:16:04 2014
ASMB started with pid=19, OS id=16580854
Mon Apr 07 17:16:04 2014
MMON started with pid=20, OS id=15597698
Mon Apr 07 17:16:04 2014
MMNL started with pid=21, OS id=5636354
NOTE: initiating MARK startup
Starting background process MARK
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Apr 07 17:16:04 2014
MARK started with pid=22, OS id=13959326
NOTE: MARK has subscribed
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Mon Apr 07 17:16:05 2014
ALTER DATABASE MOUNT
ARCH: STARTING ARCH PROCESSES
Mon Apr 07 17:16:09 2014
ARC0 started with pid=27, OS id=5374266
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Mon Apr 07 17:16:10 2014
ARC1 started with pid=28, OS id=5439756
Successful mount of redo thread 1, with mount id 3849062549
Physical Standby Database mounted.
Lost write protection disabled
Mon Apr 07 17:16:10 2014
ARC2 started with pid=29, OS id=15073530
ARC1: Archival started
ARC2: Archival started
Mon Apr 07 17:16:11 2014
ARC3 started with pid=31, OS id=10682694
ARC1: Becoming the 'no FAL' ARCH
ARC2: Becoming the heartbeat ARCH
ARC2: Becoming the active heartbeat ARCH
Completed: ALTER DATABASE MOUNT
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
NOTE: Loaded library: System
SUCCESS: diskgroup DATA3 was mounted
Mon Apr 07 17:16:13 2014
ERROR: failed to establish dependency between database xxxxDR and diskgroup resource ora.DATA3.dg
Mon Apr 07 17:16:35 2014
alter database convert to physical standby
ALTER DATABASE CONVERT TO PHYSICAL STANDBY (xxxx)
Completed: alter database convert to physical standby
Mon Apr 07 17:16:51 2014
Thanks,
Satish.