No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 7600
3 B. Vroman 4800
4 P. Wisse 4000
5 J. Schnackenberg 3200
6 J. PĂ©ran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48536
Total active users1398
Act. users last 24h2
Act. users last hour0
Registered user hits last week128
Registered user hits last month434
Go up

Error occurred with recursive SQL level after RMAN DUPLICATE
Next thread: Multi-ports and listeners configured to access the same database
Prev thread: copy oracle software

Message Score Author Date
Hi, We have a process that duplicate a containe...... Lauri Oct 16, 2019, 11:03
Hi, When using Oracle there are always others h...... Philip Wisse Oct 17, 2019, 09:57
Hi Philip, Yes, I know about that Doc ID 225088...... Lauri Oct 17, 2019, 12:46
Lauri, There is (only) a workaround. The workar...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Oct 17, 2019, 13:25
Hi Philip, Thanks! Indeed, and that's probably ...... Lauri Oct 19, 2019, 11:19

Follow up by mail Click here


Subject: Error occurred with recursive SQL level after RMAN DUPLICATE
Author: Lauri, Netherlands
Date: Oct 16, 2019, 11:03, 345 days ago
Os info: Linux x86 64bit
Oracle info: 12c
Error info: ORA-00604, ORA-01187, ORA-01110
Message: Hi,

We have a process that duplicate a container database from a production server to a test server using the RMAN DUPLICATE command (I do not have access to that script).
After the duplicate, whe we long onto the test database, when we try to create a function, we get this error:

CREATE OR REPLACE FUNCTION ReplaceString (WAARDE IN VARCHAR) RETURN VARCHAR
*
FOUT in regel 1:
.ORA-00604: Fout opgetreden bij recursief SQL-niveau 1.
ORA-01187: Kan niet lezen uit bestand , wegens niet-doorstaan van verificatietesten.
ORA-01110: Gegevensbestand 204: '/oradata/bgr1/bgr1tbel/temp2_bgr1tbel.dbf'.

Does someone know how to get rid of this error without having to do:

create temporary tablespace temp1_bgr1tbel tempfile '/oradata/bgr1/bgr1tbel/temp1_bgr1tbel.dbf;
alter database default temporary tablespace temp1_bgr1tbel;
drop tablespace temp2_bgr1tbel including contents and datafiles;

or:

alter database tempfile '/oradata/bgr1/bgr1tbel/temp2_bgr1tbel.dbf' drop;
select file_name,status from dba_temp_files;
alter tablespace temp2_bgr1tbel '/oradata/bgr1/bgr1tbel/temp2_bgr1tbel.dbf' size 5G reuse autoextend on;

Thanks by advance for any tip.
Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Error occurred with recursive SQL level after RMAN DUPLICATE
Author: Philip Wisse, Netherlands
Date: Oct 17, 2019, 09:57, 344 days ago
Message: Hi,

When using Oracle there are always others having the same problems ;-)

RMAN Duplicate Corrupting Temp Files ORA-01187 ORA-01110 (Doc ID 2250889.1)

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

Subject: Re-Error occurred with recursive SQL level after RMAN DUPLICATE
Author: Lauri, Netherlands
Date: Oct 17, 2019, 12:46, 344 days ago
Message: Hi Philip,

Yes, I know about that Doc ID 2250889.1... but I not not have such MOS account at that moment.
This is the reason why I posted this question, to found out how you might have solved it for yourself.

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

Subject: Re: Re-Error occurred with recursive SQL level after RMAN DUPLICATE
Author: Philip Wisse, Netherlands
Date: Oct 17, 2019, 13:25, 344 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Lauri,

There is (only) a workaround. The workaround is described at:
https://mandysandhu.com/2017/05/29/rman-duplicate-corrupting-temp-files-12-1/

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

Subject: Re-Error occurred with recursive SQL level after RMAN DUPLICATE
Author: Lauri, Netherlands
Date: Oct 19, 2019, 11:19, 342 days ago
Message: Hi Philip,

Thanks! Indeed, and that's probably the easiest way to do.

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