Oracle data file Recover recovery process

1. Querying data File status first

   Select name,status,file# from V$datafile;

2. Close the database and stop monitoring

Shutdown immediate;

3. Open the Database

Startup

4. Take the Recover status database offline 15 for the data file number

ALTER DATABASE datafile offline;

5. Recovering data files

Recover DataFile 15;

No problem will prompt recovery mode input Auto can

6. After successful recovery, put the data file online

ALTER DATABASE datafile online;

7. Open the monitor, the first step to check the data file status

This article is from the "Automated Operations" blog, please be sure to keep this source http://whf191.blog.51cto.com/5763502/1720413

Oracle data file Recover recovery process