×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

RMAN Backup Query

RMAN Backup Query

RMAN Backup Query

(OP)
Hi Guys

New user to Oracle here, I have an application that uses an Oracle (11g) database on a Windows Server 2012, I need to be able to backup the database whilst it is online the application is critical and cant be taken down to backup the database.

How do I specify where my backups are wrote to ?

How do I backup the database whilst online I have been reading and Backup archivelog seems the way but can anyone tell me how ?

RE: RMAN Backup Query

Read up on RMAN. It's oracles backup manager and can do a hot backup if the database is in archivelog mode.

Bill
Lead Application Developer
New York State, USA

RE: RMAN Backup Query

(OP)
Do you have the commands to achieve this ?

RE: RMAN Backup Query

1) Configure rman (just once):

CODE

CONFIGURE DEFAULT DEVICE TYPE TO DISK; 
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'Y:\orabackup\ORCL\%d_%U'; #<= location of backups
#  Other configuration statements . . . 
2) Code backup scripts:

CODE

# rman_full_bkp -- Full backup (base for incrementals)
RUN
{
  BACKUP AS COMPRESSED BACKUPSET
    INCREMENTAL LEVEL 0
    DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG DELETE INPUT
  ;
} 

CODE

# rman_incr_bkp -- Incremental backup
RUN
{
  BACKUP AS COMPRESSED BACKUPSET
    INCREMENTAL LEVEL 1
    DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG DELETE INPUT
  ;
} 

CODE

# rman_arch_bkp -- Archive logs backup
RUN {
  BACKUP AS COMPRESSED BACKUPSET
  ARCHIVELOG ALL DELETE INPUT
  ;
} 

CODE

# Execute backup script
#!/bin/ksh
ORAENV_ASK=NO
. /usr/local/bin/oraenv 'ORCL'

rman target / {catalog rman/rman4bkup@rcat} @C:\oracle/scripts\rman_full_bkp.rmn LOG=C:\oracle\logs\full_bkp.log 
Good luck!


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: RMAN Backup Query

As posted above:

Quote (Beilstwh)

Read up on RMAN. It's oracles backup manager and can do a hot backup if the database is in archivelog mode.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close