1Z0-032 Question #110: Real Exam Question with Answer & Explanation

In your production database, you observe that one of the data files is corrupted while the database was functional. When investigating the reason, you find that the media has crashed and now you have to restore the data file to a different location while the database is functional. You have the option of using the following steps: 1. Take the tablespace offline by using the ALTER TABLESPACE command in IMMEDIATE mode. 2. Restore the data file to a new location. 3. Apply the archived redo log files. 4. Use the ALTER DATABASE command to update the control file. 5. Bring the tablespace online by using the ALTER TABLESPACE command. Which sequence of steps would you use to restore the data file, ensuring near to zero downtime?