COLD BACKUP OF RAW FILESYSTEM

COLD BACKUP OF RAW FILESYSTEM

SQL> select status from v$backup;

STATUS
---------

NOT ACTIVE

NOT ACTIVE

.
.
.
21 rows selected.

select file#,status,error,fuzzy,recover from v$datafile_header;

SQL> col error format a20

SQL> /

FILE# STATUS ERROR FUZ REC
---------- ------- -------------------- --- ---

1 ONLINE YES NO

2 ONLINE YES NO

.
.
.

21 rows selected.

SQL> select name,bytes,create_bytes,bytes/8192 "NUMBLOCKS" from v$datafile

NAME BYTES CREATE_BYTES NUMBLOCKS
--------------------------------------------- ------------- ------------ ---------

/dev/vx/rdsk/racdg/orcl_raw_system01 2147483648 2147483648 262144

/dev/vx/rdsk/racdg/orcl_raw_undotbs1 3093299200 3093299200 377600

/dev/vx/rdsk/racdg/orcl_raw_cadata01 26214400000 26214400000 3200000

/dev/vx/rdsk/racdg/orcl_raw_cwmlite 199229440 199229440 24320

/dev/vx/rdsk/racdg/orcl_raw_drsys 89128960 89128960 10880

/dev/vx/rdsk/racdg/orcl_raw_example 513802240 513802240 62720

/dev/vx/rdsk/racdg/orcl_raw_indx01 2147483648 2147483648 262144

/dev/vx/rdsk/racdg/orcl_raw_odm 251658240 251658240 30720

/dev/vx/rdsk/racdg/orcl_raw_tools 10485760 10485760 1280

/dev/vx/rdsk/racdg/orcl_raw_undotbs2 3093299200 3093299200 377600

/dev/vx/rdsk/racdg/orcl_raw_xdb 498073600 498073600 60800

/dev/vx/rdsk/racdg/orcl_raw_users 23068672 23068672 2816

$ dd if=/dev/vx/rdsk/racdg/orcl_raw_cadata01 of=/bkp/back_dd/orcl_raw_cadata01 bs=8k count=3200001

3200001+0 records in

3200001+0 records out

$ dbv file=./orcl_raw_cadata01 blocksize=8192 feedback=10000

---------------------------------------------------------------------------------------------
$ dd if=/dev/vx/rdsk/racdg/orcl_raw_temp01 of=/bkp/back_dd/orcl_raw_temp01 bs=8k count=748801

748801+0 records in

748801+0 records out

$ dbv file=./orcl_raw_temp01 blocksize=8192 feedback=10000

DBVERIFY: Release 9.2.0.6.0 - Production on Tue Dec 13 05:51:43 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBV-00100: Specified FILE (./orcl_raw_temp01) not accessible

$ dbv file=./orcl_raw_temp01 blocksize=8192 feedback=10000

DBVERIFY: Release 9.2.0.6.0 - Production on Tue Dec 13 05:52:03 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

DBVERIFY: Skipping temporary file ./orcl_raw_temp01

$ compress -v orcl_raw_temp01

orcl_raw_temp01: Compression: 88.48% -- replaced with orcl_raw_temp01.Z

For DBV command line options visit
http://www.oracleutilities.com/OSUtil/dbv.html

Also read followinf metalink documents
Note:45351.1 Copying Oracle files to raw devices using UNIX dd
Note:120934.1 Backup & Recovery in the Oracle Parallel Server
Note:120934.1 Backup & Recovery in the Oracle Parallel Server