No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
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 users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
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, 154 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, 154 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, 154 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