Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts
Thursday, 2 October 2014

RMAN Automatic Script : Recover & Restore Control File

›
export ORACLE_SID=TEST2 sqlplus /nolog <<EOF connect rman/rman_oracledba as sysdba startup nomount exit EOF echo 'Restoring Contr...

RMAN Automatic Script : Restore & Recover Datafile

›
export ORACLE_SID=TEST2 echo 'starting TEST2 in MOUNT mode' echo sqlplus /nolog <<EOF connect rman/rman_oracledba as sysd...

RMAN Automatic Script : Recover & Restore with Resetlogs

›
rman target rman/rman_oracledba@test2 catalog rman/rman_oracledba@test1 <<EOF run { allocate channel d1 type disk; restore controlfil...

RMAN Automatic Script : Restore & Recover tablespace

›
export ORACLE_SID=TEST2 rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate ...

RMAN Automatic Script : Recover & Restore

›
export ORACLE_SID=TEST2 sqlplus /nolog <<EOF connect / as sysdba shutdown immediate startup mount exit EOF rman <<EOF connect t...

RMAN Automatic Script : Resync

›
export ORACLE_SID=TEST2 # This script will resync the catalog. rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rm...

RMAN Automatic Script : Backup Tablespace

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk; ba...

RMAN Automatic Script : Validate

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk; re...

RMAN Automatic Script : List Backup

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 allocate channel for maintenance type d...

RMAN Automatic Script : Backup Archivelog

›
export ORACLE_SID=TEST2 sqlplus /nolog <<EOF connect / as sysdba alter system switch logfile; EXIT EOF rman <<EOF connect targe...

RMAN Automatic Script : Backup Control File

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk ...

RMAN Automatic Script : Image copy

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk; co...

RMAN Automatic Script : Backup datafile

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk; ba...

RMAN Automatic Script : Duplicate

›
export ORACLE_SID=TEST2 sqlplus /nolog <<EOF connect / as sysdba @rmanDuplicate.sql exit EOF>> rmanDuplicate.sql : ...

RMAN Automatic Script : Backup Script - Full Backup

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk;...

RMAN Automatic Script : Backup Script Incremental Level 0 - 1

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk;...

RMAN Automatic Script : List Backup/ Report orphan

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 list backup; EOF rman <<EOF...

RMAN Automatic Script : List Backups

›
rman <<EOF connect catalog rman/rman_oracledba@test1 connect target sys/oracledba@test2 list backup; EOF

RMAN Automatic Script : Recover

›
rman <<EOF connect target rman/rman_oracledba@test2 connect catalog rman/rman_oracledba@test1 run { allocate channel d1 type disk...
Friday, 26 September 2014

RMAN Commands

›
RMAN (Recovery Manager) Commands in Oracle Start RMAN from the OS command line. rman [ TARGET [=] ['] [userid][/[password]][...