- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- how can I backup database into tape device in Orac...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 10:52 PM
тАО07-30-2001 10:52 PM
And how to backup database into tape device?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 11:16 PM
тАО07-30-2001 11:16 PM
Re: how can I backup database into tape device in Oracle
You can try a cpio backup of all necessary files.
I attached a sample.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 11:17 PM
тАО07-30-2001 11:17 PM
SolutionYou can try a cpio backup of all necessary files.
I attached a sample.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 11:23 PM
тАО07-30-2001 11:23 PM
Re: how can I backup database into tape device in Oracle
To backup a database you'll use Oracles Recovery Manager (RMAN).
RMAN can be set up backup to disk or tape. The version of RMAN that comes with Oracle software can only backup to lokal tapedrives.
If you need backup to remote tapedrives such as Legato backup servers with tape libraries, you'll need third party sw to create a channel between RMAN and the tape system.
Here is an exsample RMAN script:
run {
allocate channel c1 type disk
format '/backup/df_%d_%s_%p';
backup (database);
release channel c1;
allocate channel c1 type disk
format '/backup/al_%d_%s_%p';
sql "alter system archive log current";
backup (archivelog all delete input);
release channel c1;
}
For backup to tape, you substitute the allocate channel line with:
allocate channel t1 type ?sbt_tape?
parms ?ENV=(NSR_SERVER=t4t-bo-22-003,
NSR_DATA_VOLUME_POOL=test)?;
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 11:34 PM
тАО07-30-2001 11:34 PM
Re: how can I backup database into tape device in Oracle
The allocate channel line sample in my last responce is one used with Legato Networker Module for Oracle.
Remember that if you'll use cpio or other operation system means of backup you'll have to either shut down the database prior to backup or setting each tablespace in backup mode (generates lots of log activity), to get an working backup or else your backup will be worth nil.
With RMAN you can create an online backup without perfomance reduction.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2001 11:55 PM
тАО07-30-2001 11:55 PM
Re: how can I backup database into tape device in Oracle
Now I know I can use RMAN or cpio to backup.
I will try later.
Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2001 12:07 AM
тАО07-31-2001 12:07 AM
Re: how can I backup database into tape device in Oracle
you may consider cold and hot backups :
1. Cold backups :
- Shutdown the oracle db :
svrmgrl
connect internal
shutdown immediate
exit
- You may use one of these commands :
tar -cvf /dev/rmt/#m /OracleDBdirectory /archiveFiles /controlFiles /OnlineRedoLogFiles
fbackup ...
cpio ...
dd ...
2. Hot backup using Recovery MANager (RMAN):
see details in Andreas RMAN example.
Magdi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2001 12:12 AM
тАО07-31-2001 12:12 AM
Re: how can I backup database into tape device in Oracle
following pitfalls !
1) Keep in mind, that if you use the cpio-script, you need to shut down the database before you backup. Otherwise your backup will be inconsistent. To backup the database ONLINE, you need to set all tablespaces in Backup mode before. Like here:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x6eb053921f1ad5118fef0090279cd0f9,00.html
AND
backup the corresponding archivelogs afterwards !
2) RMAN requires Oracle Enterprise Edition License :-(
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2001 03:24 PM
тАО07-31-2001 03:24 PM
Re: how can I backup database into tape device in Oracle
archive log mode. You generally want this turned on
anyway. Otherwise you can only recover to the
state of your last cold backup. You also want to
force a logfile switch shortly after the backup completes.
The attached script copies an on-line database to
disk. It record a point in time that can be recovered
with the database and archived redo logs created
prior to the script completing. This was used to
build a copy to the database on a daily basis.
You could also look at the script at backupcentral.com.