Windows Server 2019 Oracle 19c RMAN Back Details

任国强發表於2024-03-20

Window Task Scheduler Exported:

<?xml version="1.0" encoding="UTF-16"?>
<Task version="1.4" xmlns="http://schemas.microsoft.com/windows/2004/02/mit/task">
  <RegistrationInfo>
    <Date>2024-03-19T10:08:28.1077164</Date>
    <Author>BEIGENECORP\svc.dotm-admin-1</Author>
    <URI>\RMAN\rman_incremental_differential</URI>
  </RegistrationInfo>
  <Triggers>
    <CalendarTrigger>
      <Repetition>
        <Interval>PT4H</Interval>
        <Duration>P1D</Duration>
        <StopAtDurationEnd>false</StopAtDurationEnd>
      </Repetition>
      <StartBoundary>2024-03-19T10:07:11</StartBoundary>
      <Enabled>true</Enabled>
      <ScheduleByDay>
        <DaysInterval>1</DaysInterval>
      </ScheduleByDay>
    </CalendarTrigger>
  </Triggers>
  <Principals>
    <Principal id="Author">
      <UserId>S-1-5-21-2467427501-1309223053-903455979-16652</UserId>
      <LogonType>Password</LogonType>
      <RunLevel>HighestAvailable</RunLevel>
    </Principal>
  </Principals>
  <Settings>
    <MultipleInstancesPolicy>IgnoreNew</MultipleInstancesPolicy>
    <DisallowStartIfOnBatteries>true</DisallowStartIfOnBatteries>
    <StopIfGoingOnBatteries>true</StopIfGoingOnBatteries>
    <AllowHardTerminate>true</AllowHardTerminate>
    <StartWhenAvailable>true</StartWhenAvailable>
    <RunOnlyIfNetworkAvailable>false</RunOnlyIfNetworkAvailable>
    <IdleSettings>
      <StopOnIdleEnd>true</StopOnIdleEnd>
      <RestartOnIdle>false</RestartOnIdle>
    </IdleSettings>
    <AllowStartOnDemand>true</AllowStartOnDemand>
    <Enabled>true</Enabled>
    <Hidden>false</Hidden>
    <RunOnlyIfIdle>false</RunOnlyIfIdle>
    <DisallowStartOnRemoteAppSession>false</DisallowStartOnRemoteAppSession>
    <UseUnifiedSchedulingEngine>true</UseUnifiedSchedulingEngine>
    <WakeToRun>false</WakeToRun>
    <ExecutionTimeLimit>PT72H</ExecutionTimeLimit>
    <Priority>7</Priority>
  </Settings>
  <Actions Context="Author">
    <Exec>
      <Command>D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential_rman_generate.cmd</Command>
    </Exec>
    <Exec>
      <Command>E:\Oracle19C\bin\rman.exe</Command>
      <Arguments>target / @D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman log=D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.log</Arguments>
      <WorkingDirectory>D:\BackUp\DATABASE\ORCLDEV19\recovermanager</WorkingDirectory>
    </Exec>
  </Actions>
</Task>

D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential_rman_generate.cmd

if %time:~0,2% leq 9 (set hour=0%time:~1,1%) else (set hour=%time:~0,2%)

SET MYDATETIME=%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%hour%%TIME:~3,2%

@echo on

echo RUN > D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman

echo { >> D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman

echo     BACKUP INCREMENTAL LEVEL 1 DATABASE FORMAT "D:\BackUp\DATABASE\ORCLDEV19\recovermanager\INCREMENTAL_DIFFERENTIAL_%MYDATETIME%" TAG=TAG20240319T051011; >> D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman

echo } >> D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman

@echo off

EXIT

D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman

RUN 
{ 
    BACKUP INCREMENTAL LEVEL 1 DATABASE FORMAT "D:\BackUp\DATABASE\ORCLDEV19\recovermanager\INCREMENTAL_DIFFERENTIAL_202403200607" TAG=TAG20240319T051011; 
} 

D:\BackUp\DATABASE\ORCLDEV19\recovermanager\incremental_differential.rman.template

CONNECT TARGET /;

RUN
{
    REM # BACKUP INCREMENTAL LEVEL 1 DATABASE FORMAT D:\BackUp\DATABASE\ORCLDEV19\recovermanager\INCREMENTAL_DIFFERENTIAL_'&1' TAG=TAG20240319T051011;
    BACKUP INCREMENTAL LEVEL 1 DATABASE FORMAT D:\BackUp\DATABASE\ORCLDEV19\recovermanager\INCREMENTAL_DIFFERENTIAL_%T TAG=TAG20240319T051011;
}

Knowledge Base: Oracle 19c RMAN BACKUP Keyword [FORMAT

相關文章