데이터베이스 중지

srvctl stop database -d racdb -o immediate



파라미터 파일 복원

srvctl modify database -d racdb -p /dev/raw/raw20




mv $DB_HOME/dbs/initracdb1.ora $DB_HOME/dbs/initracdb1.ora.asm
cp $DB_HOME/dbs/initracdb1.ora.raw $DB_HOME/dbs/initracdb1.ora




mv $DB_HOME/dbs/initracdb2.ora $DB_HOME/dbs/initracdb2.ora.asm
cp $DB_HOME/dbs/initracdb2.ora.raw $DB_HOME/dbs/initracdb2.ora




srvctl start instance -d racdb -i racdb1 -o nomount




alter system set db_recovery_file_dest='' sid='*';
alter system set db_create_file_dest='' sid='*';



컨트롤 파일 복원 확인

srvctl stop instance -d racdb -i racdb1 -o immediate
srvctl start database -d racdb -o nomount




select NAME, DISPLAY_VALUE from v$parameter
where NAME in ('control_files','db_recovery_file_dest', 'db_create_file_dest');



Raw Device 데이터파일로 DB 오픈

srvctl stop instance -d racdb -i racdb1 -o immediate
srvctl start database -d racdb -o mount




ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 4;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 5;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 6;




alter database open;




srvctl stop database -d racdb -o immediate
srvctl start database -d racdb



OCR 복원

ocrconfig -add /dev/raw/raw1
ocrconfig -add /dev/raw/raw2
ocrconfig -delete +CRS
ocrcheck



Vote 복원

crsctl replace votedisk /dev/raw/raw3
crsctl add css votedisk /dev/raw/raw4
crsctl add css votedisk /dev/raw/raw5
crsctl query css votedisk