TEST
Powered by Blogger.
Responsive Ad
Responsive Ad

Author Profile

About Me

Start Sharing

Start Sharing

Drive Traffic on Social Platforms

Blog Archive

Blog Journey

Blog Journey

Learn how to start a perfect Blog

Work Smart, Not Hard - Let's See

Make your Blogging experience faster and easiest …
Work Smart, Not Hard - Let's See
Design by - Blogger Templates | Distributed by Free Blogger Templates

Made with Love by

Material UI Template is Designed Theme for Giving Enhanced look Various Features are available Whic…

Random Posts

Ads Section

HOME > > RMAN Backup Scripts for Non-Rac Database

RMAN Backup Scripts for Non-Rac Database

Anup - Monday, 23 April 2012
Note: 
1. Script will take only disk based backup
2. It will not backup archive log files

################RMAN Backup Scripts for Non-Rac Database####################

run
{
allocate channel d1 type disk MAXPIECESIZE 5G;
allocate channel d2 type disk MAXPIECESIZE 5G;
backup
full
tag full_db
format '/home/oravis/rman_backup/datafile/db_%t_%s_p%p'
(database);
release channel d1;
release channel d2;
BACKUP CURRENT CONTROLFILE FORMAT '/home/oravis/rman_backup/controlfile/CTL%s_%t_%p';
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
################END of the Backup####################

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me