Oracle 8.1.7.4 database fault recovery solution instance
The customer's database version is 8.1.7.4. the disk where the data file is located is faulty. After the fault is rectified, the data file needs to be recovered and set to online;
ORA-00376: file 7 cannot be read at this time
ORA-01110: data file 7...
Query v $ recover_file to view the data file to be restored
When the database is backed up to the tape through nbu, the data files, 7, 8, and 9, need to be recovered from the tape.
Rman target "sys/manager" nocatalog
Run
{Allocate channel ch01 type "SBT_TAPE ";
Restore datafile 7;
Recover datafile 7;
}
Run
{Allocate channel ch01 type "SBT_TAPE ";
Restore datafile 8;
Recover datafile 8;
}
Run
{Allocate channel ch01 type "SBT_TAPE ";
Restore datafile 9;
Recover datafile 9;
}
Alter database open;
Check whether there are any data files to be restored:
Select * from v $ recover_file;
View offline data files in v $ datafile, which are online data files:
Alter database datafile '... 'onlien;
Alter database datafile '... 'onlien;
Alter database datafile '... 'onlien;
OK. All data files have been restored. Data is restored in an inconsistent manner.
Oracle Tutorial: instance fault recovery
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian