No question at this time
DBA Top 10
1 M. Cadot 19800
2 A. Kavsek 13000
3 M. Hidayathullah ... 11400
4 B. Vroman 8500
5 P. Wisse 5900
6 T. Boles 5400
7 J. Schnackenberg 4500
8 P. Knibbs 2200
8 K. Pagadala 2200
10 G. Lambregts 2100
10 K. Van Nieuwenhov... 2100
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47979
Total active users1861
Act. users last 24h12
Act. users last hour1
Registered user hits last week625
Registered user hits last month1533
Go up

duplcate for standby from active database
Next thread: knowledge gain
Prev thread: migrate apex and ords from vm machine to phsyical server

Message Score Author Date
Hi all, ODA X5-2, 2 appliance box on 2 differe...... Pekka Koppanen May 15, 2017, 17:02
Dear, Please check following mos notes and link...... Mirza Hidayathullah Baig May 16, 2017, 05:45
Dear, In addition to above mos notes, please re...... Mirza Hidayathullah Baig May 16, 2017, 06:03

Follow up by mail Click here


Subject: duplcate for standby from active database
Author: Pekka Koppanen, Sweden
Date: May 15, 2017, 17:02, 42 days ago
Os info: red hat
Oracle info: 11.2.0.3
Message: Hi all,

ODA X5-2, 2 appliance box on 2 different datacenter
Running data guard on the appliance box. primary on one datacaenter and standby on the other datacaenter

the error during duplicate

Errors in file /u01/app/oracle/diag/rdbms/xxxxx_se02/xxxxx/trace/xxxxx_lgwr_98134.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/oradata/datastore/xxxxxxonlinelog/o1_mf_3_dhrvft0s_.log’
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

Same for all redologs, the duplicate create controlfiles and datafiles.

If I run the statement select member from v$logfile; on the standby the files are there but not on the filesystem.

I have run the same duplicate on this enviroment about 10 times without any problem


I Hope you understand
/P
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: duplcate for standby from active database
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 16, 2017, 05:45, 42 days ago
Message: Dear,

Please check following mos notes and links.

ORA-313 ORA-312 ORA-349 Mounting a Standby Database (Doc ID 2031961.1)

Open Resetlogs Reports Errors ORA-00313 and ORA-00312 to Alert (Doc ID 1366482.1)

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F2897214&_afrLoop=244977301526302&resultTitle=Create+new+db+from+backup+of+standby+db&commId=2897214&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=r1gkddwcl_175

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: duplcate for standby from active database
Author: Mirza Hidayathullah Baig, United Kingdom
Date: May 16, 2017, 06:03, 42 days ago
Message: Dear,

In addition to above mos notes, please refer following mos note as well for step by step creating standby using rman duplication.


Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID 1075908.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here