Restore leracundotbs tablespace recover status

A set of mongolerac10g databases. Check and find that the undotbs tablespace is in the recover status. The remote processing process is as follows: datafile5undotbs02 is in the recover status,

A set of Oracle RAC 10 Gb database, check found that the undotbs tablespace is in the recover status, the remote processing process is as follows: found that datafile 5 undotbs02 status is recover,

A set of Oracle RAC 10 Gb database, check that the undotbs tablespace is in the recover status, the remote processing process is as follows:

1. Check the database status:

Select file #, status from v $ datafile where status = 'recover ';

FILE # STATUS

-----------------

5 RECOVER

Select file_name, tablespace_name, status from DBA_DATA_FILES where file_id = 5;

Confirm the specific datafile of datafile 5;

It is found that datafile 5 undotbs02 is in the recover status, and it is confirmed that instance 2 is in use.

2. Check the logs required for recover:

Select * from v $ recovery_log;

A total of 14 archive log files are found for recover.

Check whether the archive file exists based on the query results. If the archive file exists locally, use it directly. If the archive file does not exist locally, restore the archive log to the local location before using it. --- All exist locally.

3. Stop two instances of the database.

4. Start instance 2 (undotbs02 instance) to the mount status.

5. recover datafile 5;

Follow the prompts to apply the archived log file for recover.

6. alter database datafile 5 online;

7. alter database open; (two instances)

8. check and confirm.

For more information about Oracle, see the Oracle topic page? Tid = 12