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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to backup database intance
- Thread starter tomecki24
- Start date
Tomas,
There's an excellent book that comes with the Oracle documentation all about backing up and restoring an Oracle database - have a look at that.
In the meantime:
There are three basic approaches to this:
1 - Cold Backup.
Turn the database off and backup all of its files to a tape drive - make sure you turn it off first (the shutdown command in svrmgrl) Easiest, safest.
2 - Warm Backup.
This uses the exp command which exports data from the database to a file or tape device. If your database is not busy you can use the consistent=yes option to safle backup a running database. Easy, safe.
3 - Hot Backup.
For this the database has to be running in Archive Log mode. Updates to the database are also archived into a set of files. These files are archived onto tape and used to restore your system if it's needed. Read the book, test it a lot (on a test database that you're also backing up using 1 or 2). Hard, safe. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
There's an excellent book that comes with the Oracle documentation all about backing up and restoring an Oracle database - have a look at that.
In the meantime:
There are three basic approaches to this:
1 - Cold Backup.
Turn the database off and backup all of its files to a tape drive - make sure you turn it off first (the shutdown command in svrmgrl) Easiest, safest.
2 - Warm Backup.
This uses the exp command which exports data from the database to a file or tape device. If your database is not busy you can use the consistent=yes option to safle backup a running database. Easy, safe.
3 - Hot Backup.
For this the database has to be running in Archive Log mode. Updates to the database are also archived into a set of files. These files are archived onto tape and used to restore your system if it's needed. Read the book, test it a lot (on a test database that you're also backing up using 1 or 2). Hard, safe. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.
pavithra123
IS-IT--Management
Mike has given u enough info.
Maybe this also helps V$database has the Archive log mode DB must be in ARCHIVE log mode otherwise hotbackup has no meaning.
backup all the dbf and control files to the tape.
Another way of backing the data is through EXPORT commands ( try to pick the ones u want like export constraints whole db etc etc ) so this dump file can be imported and
restored.
Prem
Maybe this also helps V$database has the Archive log mode DB must be in ARCHIVE log mode otherwise hotbackup has no meaning.
backup all the dbf and control files to the tape.
Another way of backing the data is through EXPORT commands ( try to pick the ones u want like export constraints whole db etc etc ) so this dump file can be imported and
restored.
Prem
- Status
Similar threads
- Locked
- Question