Corruption Undo Tablespace Delete and Create (Non Backup)

Corruption Undo Tablespace Delete and Create (Non Backup)

1. select name from v$datafile;

2. rename undo.dbf datafile (with os)

3. startup mount;

4. alter database datafile ‘/u01/erpdb/oracledata/db/apps_st/data/undo01.dbf’ offline drop;

5. select segment_name,tablespace_name,status from dba_rollback_segs; (media recovery isteyen objeler)

6. create spfile from pfile;

7. edit pfile

_offline_rollback_segments=(_SYSSMU12_1441199644$,_SYSSMU11_1441199140$,_SYSSMU10_1441199130$,_SYSSMU9_1441196857$,_SYSSMU8_1441196857$,_SYSSMU7_1441196857$,_SYSSMU6_1441196848$,_SYSSMU5_1441196848$,_SYSSMU5_1441196848$,_SYSSMU4_1441196848$,_SYSSMU3_1441196845$,_SYSSMU2_1441196845$,_SYSSMU1_1441196845$)

8. alter database open;

9. drop tablespace UNDO;

10. create UNDO tablespace undotbs1 datafile ‘Path’;

11. alter system set undo_management = auto scope=spfile;

Bir cevap yazın

E-posta hesabınız yayımlanmayacak.