RE: Veritas CFS or QFS ? Which for High Hybrid Transaction Load Benchmark on RAC with Solaris 10/Oracle 10g ?
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx, "'Zhu,Chao'" <zhuchao@xxxxxxxxx>
- Date: Thu, 31 Aug 2006 21:52:27 +0800
ALL CAPITALS is hard to read...
Yes, you can use dd for moving your cooked files onto raw devices. A a raw
device is just like any other file, you don't need any RMAN magic to get
your files on these.
However, you must be aware of how much space does Oracle reserve in
beginning of the datafile (before datafile header) for cooked filesystems
and for raw. This varies between platforms.
I'd create a small tablespace onto filesystem and another one directly to
raw device - then I'd attach to CKPT process with truss and issued a
checkpoint.
As checkpoint happens truss should report into what offset is CKPT doing its
write - in other words in which block from start of the file the datafile
header resides (yes, the datafile header doesn't reside physically in the
first block of a datafile. It's often the 2nd one).
Anyway, if the amount of reserved blocks is the same between raw and cooked,
then you can just blindly dd your datafiles onto raw devices. If the raw
offset differs from cooked, then you have to adjust your dd parameters to
match raw offsets.
Tanel.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of VIVEK_SHARMA
Sent: Thursday, August 31, 2006 18:46
To: Zhu,Chao
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Veritas CFS or QFS ? Which for High Hybrid Transaction Load
Benchmark on RAC with Solaris 10/Oracle 10g ?
Thanks Zhu for the info & replies
Some Questions are IN CAPITALS BELOW:-
_____
From: Zhu,Chao [mailto:zhuchao@xxxxxxxxx]
Sent: Thursday, August 31, 2006 2:08 PM
To: VIVEK_SHARMA
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Veritas CFS or QFS ? Which for High Hybrid Transaction Load
Benchmark on RAC with Solaris 10/Oracle 10g ?
Simply use rman to restore your datafiles to raw volumes.
OK
The most min-downtime solution is;
build a standby on the raw volume on rac, do a switch over, and your
databsae is running in rac mode within 10 minutes.
THERE ARE NO TIME CONSTRAINTS AS NO PRODUCTION DATABASE IS INVOLVED.
THE AIM IS TO CHECK THE POSSIBILITY OF CONVERTING A BIG BENCHMARK DATABASE
CURRENTLY EXISTING ON A MOUNTED "UFS" FILESYSTEM "TO" RAW DEVICES WITHOUT
USING EXPORT/IMPORT & RMAN.
You can take anytime you desire to make your standby database onto the raw
volume.
IS IT POSSIBLE IN SOME MANNER TO COPY THE DATAFILES FROM THE SOURCE DATABASE
EXISTING ON MOUNTED "UFS" FILESYSTEM PARTITIONS "TO" THE TARGET DATABASE
EXISTING ON PRE-CREATED RAW DEVICES FOR THE 1st TIME FOR THE CREATION OF THE
STANDBY DATABASE?
CAN "dd" COMMAND BE USED?
Thanks
Other related posts:
