DBVERIFY COMMAND LINE INTERFACE

FAILURE DURING ONLINE TABLESPACE BACKUP

Error: ORA-01113 :- File 1 need media recovery
1- Mount the database (startup mount)
2- Alter database end backup
3- Alter database open

DBVERIFY COMMAND LINE INTERFACE

DBverify is a command line utility used to verify that a backup database or datafile is
valid before it is restored.
Syntax:
C:\dbv file=c:\backup\system01.dbf (press enter)
Then you will see an error DBV-00103: Specified blocksize (4096) is dffers from
actual (8192). Then use like :
C:\dbv file=c:\backup\system01.dbf blocksize= 8192 logfile=dbv.log feedback=100
start=1 end=1000 ;
Feedback means One page = 1 block is checked.

DBVERIFY USING PARFILE

Note: Create a file in notepad like
File=c:\backup\tools01.dbf blocksize=8192
Now save this file with dbv.txt
Now on C prompt type c:\dbv parfile=c:\dbv.txt (Now the verification is started)