Recovery method of Oracle database after AIX system crash

The first step is to ensure the integrity of the database instance, including control files, log files, table spaces (System tablespace, user tablespace, and so on).

Create a new database instance with the same name (table space, user, etc. not required).

Sql>shutdown immediate Closing the database

Then copy the original file to the new instance folder, or rename the new instance folder and put the original instance folder in the same directory

Sql>startup mount loading the original instance, may appear control file not writable and other related errors, then can set the file permissions for the readable writable executable (3 need to set), after the successful loading

Sql>select * from v$tablespace view table space name

Sql>alter database open to start the databases, if the table space is missing, you need to delete the corresponding table space to continue

Sql>alter database datafile ' miss_filename ' offline drop, where Miss_filename is a missing file name and contains the full path

Recovery database; The missing file name can be displayed, and finally

Sql>alter database open;

Recovery method of Oracle database after AIX system crash