Restore archivelogs

How the Oracle DBA can restore archivelogs from tape with an Oracle RMAN Script: DBA Oracle Compatibility: Oracle 8i 9i 10g 11g Creator: Vincent Fenoll – Montreal run { allocate channel t1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=xxxxxx)’; restore archivelog from logseq 2212 until logseq 2213 thread 1; release channel t1; }

Duplicate db using RMAN script

################################################ # # Compatible: Oracle 8i 9i 10g 11g # ################################################ # # Duplicate a database until time… # Database must be in « startup nomount » mode # ################################################ connect catalog rman/****@rman connect target sys/****@****.world connect auxiliary / ; run { set until time= “to_date(’25/08/2009 06:18:01′,’dd/mm/yyyy hh24:mi:ss’)”; # if restoring from tape (else Allocate […]

Restore until time rman script

If flashback Database is not available (Flashback off or timeframe too large), you will have to restore your Oracle database with Recovery Manager (RMAN). ################################################ # # Compatible: Oracle 8i 9i 10g 11g 12c # ################################################ # # Restore a database until time… # Database must be in “startup mount” mode # ################################################ . oraenv […]

Delete from catalogue

— ################################################ — # Creator: Vincent Fenoll, Arnaud Michel — # Compatible: Oracle 8i 9i 10g — # — ################################################ — # — # Delete an Oracle database from the RMAN catalogue — # — ################################################ In RMAN database: sqlplus rman/****@rman — PART I: Unregister One Database SQL> SELECT db_key, db_id FROM db WHERE db_id […]