Oracle database Cold standby under Windows system

First, background:

The specific scenario is that the database is not an ordinary OLTP system, more like an OLAP system, the data update frequency is very low, operating in the Noarchivelog mode, real-time requirements are low, but only one copy of the data can not be lost, the need to deal with disk corruption. This should be a relatively good application scenario for cold preparation.

Second, planning:

Attach a disk to the database server more than one. Find out the exact location of the Oracle Datafile,controlfile,spfile,redologfile,tempfile, piece together the Bat command, and execute it on the sqlplus. Scheduled scheduling through the Windows Task Scheduler.

Third, detailed steps:

1. Create the SQL script:

SetFeedbackoffSetHeadingoffSetVerifyoffSetTrimspooloffSetPageSize0SetLinesize $define dir= 'G:\oraclebackup\InstanceNames\LUOYI\coolback'Define Script= 'G:\oraclebackup\InstanceNames\LUOYI\coolback\coolbak.sql'Spool&ScriptSelect 'Ho Copy' ||Name|| '&dir'  fromV$controlfileUnion  AllSelect 'Ho Copy' ||Name|| '&dir'  fromV$datafileUnion  AllSelect 'Ho Copy' ||Member|| '&dir'   fromV$logfileUnion  AllSelect 'Ho Copy' ||Name|| '&dir'  fromV$tempfile/CreatePfile= '&dir/initluoyi.ora'  fromSpfile;spooloffshutdownImmediatestart&ScriptStartupExit/

2. Create a batch script:

@echo>>g:\oraclebackup\instancenames\cool_back.Log@echoLuoyiBackupIsStart>>g:\oraclebackup\instancenames\cool_back.Log@echo%Date% >>g:\oraclebackup\instancenames\cool_back.Log@echo% Time% >>g:\oraclebackup\instancenames\cool_back.Log@echo>>g:\oraclebackup\instancenames\cool_back.LogSetOracle_sid=Luoyidel/s/q G:\oraclebackup\InstanceNames\LUOYI\Coolbacksqlplus"/as sysdba" @g:\oraclebackup\instancenames\luoyi\luoyi_cool_backup.sql >>g:\oraclebackup\instancenames\ Cool_back.Log@echo>>g:\oraclebackup\instancenames\cool_back.Log@echoLuoyiBackupis finished >>g:\oraclebackup\instancenames\cool_back.Log@echo%Date% >>g:\oraclebackup\instancenames\cool_back.Log@echo% Time% >>g:\oraclebackup\instancenames\cool_back.Log@echo>>g:\oraclebackup\instancenames\cool_back.Log@echo------------------------------------------------------------------------

3. Create a task schedule schedule.

------------------------

This article is organized from the network and verified by testing

Oracle database Cold standby under Windows system