rman scripts

configure channel device type disk rate 5M(100K)
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
SHOW DEVICE TYPE;

report schema;

*****************************************************************************STARTUP Startup NOMOUNT PFILE='C:\esas\oracle\app\oracle\admin\XE\pfile\initXE.ora
RESTORE SPFILE FROM AUTOBACKUP; RESTORE SPFILE TO 'C:\spfileTEMP.ora' FROM AUTOBACKUP; ******************************************************************************
restore tablespace "UNDO";

run {
set until time "to_date('07 02 2008 09:00:00', 'MM DD YYYY HH24:MI:SS')";
restore database;
recover database;
}

run {
set until time "to_date('01 18 2008 10:00:00', 'MM DD YYYY HH:MI:SS')";
restore database;
recover database;
alter database open resetlogs;
}

alter database datafile 'C:\esas\oracle\oradata\XE\ESASBRANCH.DBF' offline;

alter tablespace x online

run{
restore database
recover database until time "to_date('01 18 2008 10:00:00', 'MM DD YYYY HH:MI:SS')";
alter database open resetlogs;
}

RESTORE CONTROLFILE FROM AUTOBACKUP;
recover database until cancel using backup controlfile

RMAN> configure device type disk backup type to compressed backupset;

----------------------------------------------------------------------
RESTORE CONTROLFILE FROM AUTOBACKUP;

ALTER DATABASE DATAFILE 'C:\ESAS\ORACLE\ORADATA\XE\ESASBRANCH.DBF' OFFLINE;ALTER TABLESPACE ESASBRANCH OFFLINE

restore controlfile from '/sbclocal/app/oracle/admin/IBADCP01/dumprman/controlfile_IBADCP01_c-4238742468-20071219-01';

run{
allocate channel c1 device type sbt;
backup recovery area;
}

run{
allocate channel c1 device type sbt;
backup database plus archivelog;
}
crosscheck backup
DELETE NOPROMPT EXPIRED BACKUPSET;
run {allocate channel c1 device type disk
format='C:\usr.bak';
backup datafile 4;
}

run{
backup
format='C:\%d_%s_%p'
database plus archivelog;
}

sql 'alter database archive log current';
list backup summary;

run{
backup device type disk tag 'kasim28' database;
backup device type disk tag 'kasim28' archivelog all not backed up delete all input;
delete noprompt obsolete device type disk;
}

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
configure device type disk backup type to compressed backupset;


SELECT archivelog_change#-1 FROM v$database;

run { set until scn 3412816;
restore database;
recover database;
alter database open resetlogs;
}

run {
shutdown immediate;
startup mount;
set until time 'Nov 26 2007 17:00:00';
# set until scn 1000; # alternatively, you can specify SCN
# set until sequence 9923; # you can specify log sequence number
restore database;
recover database;
alter database open resetlogs;
}

RECOVER DATABASE UNTIL TIME "to_date('2008-04-22:13:20:00','YYYY-MM-DD:HH24:MI:SS')";

run {
sql "ALTER TABLESPACE users OFFLINE" ;
restore tablespace users ;
recover tablespace users ;
sql "ALTER TABLESPACE users ONLINE" ;
}

select value from v$parameter where name='db_recovery_file_dest_size';

run{
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=C:\program files\tivoli\tsm\agentoba\tdpo.opt)';
backup database;
}

run{
backup device type disk tag '%TAG' database;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup device type disk tag '%TAG' archivelog all not backed up delete all input;
delete noprompt obsolete device type disk;
}
******************* EM backup job to tape *******************