• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

Hotbackup

I need to take hotbackup of oracle 10g on windows tape backup that is tivoli
0
hussainkhan22
Asked:
hussainkhan22
  • 4
  • 2
  • 2
  • +1
1 Solution
 
raju1105Commented:
Hi,

Do you need RMAN backup script or the procedures.

If you have enough space on server first take backup on server then you can configure a tape backup policy. Otherwise you need to configure tape backup policy, integrate to RMAN script to take backup.
0
 
schwertnerCommented:
possible only for data base running in Archive Log mode:

The following pseudo code(!) demonstrates how a hot backup is taken on Oracle.
for ts in tablespaces
  alter tablespace $ts begin backup
  for df in datafiles of $ts
    cp $df $SAVE/$df
    alter database datafile '$df' end backup
  end
  alter tablespace end backup
end
alter system switch logfile
alter database backup controlfile to trace


http://www.adp-gmbh.ch/ora/admin/backup_recovery/hot_backup.html
0
 
hussainkhan22Author Commented:
I want backup to be saved directly on tape only
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
raju1105Commented:
Hi,

You can do something like below.

Afer createing policy in tivoli, you can schedule the job either in tivoli or in crontab.

RMAN configuration:
-----------------------------
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE DEVICE TYPE 'SBT_TAPE' BACKUP TYPE TO BACKUPSET PARALLELISM 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo_month.opt)';


backup sample script:
---------------------

run
{
allocate channel c1 type 'SBT_TAPE';
send 'NB_ORA_POLICY=ADDICTION_TRADEFIN_RMAN,NB_ORA_SERV=robinho';
backup database format 'backup_of_%d_%s_%D_%M_%Y' plus archivelog format 'archive_of_%d_%s_%D_%M_%Y';
}

You can read RMAN documentation for more detailed configuration to suit your environment and consult Tivoli or unix administration in configuring the policy for you.
0
 
hussainkhan22Author Commented:
What do you mean by creating policy. How can i create a policy in tivoli and schedule the job in tivoli please tell me in detail as i dont have any knowledge about tivoli
0
 
Mark GeerlingsDatabase AdministratorCommented:
Is your Oracle10 database in archivelog mode?  If not, you cannot take a hot backup.

I think you have three options for how to schedule/control the backup:
1. Use Oracle's RMAN utility
2. Use a batch file and a *.SQL script, then schedule the batch file via the WIndows Task Manager
3. Use Tivoli (I have no experience with Tivoli, so I'm only guessing that it has the ability to do Oracle backups on Windows).

Which of thes options do you want to use?
0
 
hussainkhan22Author Commented:
I need how to do tivoli backup for oracle database on tape
0
 
Mark GeerlingsDatabase AdministratorCommented:
Can you at least answer the question: is your database in archivelog mode?

Sorry, I have no Tivoli experience, so I can't help you with that.  But, if your database is not in archivelog mode, you will *NOT* be able to do hot backups, regardless of whether you use Tivoli, RMAN, manual scripts, etc.
0
 
hussainkhan22Author Commented:
Yes it's in archive log mode. Oracle 10g database on windows
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now