- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle backup and restore
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
тАО12-16-2003 08:29 PM
тАО12-16-2003 08:29 PM
Re: Oracle backup and restore
rman (recovery manager and not backup manager) is the tool of choice of Oracle. It does not only simplify the backup, it also helps greatly if you have to recover the database full or incomplete.
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 08:33 PM
тАО12-16-2003 08:33 PM
Re: Oracle backup and restore
If you are restoring the Server from make_net_recovery, You will need to re-install the Oracle 8i Server RDBMS for HP-UX 11.0 software from the oracle software CD's. Or as you mentioned you backup the filesystem to disk and then use Omniback to backup to a tape, you can restore the filesystem that had the Oracle software from the tape.
Now after the software has been restored / installed successfully, you can restore your database.
You said that you do cold backup (shutdown the database and copy the datafiles to a disk). You can use Omniback to backup the datafile from this backup disk to tape. You will need additional license to backup Oracle provided you are integrating RMAN with OmniBack. If you cannot get the license now, you can just backup the datafiles, redo logs and the control files from the backup disk to the tape using Omniback. You can define the backup specification in Omniback to backup the datafiles, redologs and controlfiles. As chris suggested run the query and find out the datafile paths, to define the backup specification.
Then you can write a script and schedule in cron to execute the script.
The script will have the following.
1. set you environment variables
2. set your oracle SID
3. login to svrmgrl
4. connect internal
5. shutdown
6. then call /opt/omni/bin/omnib -datalist with the datalist and other parameters. And makesure the datalist is the backup specification that you defined to backup the datafiles, redologs and controlfiles.
Make sure the tape is marked for permanent.
Then restore the database from the backup tape and startup the database. Since the database backup was a cold backup, there is no need to recover to a point in time.
I hope this helps.
IA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 08:33 PM
тАО12-16-2003 08:33 PM
Re: Oracle backup and restore
This is the rman script we use to take Level 0 (Full Database Backup including the control file).
U can modify the script to take incremental backup also by changing the level 0 to 1 or 2.
. /u02/home/ora1/ora1_env
rman nocatalog target system/manager <
allocate channel d2 type disk;
backup incremental level 0 format '/u02/oracle/backup/rman/%d%s%p.ora1.rman'
filesperset 200 (database include current controlfile);
sql "alter system archive log current"; release channel d2;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 08:35 PM
тАО12-16-2003 08:35 PM
Re: Oracle backup and restore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 08:42 PM
тАО12-16-2003 08:42 PM
Re: Oracle backup and restore
With tools like RMAN to do backups -- raw vs cooked doesn't come into play!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 09:04 PM
тАО12-16-2003 09:04 PM
Re: Oracle backup and restore
we prefer to do our RMAN backup to DISK then backup the "RMAN backup files" to TAPE.
Well, you can choose this way if you have enough disk space available.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 10:19 PM
тАО12-16-2003 10:19 PM
Re: Oracle backup and restore
can you post:
select name from v$datafile;
thanks,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2003 11:59 PM
тАО12-16-2003 11:59 PM
Re: Oracle backup and restore
Just my 2 ct to this.
We use OmniBack for a long time now.
We use to do cold backups ( yes, we take the time to shutdown the database, do the backup and startup the database again ).
If you have the chance to do so, do it.
It makes your life easy. If your database then crashes, you can do a recover until time.
A few things you should do :
- backup your controlfile as sql script
separately to know, where all your files
are
- then create a backup specification under OmniBack inlcuding file systems and raw devices ( both possible )
- check, that you have scripts to shutdown and startup your database.
- do a test backup and verifying the data written to tape.
If you want to transfer your data to a different server, do an export of your old database ( full export ).
Setup your new software.
Create a new database and import the data from the old system.
Hope i could help.
Rgds
Alexander M. Ermes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-17-2003 12:45 AM
тАО12-17-2003 12:45 AM
Re: Oracle backup and restore
it can use third-party media management software in your case omniback.
It has many features like it can automate lot of procedures
/*
Use server sessions to back up and copy the database, tablespaces, datafiles, control files, and archived redo logs.
Compress backups of datafiles so that only those data blocks that have been written to are included in a backup.
Store frequently executed backup and recovery operations in scripts.
Perform incremental backups, which back up only those data blocks that have changed since a previous backup.
Use the recovery catalog to automate both restore and recovery operations.
Perform automatic parallelization of backup and restore operations.
Restore a backup using a backup control file and automatically adjust the control file to reflect the structure of the restored datafiles.
Find datafiles that require a backup based on user-specified limits on the amount of redo that must be applied for recovery.
Perform crosschecks to determine whether archived materials in the media management catalog are still available.
Test whether specified backups can be restored.
*/
- « Previous
-
- 1
- 2
- Next »