Sunday, May 15, 2011

RMAN Script: OMR Database Full Backup (Database Mounted)

›
  [ dbbkup_full.scp] run { allocate channel c1 type disk; backup tag weekly_omr_full format '/u07/omr/backup/full_%d_%s_%p_%t'...

RMAN Script: Cumulative level 2 backup

›
[ call_dbbkup_cm2.scp] #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2.0" export ORACLE_SID="omr" PATH...

RMAN Script: Cumulative level 1 backup

›
[ call_dbbkup_cm1.scp] #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2.0" export ORACLE_SID="omr" PATH...

RMAN Script: Cumulative level 0 backup

›
[ call_dbbkup_cm0.scp] #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2.0" export ORACLE_SID="omr" PATH=$PAT...
42 comments:

RMAN Script: Deleting archivelog when catalog exists.

›
[call_omr_archflush.scp] #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2.0" export ORACLE_SID="omr...
22 comments:

RMAN Script: Deleting the old archives when no catalog exists

›
[ call_catdb_archflush.scp] #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2.0" export ORACLE_SID="catdb" PA...

RMAN Script: Backing up all the archivelog files

›
[call_arch_bkup.scp] (this scripts is calling the script arch_bkup.scp ) #!/bin/ksh export ORACLE_HOME="/u01/app/oracle/product/10.2....
Tuesday, May 10, 2011

Oracle Solaris 10 Installation on HP DL380G7 server

›

Switching Undo Tablespace

›
CREATE UNDO TABLESPACE "UNDOTBS" DATAFILE '/u05/omr/oradata/undotbs.dbf' SIZE 4000M; SQL> select name from v$tablespace...
Monday, May 9, 2011

Creating Catalog Database on Oracle10g

›
Step 1: Create o/s User: Useradd –u 204 –g 2001 –G 1001 –c “Catdb Catalog User” –m –d /u04/catdb –s /bin/ksh catdb Passwd : Enter password f...