Posts filed under: Oracle

RMAN Backup and Restort Script for Windows

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 …

Oracle user rights needed for creating a local reporitory for a Data Integrator Job Server 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 …

Backup the control file

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;

Oracle RMAN 11g backup and recovery

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