OS: aix5DB: 9.2.0.8 the customer needs to restore the production database to the development and testing environment through RMAN. After restoring the data files, control files, and related archive files through RMAN, start the recover operation on the database and report the following error after restoring all archives: ORA-01547, ORA-01194, ORA-01110 via alterdatabaseopen
OS: aix5 DB: 9.2.0.8 the customer needs to restore the production database to the development and testing environment through RMAN. After restoring the data files, control files, and related archive files through RMAN, start the recover operation on the database and report the following error after restoring all archives: ORA-01547, ORA-01194, ORA-01110 through alter database open
OS: aix5
DB: 9.2.0.8
The customer needs to restore the production database to the development and testing environment through RMAN, restore data files, control files and related archive files through RMAN, and then start to recover the database, the following error is reported after all archives are restored:
ORA-01547, ORA-01194, ORA-01110
Use alter database open resetlogs;
Report:
SQL> alterdatabaseopenresetlogs;
Alterdatabaseopenresetlogs
*
ERRORatline 1:
ORA-01194: file 1 needs more recoverytobe consistent
ORA-01110:
By setting hidden Parameters
_ Allow_resetlogs_upload uption = TRUE
Open the database.
The database starts reporting ORA-00600 error after opening
ORA-00600: internal error code, arguments: [25012], [1], [0], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [25012], [1], [63], [], [], [], [], [], []
View the information and send it:
ORA-600 [25012] [a] [B]
* C0 '!] 1 m x s0 | 0Arg [a] Tablespace Number
Fg9N9 ~ 4 \ 1f D0Arg [B] Relative file numberITPUB personal space *] 2qX. NC1vg) R *@
When querying the table space where ts # is 1, it is found that it is an undotbs1 table space.
Refer to the documents written by several masters on the Internet, I found that they are not suitable for solving this problem, and finally only try to re-build undotbs1, after switching to undotbs2, delete undotbs1 always reported ORA-30013 error, according to the check results, the _ SYSSMU6 $ rollback segment in undotbs1 is always online. Try to set _ smu_debug_mode = 4 to make the _ SYSSMU6 $ rollback segment offline, but it never succeeds, you can only use hidden parameters again:
_ Offline_rollback_segments = (_ SYSSMU6 $) ITPUB personal space ldtx (X
_ Uploupted_rollback_segments = (_ SYSSMU6 $)
After the database is restarted, undotbs1 is successfully deleted and undotbs1is rebuilt.
I thought it had ended successfully and found that the database continued to report:
ORA-02019: connection description for remote database not foundITPUB personal space !~ C @ J-iU
This error is caused by a distributed error. After the error is handled, the recovery is completed.
The record is a bit rough. O (Clerk _ Clerk) O ha!
