Find corruption report on Alert log file. ORA-01578: ORACLE data block corrupted (file # 7, block # 65) ORA-01110: data file 7: ‘+DB_DATA01/INDIAN/DATAFILE/USERS.267.3’ Action Plan: 1. Take the data file (7) offline. SQL> alter database datafile 7 offline; 2. Use RMAN ‘BACKUP AS COPY…
Error accord when we trying to mount the ASM disk Group. SQL> startup mount ORA-15032: not all alterations performed ORA-15063: diskgroup “” lacks quorum of…
Note: 1. Script will take only disk based backup 2. It will not backup archive log files ################RMAN Backup Scripts for Non-Rac Database#################### run {…
Introduction: – i.e. a situation in which your database server has been destroyed and has taken all your database files (control files, logs and data…
Restore and Recover database to a new host with different directory structure In this case DBID of the database will be the same as of…
Restore and Recover database to a new host with same directory structure In this case DBID of the database will be the same as of…
Case 1: Our database has been crashed, due to disk corruption. All Database files have been not accessible but RMAN backup set location is accessible.…
NOTE, although automatic undo and undo tablespace is used by the database, the following procedure is the same. The only difference is that the segment…
If you have detected the loss of the rollback datafile and the database is still up and running, DO NOT SHUT IT DOWN. In most…
Situation where the database was last shut down abort or crashed. In this case, it is almost certain that the rollback segments that had extents…
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
