We are going to have a look on those steps which are required to restore a lost nonsystem datafile on a different location during the Oracle a database is in open stage. We are going to lose datafiles of a non-system critical tablespace and restore them, while the database is open, to a location other […]
Articles Tagged: NON SYSTEM-CRITICAL DATAFILE
How to recover a corrupted/damaged NON SYSTEM datafile when database in ARCHIVELOG mode
We are going to have a session on recovery about corrupted/damaged/lost/canceled NONSYSTEM datafile (except system & sysaux). Before proceeding to be sure to have a complete backup of your test database and be sure your database is in ARCHIVELOG mode. [oracle@localhost orcl]$ ps -ef|grep smon oracle 7200 2820 0 06:57 pts/1 00:00:00 grep smon And […]