Scripts to perform Oracle Backup and Recovery using Oracle Recovery Manager
Scripts
In this Category :
Export Backup with systemdate on Windowes
- If you want to add a date to an output file name, this tip shows you how to name .dmp files with the date in the name. It works in Windows NT.
(Added: 19-Aug-2002 Hits: 3517 Rating: 2.25 Votes: 4) Rate It
HOT and COLD backup
- Script to perform both HOT and COLD backup
(Added: 25-Sep-2003 Hits: 4365 Rating: 9.72 Votes: 7) Rate It
Hot Backup for NT - written in SQL*PLUS
- This script both generates and runs scripts to do an online NT backup, as well as take copies of any archive logs generated while the backup was in progress. The script(s) code can be found in the appendix A of this article and copied to a text editor for modification. To get an MSWord version of this script e-mail me and I'll send you one.
This is one of my first scripts as a DBA so feel free to point out any mistakes / suggestions / feedback etc.
(Added: 3-Aug-2000 Hits: 7129 Rating: 3.83 Votes: 6) Rate It
RMAN archivelog
- This script will take backup of archive logs based on the sequence nos mentioned in the script.
(Added: 14-May-2000 Hits: 4447 Rating: 7.00 Votes: 1) Rate It
script for backup of procedure and function
- run this script u can change the path which is given in the script after run that script u will get all stored procedure and function in a txt file and after that just execute that file on sql promt like @C:\
(Added: 25-Sep-2000 Hits: 4578 Rating: 5.75 Votes: 4) Rate It
Temporary Tablespace datafile crash
- Since temporary tablespace does not contain any objects. So, we can use in the following code.
(Added: 23-Feb-2001 Hits: 3543 Rating: 6.00 Votes: 1) Rate It
