No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

11.2.0.4 DB open with _allow_resetlogs_corruption=true
Next thread:
Prev thread: Add & remove External redendency DG with failed group as same disk

Message Score Author Date
After _allow_resetlogs_corruption=true , DB oepn...... Rim . Oct 28, 2022, 01:16
Hi Rim, In the past I used a program called 'un...... Philip Wisse Nov 07, 2022, 21:32

Follow up by mail Click here


Subject: 11.2.0.4 DB open with _allow_resetlogs_corruption=true
Author: Rim ., Singapore
Date: Oct 28, 2022, 01:16, 31 days ago
Os info: Unix
Oracle info: 11.2.0.4
Error info: All sort of dictionary errors
Message:
After _allow_resetlogs_corruption=true , DB oepn. But unable to take backup either expdp nor exp. Any way i can rebuild to avoid this errors ?

Need to backup few old partition
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: 11.2.0.4 DB open with _allow_resetlogs_corruption=true
Author: Philip Wisse, Netherlands
Date: Nov 07, 2022, 21:32, 20 days ago
Message: Hi Rim,

In the past I used a program called 'unloader' for ascii dumps of all tables. Something like:
https://github.com/gregrahn/oracle-ascii-unload
https://community.oracle.com/tech/developers/discussion/2193088/sql-unloader

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