Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- dba:rman_script01 [2010/09/24 17:08] – gpipperr
+++ dba:rman_script01 [2010/09/27 13:12] – gpipperr
@@ Zeile 1: / Zeile 1: @@
-====== Beispiele für RMAN Script Bausteine ======
+====== Beispiele für ein RMAN Script ======
+Über ein zentrales Script werden allen Datenbanken auf dem Host einzeln gesichert.\\
+Aufruf:
+	* backup.sh mit einem Eintrag auf die runRMAN.sh pro DB
+	* runRMAN.sh ruft eigentliche RMAN Sicherung auf, sichert Traces vom Controlfile und spfile
+	* info.sql spoolt metadaten aus der DB
 OS:Unix\\
-DB:9i-10g\\
+DB:11g\\
-<code plsql>
+<code sh runBackup.sh>
-CONFIGURE RETENTION POLICY TO REDUNDANCY 10;
-CONFIGURE CONTROLFILE AUTOBACKUP ON;
-CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\oracle\recovery_area\plmt\backupset\PLMT_%F';
-CONFIGURE CHANNEL 1 DEVICE TYPE DISK  MAXPIECESIZE=3G FORMAT "D:\oracle\recovery_area\plmt\backupset\plmt_%U";
-</code>
-This is the first step of a RMAN backup script
-OS:Unix
-DB:10g
-<code plsql>
-crosscheck backup;
-sql "create pfile=''/opt/oracle/recovery_area/dev/pfile/myAktpFile'' from spfile;"
-backup AS compressed backupset incremental level 0 tag "FULL_WEEK_BACKUP" DATABASE;
-backup archivelog ALL DELETE ALL input;
-backup current controlfile;
-backup spfile;
-DELETE noprompt obsolete;
-</code>
-Start the backup Example Script
-OS:Windows
-DB:8i-10g
-<code winbatch>
-REM SETTINGS
-set ORACLE_HOME=D:\oracle\product\9.2.0
-set ORACLE_SID=PLMT
-set wochentag=%DATE:~0,2%
-set tag=%DATE:~3,2%
-set NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15
-REM CALL RMAN
-D:\oracle\product\9.2.0\bin\rman target / nocatalog @full_week.rman > backup_%tag%.log
-REM Export Schema MYUSER
-D:\oracle\product\9.2.0\bin\exp myUser/myUser@oramydb file="D:\oracle\recovery_area\plmt\export\myUser_%tag%.dmp"  >> backup_%tag%.log 2>&1
-REM Save Password File
-copy /Y D:\oracle\product\9.2.0\database\MYDBplmt.ora D:\oracle\recovery_area\plmt\password_file\MYDBplmt.ora >> backup_%tag%.log
-</code>
-UNIX
-<code sh>
 #!/bin/sh
 # Enviroment
 DAY_OF_WEEK="`date +%w`"
 export DAY_OF_WEEK
 DAY="`date +%d`"
 export DAY
@@ Zeile 84: / Zeile 47: @@
 </code>
+<code sh runRMAN.sh>
 #!/bin/sh
 # Parameter
@@ Zeile 89: / Zeile 54: @@
 export ORACLE_HOME
 ORACLE_SID=$2
-export ORACLE_HOME
+export ORACLE_SID
 ORACLE_DBNAME=$3
 export ORACLE_DBNAME
@@ Zeile 144: / Zeile 109: @@
 #Save Password File
 cp ${ORACLE_HOME}/dbs/orapw${ORACLE_SID} ${BACKUP_DEST}/${ORACLE_DBNAME}/orapw${ORACLE_SID}_${DAY_OF_WEEK}
 </code>
-<code plsql>
+<code plsql backup.rman>
+# Set Config
+CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
+CONFIGURE CONTROLFILE AUTOBACKUP ON;
+CONFIGURE MAXSETSIZE TO 10G;
+CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
-CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
-CONFIGURE CONTROLFILE AUTOBACKUP ON;
 SHOW ALL;
+# test old backup
 crosscheck backup;
-DELETE noprompt EXPIRED backup;
+delete noprompt EXPIRED backup;
+crosscheck archivelog all;
-DELETE noprompt force obsolete;
+DELETE noprompt EXPIRED archivelog all;
-backup incremental level 0 tag "full_backup" DATABASE;
+#Backup DB
+SQL "alter system checkpoint";
-sql "alter system archive log current";
+backup incremental LEVEL 0 tag "full_backup" DATABASE;
+#Backup archivelogs
+SQL "alter system archive log current";
 backup archivelog ALL tag "archive_backup" DELETE input;
+#Backup controlfile and spfile
 backup current controlfile tag "controlfile_backup";
 backup spfile tag "spfile_backup";
-DELETE noprompt obsolete;
+#Delete old Backups
+delete noprompt obsolete;
-list backup summary;
+#Summary info
+list backup summary;
+</code>
+<code plsql info.sql>
+spool ${BACKUP_DEST}/${ORACLE_DBNAME}/dbinfo_${ORACLE_SID}_${DAY_OF_WEEK}.log
+set pagesize 200
+column name format a60
+column parameter format a40
+column value format a30
+column property_value format a30
+column property_name format a30
+column tablespace_name format a20
+column FLASHBACK_ON format a40
+column LOG_MODE format a20
+---------------- version --------------------
+ttitle  "#########################version#########################"  skip 2
+select * from v$version;
+select * from v$option;
+select
+---------------- patchlevel --------------------
+ttitle  "#########################patchlevel#########################"  skip 2
+select * from sys.registry$history;
+---------------- properties --------------------
+ttitle  "#########################properties#########################"  skip 2
+select property_name,property_value from database_properties;
+---------------- charset -------------------
+ttitle  "#########################charset#########################"  skip 2
+select * from nls_database_parameters;
+-------------- dbid ------------------------
+ttitle  "#########################dbid#########################"  skip 2
+select name,dbid from v$database;
+-------------- datastructur ---------------
+ttitle  "#########################datastructur#########################"  skip 2
+select name as datafile_name from v$datafile;
+select name as tempfile_name from v$tempfile;
+select member as logfile_name from v$logfile;
+select tablespace_name,block_size from dba_tablespaces order by tablespace_name;
+------ archive -----------------------------
+ttitle  "#########################archive and flashback#########################"  skip 2
+archive log list
+select FLASHBACK_ON,LOG_MODE from v$database;
+spool off
+exit;
 </code>