| Recovery Issue. [message #59046] |
Sat, 25 October 2003 02:37  |
Imran
Messages: 56
Registered: November 2001
|
Member |
|
|
|
Could you explain the application restoration procedures and method of ensuring the application is available in the event of a disaster.
|
|
|
|
| Re: Recovery Issue. [message #59050 is a reply to message #59046] |
Sat, 25 October 2003 16:47  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
|
Application restore/recovery is specific to each app and there are tons and tons of it. Are you talking about database recovery ?
|
|
|
|
| Re: Recovery Issue. [message #59054 is a reply to message #59046] |
Sun, 26 October 2003 03:51 |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
Imran,
There are lots of issues here, and things you must be
clear about :_
1. Recover on the current system
or
recover on a new system
ie Disaster Recovery
2. Are you backing up to tape ?
3. What are you backing up ?
This depends a little on the answer to 1.
Generally you should back up :-
- A copy of the tablespace files (created by hot or
cold backups).
- A copy of your archive log files (since the last
backup or if paranoid [[you should be ]], from the
backup before that).
- Oracle 8 on - do not back up the TEMP tablespace
files, but ensure you know how to create it again
(full sql)
- ensure that you have done a 'backup control file'
and a 'backup control file to trace' and have both of
these saved.
- your init.ora (and for 9i, spfile)
- and ensure the scripts for creating the directory
structre are safe.
AND THEN TEST IT ! - regularly.
The procedures for recovery will vary depending on
Hot or Cold backups being the source.
Once you have that, then look to the application code
both executables and source - which should be in a
version control package.
Include with this, all the scripts you use to manage
the database.
cheers
pwl
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
