No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

11.2.0.4 DB open with _allow_resetlogs_corruption=true
Next thread: Keyword to find the DB issue
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, 218 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, 207 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