| |
Posted: Apr 01, 2008 09:37:57 AM |
Total Post: 46
Joined: Sep, 2007
|
Hi
I have taken user managed cold backup of the following datafiles.
1.Tools01.dbf
2.Users01.dbf.
but my prob is that i want to integrity check of these two datafile using the DBverify utility.
my Block size :8192
but while run the command getting error.
C:\Documents and Settings\dwaipayan>DBV FILE='H:\BCK\USER\TOOLS01.DBF'
DBVERIFY: Release 9.2.0.1.0 - Production on Tue Apr 1 18:23:45 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
DBV-00103: Specified BLOCKSIZE (2048) differs from actual (8192)
----------------------------------
But While i run the another coomand also getting error.
C:\>DBV FILE='H:/BCK/USER/TOOLS01.DBF' BLOCKSIZE=8192;
DBVERIFY: Release 9.2.0.1.0 - Production on Tue Apr 1 18:41:30 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
LRM-00104: '8192;' is not a legal integer for 'blocksize'
DBV-00001: Illegal command line syntax - parse error = (104)
Plz give me the solution
How i will check ,,my OS is Windows XP with SP2 and Oracle version is :9i
Waiting for the best answer. |
|
|
 Murtuja |
| Posted: Apr 01, 2008 10:27:40 AM |  |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
C:\>DBV FILE='H:\BCK\USER\TOOLS01.DBF' BLOCKSIZE=8192;
try this ..You have specified "/" in file name and I think it's creating problem
|
|
|
|
|
| |
| Posted: Apr 02, 2008 05:43:39 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Hi murtuja
if i give the command acoording u,also getting error.
C:\>DBV FILE='H:\BCK\USER\TOOLS01.DBF' BLOCKSIZE=8192;
DBVERIFY: Release 9.2.0.1.0 - Production on Wed Apr 2 15:11:45 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
LRM-00104: '8192;' is not a legal integer for 'blocksize'
DBV-00001: Illegal command line syntax - parse error = (104)
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 07:12:43 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Try this
C:\>DBV FILE=H:\BCK\USER\TOOLS01.DBF BLOCKSIZE=8192;
You have syntax error so just play with different syntax.
|
|
|
|
|
| |
| Posted: Apr 02, 2008 07:18:28 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Murtuja
i m getting same err, plz help me to solve this prob.
or if u know another way to integrity check plz let me know
C:\>DBV FILE=H:\BCK\USER\TOOLS01.DBF BLOCKSIZE=8192;
DBVERIFY: Release 9.2.0.1.0 - Production on Wed Apr 2 16:45:27 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
LRM-00104: '8192;' is not a legal integer for 'blocksize'
DBV-00001: Illegal command line syntax - parse error = (104)
C:\>
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 07:52:57 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Check the blocksize using this query whether it's 8192 or not..
select * from v$datafile where name like '%tool%'
|
|
|
|
|
| |
| Posted: Apr 02, 2008 09:13:46 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Hi
Murtuja
yeh block size 8192.
i dont know why its not give the actual output.
plz keep replying me ..
thanks a lot.
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 02, 2008 11:24:04 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
The problem is "colon" with blocksize
consider:
D:\>dbv file=d:/bkp/users01.dbf blocksize=8192;
DBVERIFY: Release 10.1.0.5.0 - Production on Wed Apr 2 19:20:56 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
LRM-00104: '8192;' is not a legal integer for 'blocksize'
DBV-00001: Illegal command line syntax - parse error = (104)
D:\>dbv file=d:/bkp/users01.dbf blocksize=8192
DBVERIFY: Release 10.1.0.5.0 - Production on Wed Apr 2 19:21:05 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = d:/bkp/users01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 15
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing (Index): 0
Total Pages Processed (Other): 26
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 597
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 428077 (0.428077)
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 11:48:28 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
It's working with me in both case i.e with colon
dbv file=/opt/oracle/product/9.2.0/oradata/compass/perfstat.dbf blocksize=8192;
and
dbv file=/opt/oracle/product/9.2.0/oradata/compass/perfstat.dbf blocksize=8192
So Problem might be different.
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 02, 2008 12:27:35 PM | |
|
Total Post: 746
Joined: Jul, 2007
|
SQL> host dbv file=d:\bkp\users01.dbf blocksize=8192;
DBVERIFY: Release 10.1.0.5.0 - Production on Wed Apr 2 20:23:10 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
DBVERIFY - Verification starting : FILE = d:\bkp\users01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 640
Total Pages Processed (Data) : 15
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 2
Total Pages Failing (Index): 0
Total Pages Processed (Other): 26
Total Pages Processed (Seg) : 0
Total Pages Failing (Seg) : 0
Total Pages Empty : 597
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
Highest block SCN : 428077 (0.428077)
C:\>dbv file=d:\bkp\users01.dbf blocksize=8192;
DBVERIFY: Release 10.1.0.5.0 - Production on Wed Apr 2 20:24:11 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
LRM-00104: '8192;' is not a legal integer for 'blocksize'
DBV-00001: Illegal command line syntax - parse error = (104)
Because you execute DBV utility from SQLPLUS prompt. and ":" is accepted in sqlplus prompt but not in COMMAND prompt.
|
|
|
|
|
| |
| Posted: Apr 03, 2008 12:35:56 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
Thanks Taj and Murtuja
I was wrong,yesterday night i got solution.
the error was coming because of ";" at the end of the line.
i m happy now.
Thanks a lot both of u.
Thanks & Regards
Dwaipayan Das
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
