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: 4265 Rating: 2.25 Votes: 4) Rate It
HOT and COLD backup
- Script to perform both HOT and COLD backup
(Added: 25-Sep-2003 Hits: 5214 Rating: 9.01 Votes: 8) 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: 7894 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: 5196 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: 5309 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: 4258 Rating: 6.00 Votes: 1) Rate It
