sfk wrote:
> I researched the 'correct' use of dbv. I was not entering the blocksize. When I
> entered
> blocksize my files checked out ok.
>
> Any other ideas..... anyone.
>
>
> sfk wrote:
>
>
>>Thanks Ana. Looks like I may have found my problem. I used dbv and received
>>this output.
>>DBV-00103: Specified BLOCKSIZE (2048) differs from actual (8192).
>>
>>Now I need to research what I think this means and how to fix.
>>
>>Thanks again.
>>
>>"Ana C. Dent" wrote:
>>
>>
>>>sfk wrote:
>>>
>>>>Is there a process I can use to check the integrity of datafiles prior
>>>>to moving over my net to verify there are ok. I am practicing cloning
>>>>and I get the following on an NT system.
>>>>
>>>>ORACLE instance started.
>>>>Total System Global Area 58492956 bytes
>>>>Fixed Size 75804 bytes
>>>>Variable Size 37273600 bytes
>>>>Database Buffers 20971520 bytes
>>>>Redo Buffers 172032 bytes
>>>>CREATE CONTROLFILE REUSE DATABASE "DEMO" NORESETLOGS NOARCHIVELOG
>>>>*
>>>>ORA-01503: CREATE CONTROLFILE failed
>>>>ORA-01210: data file header is media corrupt
>>>>ORA-01110: data file : 'E:\817\ORADATA\DEMO\DATA0001.DBF'
>>>>ORA-01507: database not mounted
>>>>ALTER DATABASE OPEN
>>>>*
>>>>ORA-01507: database not mounted
>>>>
>>>>Thanks in advance.
>>>>
>>>>
>>>>
>>>
>>>Try using dbv
>>>Just curious, under what conditions are you
>>>"moving over my net"? Is the DB open & up?
>>>Exactly how do the files get "moved"?
>
>
If your data has been cleanly shutdown,
AND ALL the files are copied to a new system
(including control files, redo logfiles,etc)
AND into the same folders
AND using "binary mode" copy,
then you should be able to simply
start up this "cloned" database,
because it won't know or care that it
now resides on a different box.
I do this almost weekly.
Received on Mon Mar 31 2003 - 19:52:18 CST
