I've created a test environment where I'll show you, how to recover datafile after physical loss.
Below are the steps which I've simulated for testing purpose.
1.Create a tablespace.
2.Take the full database backup including archivelogs.
3.Remove the datafile from os level.
4.Open the database in mount state.
5.Re-create the deleted datafile and make it offline.
6.Through RMAN restore that datafile.
7.recover the datafile from sql prompt.
8.Online that datafile.
9.Open the database.
Below are the steps which I've simulated for testing purpose.
1.Create a tablespace.
2.Take the full database backup including archivelogs.
3.Remove the datafile from os level.
4.Open the database in mount state.
5.Re-create the deleted datafile and make it offline.
6.Through RMAN restore that datafile.
7.recover the datafile from sql prompt.
8.Online that datafile.
9.Open the database.
No comments:
Post a Comment