Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
COLD BACKUP PROCEDURE PLS.
- Thread starter oracle8
- Start date
Basically just copy all the essential Oracle files to a safe location.
The essential files are the control file, database files, redo log files and the contents of the archive log directory (if you have archiving turned on).
The archive log directory is one of your initialization parameters. To determine the actual file names of the other files do the following queries.
select name from v$controlfile;
select member from v$logfile;
select name from v$datafile;
You should probably also make a copy of your init.ora file.
The essential files are the control file, database files, redo log files and the contents of the archive log directory (if you have archiving turned on).
The archive log directory is one of your initialization parameters. To determine the actual file names of the other files do the following queries.
select name from v$controlfile;
select member from v$logfile;
select name from v$datafile;
You should probably also make a copy of your init.ora file.
listener22
Programmer
Be sure to shut down the database first... Jim
oracle, vb
oracle, vb
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question