RMAN_Script.bat

Echo on
set ORACLE_SID=ORCL
RMAN target / cmdfile=’rman_backup.rcv’ msglog=’oraclelog.log’ APPEND

RMAN_Backup.rcv

shutdown immediate;
connect target /
startup mount;
run {
backup
( database include current controlfile );
}
alter database open;
Scheduling RMAN Backups

Open Windows Scheduler
The user …

In Oracle:
A local or central Data Integrator Repository requires that you
Create a dedicated database and define a user with the right to:
Role
Connect
System
Create Sequence
Create Session
Create Table
Create View
Use the DI_Job_Server role which …

The trace file is created in the USER_DUMP_DEST Initialization parameter with a filename such as sid_ora_pid.trc
In SQLPLUS run the following command:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;…

Backup and Restore using RMAN on Windows

Backup
Open a command prompt

1. c:\>RMAN
2. RMAN>connect target username/password@database
3. RMAN>shutdown immediate
4. RMAN> startup mount
5. run {
   allocate channel Channel1 type disk format ‘c:\backup\oracle\%d_%T’;
   backup
   ( database include current controlfile );
   }

Restore

1. Open