-
I have a database archive mode, but is crash, i connot recover because dont have the archive files.
I put this parameters in init.ora
_allow_resetlogs_corruption=true
_corrupted_rollback_segments=(r01,r02,r03,r04)
and i intente startup the database with
alter database mount
recover database until cancel using backup controlfile
alter database open resetlogs
but i get this message error
alter database open x
ORA-00704: bootstrap process failure x
ORA-00604: error occurred at recursive SQL level 1 x
ORA-00955: name is already used by an existing object
ORA-01555 shaphot too old (rollback segment too small)
what do i to do ...
I need recover the database consistent o inconsistent
-
I don't understand why you think you need:
_allow_resetlogs_corruption=true
_corrupted_rollback_segments=(r01,r02,r03,r04)
After you issue:
recover database until cancel using backup controlfile
you have to stop the recovery at some point with:
alter database recover cancel
and then, you can open your database with:
alter database open resetlogs
There is a note on metalink outlining this procedure. The note number is 69468.1
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|