1) Find out the details of the file corrupted or deleted. 2) If corrupted cp and take backup and then delete it. On standby database server 1) Take backup of the datafile to be restored ; RMAN>backup as copy datafile 9 format '/u01/datafile3.dbf' ; 2) Copy the backup to the production server using scp or any other method On production 1) Take the datafile to be restored offile SQL> alter database datafile 8 offline; Database altered. 2) From RMAN catalog and restore the backup RMAN> catalog datafilecopy '/u06/8.dbf';
cataloged datafile copy
datafile copy file name=/u06/8.dbf RECID=40 STAMP=935966739
4) Put the datafile online again. SQL> alter database datafile 8 online; Database altered. |
Database Technologies > Oracle >