Skip to main content

Posts

Showing posts from March, 2012

DBVERIFY: Database Verification Utility

DBVERIFY  is a utility of Oracle , that can be used to perform a physical structure integrity check against  database files. Note that the database should be off line before performing a DBVERIFY. But it will work with online data files also,but its not recommended. DBVERIFY is invoked using dbv command.It should be called from ORACLE_HOME/bin directory. To access help on DB_VERIFY type:   dbv help=y To perform a simple DBVIRIFY use below command.Output will be written to the dbv.log file. >dbv file=/u01/oracle/product/10.2.0/oradata/orcl/users01.dbf logfile=dbv.log Note that this is only a verification tool to get a idea about data files,whether they are corrupted or not.You'll have to follow other methods to recover corrupted data files. Exmples: dbv example of  a datafile with no corruption. (Pages are data blocks) DBVERIFY: Release 11.2.0.2.0 - Production on Tue Mar 13 15:41:47 2012 Copyright (c) 1982, 2009, Oracle and/or its ...

Linux tar Command

The  tar (tape archive) command bundles a bunch of files together and creates an archive  on a tape, disk drive etc. Simple way for creating a tar file. Go to the relevant path.In our example go to the path where "myfolder" resides.So if I want to add files in myfolder to a tar file issue below command.It will create the tar file in /my location. tar -cvf  /my/test.tar  myfolder How to untar... Go to the location where you want to untar the files/folder and issue below command. tar -xvf  /my/test.tar You can use below command to list the contents of a tar file to a log. tar -tvf  test.tar  > temp/test.log Options available with tar command: c  Create a new archive. t  List the contents of an archive. x  Extract the contents of an archive. f  The archive file name is given on the command line (required whenever the tar output is going to a file) M  The archive can span multiple flop...