Operating System - HP-UX
1748228 Members
4377 Online
108759 Solutions
New Discussion юеВ

Re: Oracle backup and restore

 
SOLVED
Go to solution
Michael Schulte zur Sur
Honored Contributor

Re: Oracle backup and restore

Hi again

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
Indira Aramandla
Honored Contributor

Re: Oracle backup and restore

Hi,

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
Never give up, Keep Trying
V.Tamilvanan
Honored Contributor

Re: Oracle backup and restore

Hi,

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 <run {
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;
Chris Evans_5
Frequent Advisor

Re: Oracle backup and restore

I agree with Michael if you can get the license for oracle/omniback integration then rman is the best way to go forward, but if you can't then you are going to have to carry on with your manual scripts.
Yogeeraj_1
Honored Contributor

Re: Oracle backup and restore

hi,

With tools like RMAN to do backups -- raw vs cooked doesn't come into play!

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Oracle backup and restore

hi again,

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Michael Schulte zur Sur
Honored Contributor

Re: Oracle backup and restore

Hi again,

can you post:
select name from v$datafile;

thanks,

Michael
Alexander M. Ermes
Honored Contributor

Re: Oracle backup and restore

Hi there.
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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
T G Manikandan
Honored Contributor

Re: Oracle backup and restore

RMAN is the best way for Oracle backup's and restoration,

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.
*/