Oracle Recovery Manager (RMAN) is the preferred method to backup database and it is included with Oracle software. Using RMAN you can backup the database to local/shared disk without any other agents. If you need to backup to tape then you need Media management library.
Please refer below link for configuring RMAN to backup database to a media manager.
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfb.htm#i1006526
The restore and recovery of the database is very easy using RMAN, it will figure it out where the backups are stored and which data files need to be restored and recovered.
Oracle 11g introduced many exciting new features in Recovery Manager (RMAN). Lets start using these new features and benefit from it.
• RMAN Proactive health checks :- Now you can proactively check database block corruptions using VALIDATE DATABASE
RMAN > VALIDATE DATABASE;
You can also run the proactive check on a datafile, tablespace or block.
RMAN > VALIDATE DATAFILE 1 BLOCK 10;
RMAN > VALIDATE TABLESAPCE users;
• Database Recovery Advisor : – The data recovery advisor automatically diagnoses the corruptions and loss of data on disk and determines the corrective repair options.
The LIST FAILURE command displays any failures with priority of CRITICAL or HIGH in order of importance
RMAN> LIST FAILURE
The ADVISE FAILURE command provides repair advice for failures listed by LIST FAILURE
RMAN > ADVICE FAILURE
The REPAIR FAILURE command applies the repair scripts advised by the ADVISE FAILURE command.
RMAN>REPAIR FAILURE
You can also use PREVIEW command to see the contents of the repair before proceeding to actual repair
RMAN>REPAIR FAILURE PREVIEW
• Faster Backup Compression: The ZLIB compression is faster than original B2ZIP compression with less CPU resources
Use below command for ZLIB compression
RMAN> configure compression algorithm 'ZLIB' ;
Use below command to change compression to BZIP2
RMAN> configure compression algorithm 'bzip2';
• More backup Comcodession Choices (11gR2 only): Now we have different types of comcodession levels, i.e. LOW, MEDIUM and HIGHT and with CPU resource usage from least to highest.
Here is the example
RMAN> configure comcodession algorithm ‘medium’;
• RMAN Backups to Cloud: Now you can set your RMAN backup destination to Cloud. Amazon provides cloud computing service, but you need to use specially developed media management library.
• RMAN UNDO bypass: The RMAN backup command no longer backs up the UNDO data that is not needed for recovery. Prior to Oracle 11g, all UNDO transactions that were already committed also backed up. This backup undo optimization minimizes the backup time and storage.
• Duplicate Database from Backup (11gR2 only): Prior 11g, In order to duplicate a database using DUPLICATE TARGET DATABASE command you need connect to target database. In case if target database is down you cannot able to duplicate. From 11g, you can able to duplicate the database without connecting to target database, make sure that you have backups available on duplicate site.
Here is the example for duplicate database
connect auxiliary sys/xxxx@dup
connect catalog rman/xxx@rmancat
duplicate database 'PRD' to DUP' until time "to_date('01/01/11 10:00:00','mm/dd/yy hh24:mi:ss')"
db_file_name_convert =( “/dbs1/oradata/PRD","/dbs2/oradata/DUP")
backup location '/rman_backup' ;
Duplicate Database options
-NOREDO – Using this option no archivelogs will be applied
-UNDO_TABLESPACE – You must specify the UNDO tablesapce when you are not connected to target database.
• Set NEWNAME Flexibility while restoring Database (11gR2 only): When you are restoring database on different server with different file system structure you need to change data file path using “SET NEWNAME” command. If you have hundreds of datafiles then you need to change the path for all data files.
run
{
set newname for datafile 1 to ‘/dbs1/oradata/system01.dbf’;
set newname for datafile 2 to ‘/dbs2/oradata/users01.dbf’;
---- (Some detail removed for brevity) ----
restore database;
}
From 11g, you have flexibility using a single “SET NEWNAME” clause for all datafiles in a tablespace.
run
{
set newname for tablespace DATA to '/dbs1/oradata/data%b.dbf';
set newname for tablespace INDEX to '/dbs2/oradata/index%b.dbf';
---- (Some detail removed for brevity) ----
Restore database;
}
You can also set the path for entire database using a single command.
run
{
set newname for database to '/dbs1/oradata/%b';
restore database;
}
• TO DESTINATION Clause in BACKUP command (11gR2 only): You can specify a destination location for RMAN backups using “TO DESTINATION” clause .
RMAN> backup tablespace users to destination '/backup/rman;
You can also use this clause in ALLOCATE CHANNEL command
RMAN> run {
2> allocate channel c1 type disk to destination '/backup/rman';
backup database;
3> }
• Parallel backup of Same datafile: Now you can break the large datafiles into small sections and it reduces the backup time of large datafiles
Here is the example
run {
allocate channel c1 type disk format '/rman_backup1/%U';
allocate channel c2 type disk format '/rman_backup2/%U';
backup section size 100m
datafile 10;
}
• Automatic Block Repair (11g R2 Only): This feature automatically repairs the blocks on primary from blocks on Physical Standby. RECOVER BLOCK enhanced to repair the blocks on Primary as soon as it detects the corruption from standby when available.
• Transported Tablespace Enhancement: Prior 11g, the transported tablespace must be in read-only mode. But from 11g onwards you can transport the tablespace both in read-only and read-write mode.
• Virtual Private Catalog: The virtual catalogs are created within in same RMAN Catalog. Prior to 11g, we have only one catalog and catalog owner can able to see repository information for all databases. From 11g, you can separate the catalog database access across the departments/groups (for ex, Manufacturing, IT…etc.) using virtual catalogs feature to maximize the security.
Create a separate user for IT department to grant catalog access
SQL> create user it_user identified by xxxxx quota unlimited on users;
SQL> grant recovery_catalog_owner to it_user;
Grant catalog access on “itdb1” to virtual catalog owner “it_user”
$ rman target=/ rcvcat rman/rman@rmancat
RMAN> grant catalog for database itdb1 to it_user;
Now connect using the virtual catalog owner “it_user” and create virtual catalog
$ rman target=/ rcvcat ituser/xxxx@rmancat
RMAN> create virtual catalog;
• Merging RMAN Catalogs: If you have operations across different regions and maintaining different catalogs for each state and want to merge then you can use merge catalog feature without re-registering the databases in new catalog.
In below example we are importing rmancat2 into rmancat1
$ rman target=/ rcvcat rman/rman@rmancat1
RMAN> import catalog rman/rman@rmancat2;
• GUI interface for RMAN: Now you can use RMAN functionality through a GUI iFrom Enterprise manager
•Archive log Deletion Policy Enhancements: The archive log deletion policy has been extended in 11g for greater flexibility and protection for Dataguard environments.
Oracle 10g Syntax.
CONFIGURE ARCHIVELOG DELETION POLICY {CLEAR | TO {APPLIED ON STANDBY | NONE}}
Oracle 11g Syntax.
ARCHIVELOG DELETION POLICY {CLEAR | TO {APPLIED ON [ALL] STANDBY |BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier |NONE | SHIPPED TO [ALL] STANDBY}[ {APPLIED ON [ALL] STANDBY | BACKED UP integer TIMES TO DEVICE TYPE deviceSpecifier |NONE | SHIPPED TO [ALL] STANDBY}]...}
Regards
Satishbabu Gunukula
http://www.oracleracexpert.com
Subscribe to:
Post Comments (Atom)
Thanks a lot for posting this write-up. It gave me a good start with the RMAN new features. I am a big fan of this tool and just enjoy deployint it at any project I get where backups are still done the 'old way'.
ReplyDeleteSuch a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteDiscover our website bounty of free online games now!
Our website has the biggest collection of free online games. Totally new games are added every day!
age of war 2
gold Miner 2
unfair Mario 2
cubefield 2
tanki Online 2
Life after hours of work stress and fatigue is the space I really love. I can play games, take photos or simply surfing facebook, chatting with friends. It made me feel so comfortable and pleasan
ReplyDeletefacebook baixar , whatsapp baixar , square quick
I think what you say on here is the best thing. Looking forward for our lives become increasingly more beautiful
ReplyDeletebaixar facebook gratis , baixar whatsapp gratis , return man , subway surfers game , download hola launcher , pokemon go game , minecraft
Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteDiscover our website bounty of free online games now!
Our website has the biggest collection of free online games. Totally new games are added every day!
age of war 2
gold Miner 2
unfair Mario 2
cubefield 2
tanki Online 2
Great information I will tweet to my friends to get them to check it out. keep it up. Thanks for sharing!.If have a long time than visit to:
ReplyDeletecrosswords puzzles | dream league soccer apk | cookie clicker | dream league soccer apk | crossword puzzles | cookie clicker
You need to have time to take care of the active. It in fact was a amusement account it. Look advanced to far added agreeable from you.
ReplyDeletebaixar banana kong , banana kong , download banana kong , banana kong download , banana kong
Life becomes more interesting and wonderful when you share your memorable moments with friends and family through unique photographs. You can create your own unique style impressed with image editing software. And after hours of work stress you can also
ReplyDeletetank trouble, tank trouble 2, tank trouble games, tank trouble
Life becomes more interesting and wonderful when you share your memorable moments with friends and family through unique photographs. You can create your own unique style impressed with image editing software. And after hours of work stress you can also
ReplyDeletedr driving, dr driving baixar ,download dr driving, dr driving
Mostly people have all the same things when they are writing academic task or any other writing, especially light music most people like during the writing.
ReplyDeletedream league soccer download , dream league soccer apk , download dream league soccer , dream league soccer
Thanks I have read your article, it is very interesting and exciting
ReplyDeletedownload go launcher, go launcher apk, go launcher , go launcher androi,
Thank You Posting. Very Nice Admins.
ReplyDeleteGabile
Gabile Sohbet
Gabile Chat
Cinsel Sohbet
Sohbet
mirc indir
mirc sohbet
Gay Sohbet
Gabile
Gabile Sohbet
Gabile Chat
Cinsel Sohbet
Sohbet
gabile sohbet
gabile
gabile chat
gay sohbet
Your blog posts are more interesting and impressive. I think there are many people like and visit it regularly, including me.I actually appreciate your own position and I will be sure to come back here.
ReplyDeletehotmail login l login hotmai l hotmail log in l hotmail sign in l hotmail sign up
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete
ReplyDeleteEn eğlenceli sohbet odaalrını sizlere tanıtıyoruz. Bilinen chat odaları kültüründen çok uzakta anlık binlerce kullanıcısı ile zirvedeki chat sitesi.
cinsel sohbet
gabile sohbet
lezbiyen sohbet
gabile sohbet
gay sohbet
geveze sohbet
geveze chat
geveze
mynet sohbet
mynet chat
bizimmekan
bizim mekan
bizimmekan sohbet
bizimmekan chat
lezbiyen sohbet
kelebek sohbet
sohbet odaları
• Thank you for your information that you've shared. It's really helpful for me. * Street view
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteشركة تنظيف خزانات بجدة الجوهرة من افضل شركات تنظيف الخزانات بجدة حيث ان تنظيف خزانات بجدة يحتاج الى مهارة فى كيفية غسيل وتنظيف الخزانات الكبيرة والصغيرة بجدة على ايدى متخصصين فى تنظيف الخزانات بجدة
ReplyDeleteشركة تنظيف خزانات بجدة
شركة كشف تسربات المياه بالدمام
شركة نقل عفش واثاث
I have read your article, the information you give is very interesting.
ReplyDeleteinstagram online
WhatsApp Plus apk
ReplyDeleteSuperb article and valuable information because it’s really helpful for me, Thank you so much for share this wonderful information with us.
ReplyDeleteJeans Manufacturers in Delhi
Such a very superb article, Very interesting to read this article, I would like to thank you for useful had made for writing this awesome article.
ReplyDeleteTop Commercial Vehicle Painters
Awesome article, Very interesting to read this article, I would like to thank you for useful had made for writing this superb article share with us.
ReplyDeleteWeb design company
Great article, Very interesting to read this article, I would like to thank you for writing this helpful article share with us.
ReplyDeleteMotorcycle Tour in Mumbai
Good article, Very interesting to read this article, I would like to thank you for writing this helpful article share with us.
ReplyDeleteLifestyle Magazine
Thank You! For sharing such a great article, It’s been a amazing article.
ReplyDeleteIt’s provide lot’s of information, I really enjoyed to read this.
Mobile app development company in toronto
we have provide the best ppc service.
ReplyDeleteppc company in gurgaon
website designing company in Gurgaon
PPC company in Noida
Rice Bags Manufacturers
ReplyDeletePouch Manufacturers
Nice and interesting post,I appreciate your hard work,keep uploading more, Thank you for sharing valuable information.
ReplyDeleteApp Development Company in Delhi
citizen calculator
ReplyDeleteMobile app development company in mumbai
ReplyDeleteBharat CSP Agents are those individuals who acts as an agent of the bank at places where it is not possible to open branch of the bank.
ReplyDeleteApply CSP
CSP registration
CSP provider
Top CSP Provider in India
Apply Online For Bank CSP
Online Money Transfer
A large number of people, particularly the migrant laborers and factory workers do not have a saving account and even not able to open an account due to lack of valid address and ID proof. As a result they face difficulties to save their earnings in a safe place and look out for solution to send money to their families.
ReplyDeleteCSP Apply
CSP Online Application
Apply for CSP
Top CSP Provider in India
Wow!!! It was really an Informational Article which provide me with much Insightful Information. I would like to first thank the author for such an Insightful Content. If someone here is looking for a Website Designing Company in India, then look no further than Jeewangarg.com as we are the Best website designing company in Delhi working in the arena for the last 8 years.
ReplyDeleteDigital Marketing company in Delhi
ReplyDeleteThanks for posting such a great post . Right Selects provides its users with the exact information of the “top 10” or “top 5” industry leader of the particular industry. For instance, if you are looking for selecting the best among the array of Water Purifires in india in India, you can visit us for getting the most accurate information about “Top 10 water purifier for home”. Additionally, at right selects, you can have the information on lifestyle products, electronics, appliances, water purifiers, restaurants as well as about the best travel places.
Thank You Author!!! You are sharing the very informative and great post. If anyone is looking to lehenga indian wedding dresses | lehenga online then visit Panache Haute Couture, a leading Indian Designer House for Indian Dresses.
ReplyDeleteGreat work done by author of this blog. Its an Amazing blogger. We are one of the best Mobile App Development in Delhi | Mobile App Development Company in India | Website Development Company in Delhi | Website Designing Company in Gurgaon.
ReplyDeleteWow!!! A great insightful & informative content on ACP Board. Virgo Group is the largest providers of best in class leading facade materials and more & having years of experience in manufacturing Premium ACP Sheet. We aim to deliver excellence and ensure maximum worth for our clients’ money and so we provide you with the best hpl sheet.
ReplyDeleteA large number of people, particularly the migrant laborers and factory workers do not have a saving account and even not able to open an account due to lack of valid address and ID proof. As a result they face difficulties to save their earnings in a safe place and look out for solution to send money to their families.
ReplyDeleteApply CSP
CSP Registration
CSP Provider
Bank CSP
CSP Kisok
Thanks for the great article and post. Need a Industrial UPS? Don’t go beyond nexusups. 10 kva ups which offers an extensive range of exceptional Industrial UPS, and Online UPS Free to contact.
ReplyDeleteThanks for the great article and post. Need a servo voltage stabilizer manufacturers in india? Don’t go beyond servo star “A popular 10 kva voltage stabilizer price which offers an extensive range of exceptional servo stabilizer. Feel Free to contact.
ReplyDeleteI would like to thank you for the efforts you have made in writing this post. Thanks for posting Really Such Things. I should recommend your site to my friends. If you are interested for CRM Software visit here:- CRM Software in Mumbai
ReplyDeleteThank You author for providing such insightful information on elevators, if anyone out there is looking for Passenger lifts then, visit right selects where you’ll get the most accurate information on the top 10 elevator companies in india that you can use to choose the best elevator company in India.
ReplyDeletemobile app development company in delhi
ReplyDeleteRipple Film specialises in Corporate Video Production. We also offer digital advertising services including Google and Facebook and generate real, tangible results. We help businesses rapidly grow using video production and digital advertising systems.
ReplyDeleteAivivu, chuyên vé máy bay, tham khảo:
ReplyDeleteVe may bay di My
lịch bay từ mỹ về việt nam hôm nay
vé máy bay từ frankfurt đi hà nội
khi nào có chuyến bay từ nga về việt nam
Tekniko Global is an award-winning mobile app development company in Delhi and other city or countries. We develop high-quality.
ReplyDeletecutting corrugated plastic not only have these wonderful qualities but also are super easy to cut. With the right kind of tools, you can quickly cut these sheets using the followingCorrugated Plastic sheets comprise of three layers- two flat plastic sheets with a wave-like ribbed center layer. The two flat plastic sheets are generally referred to as twinwall plastic. The Corrugated Plastic sheets may also be like sheets of plastic that have a wave-like structure that might have chopped glass fiber reinforced in it
ReplyDeleteAward-winning mobile app development agency. Our android application development company builds custom mobile apps for 7+years. Over 600+ clients served.
ReplyDeletemobile app development agency
Infographic Submission Helpforallseo Sites List.
ReplyDeleteApplying for Malaysia passport renewal ? Are you worried on document preparation ?IVC has successfully helped renewing 10,000+ Passports
ReplyDeletemalaysia passport renewal
Great article! This is the type of information that are meant to
ReplyDeletebe shared across the internet. Thank you for sharing such a useful post. Nice post ! I love its your site after reading ! thanks for sharing.
Website: gmat
I am very happy to have seen your website and hope you have so many entertaining times reading here. Thanks for all the details. Nice Post thanks for the information, good information & very helpful for others. you sharing such a useful post. Very Interesting Post! I regularly follow this kind of Blog.
ReplyDeleteWebsite: expert guessing forum
Raptorroof is one of the most reputable residential best roofing company in Frisco, Texas.Having provided our best roofing services for several years to the residents of Frisco and beyond, we’ve amassed an excellent reputation that puts us on top when it comes to roofing services in Texas.Our commitment to our customers extends to the products we use and the services we offer. We only use Owens Corning roofing shingles, a premium-quality option that ensures that every roof we work on is stable, sturdy and ultimately long-lasting.
ReplyDeletewindow screen fixes in Frisco Tx
Perched at an elevation of 1893 meters, The Whitestone Resorts Feel the Nature with Luxury in Manali.
ReplyDeleteBest Resort in Manali
www.escortsmate.com
ReplyDeleteescortsmate.com
https://www.escortsmate.com
Great article! This is the type of information that are meant to
ReplyDeletebe shared across the internet. Thank you for sharing such a useful post. Nice post ! I love its your site after reading ! thanks for sharing.
Water heater service in Nagpur
Great article! This is the type of information that are meant to
ReplyDeletebe shared across the internet. Thank you for sharing such a useful post. Nice post ! I love its your site after reading ! thanks for sharing.
denver graphic installers
We are the one of the certified and top-rated Riverside Chevrolet Dealership Peoria Il.
ReplyDeleteVisit here - Riverside Chevrolet Dealership
ReplyDeleteGreat article-really enjoyed! www.hairicc.com
Thanks for Sharing this Valuable Information with us: this is very useful for me. Keep it Up. Trending Blogs India 2021, Most Popular Blog Topics India 2021, Trending Topics in India 2021
ReplyDeleteVisit here - india china latest news today
Your Post nice, thanks for sharing . Perched at an elevation of 1893 meters, The Whitestone Resorts Feel the Nature with Luxury in Manali. It’s located in the state of Himachal Pradesh
ReplyDeleteVisit here Hotels in Manali 4 Star
Are you looking for office space, and wondering how much space do you exactly need to run your office? You can look at business centre for options.
ReplyDeleteVery nice post, I definitely love this website, keep up the good work.. Eligible citizens are able & apply Azerbaijan electronic visa online through the simple and straightforward Azerbaijan visum application form.
ReplyDeleteWe are a professional online custom make boxes company,offering different kinds of paper packaging boxes from long time and we are very glad to supply you the high quality boxes all the year round Wholesale Boxes With Logo
ReplyDeleteمن افضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية بعمل افضل شركة تنظيف خزانات بجده بكل تروي وترى افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما كما في شركات تنظيف خزانات بمكه التي تقوم بتنظيف وتعقيم الخزانات وفي مدينة الطائف تعمل شركة تنظيف خزانات بالطائف على جعل الخزان نظيفا اطول فترة زمنية ممكنة في شركات تنظيف خزانات بالمدينة المنورة ومحتملة وهذا كله لكي تكون مياهك نظيفة وقد تقوم شركات تنظيف الخزانات محترفة ومستعدة لاستقبال مكالمتكم في أي وقت وطلب الخدمة وافضل خدمات منزلية تقدمها افضل شركه تنظيف خزانات بالرياض باحترافية عالية غير مسبوقة بين شركات الخدمات المنزلية في الرياض
ReplyDeleteYour information is fantastic and very helpful. I have read it many times. You have included a lot of valuable information in this article and click here to apply for an urgent Indian e visa. Now it is much easier to apply for an e-visa to India.
ReplyDeleteI really like your site it’s very impressive. Thanks for the inspiration! I really appreciate people like you!
ReplyDeletewebsite: Leather kilt
Malik Furniture
ReplyDeleteSmall Chair For Bedroom
Tv Stand With Storage
Wooden Tv Stand
Side Tables for Living Room
Most Comfortable Sectional Sofa
Double Wardrobe with Drawers
Leather Living Room Sets
Sliding Mirror Wardrobe
ReplyDeleteYasir Electronics
Dc Inverter Ac in Pakistan
Slush Machine Price in Pakistan
Sugarcane Juice Machine Price in Pakistan
Chiller Price In Pakistan
samsung microwave oven price in pakistan
Hitachi Refrigerator Price in Pakistan
water dispenser price in pakistan
Furniture 4U
ReplyDeleteGaming Chair Price in Pakistan
Office Chair Price in Pakistan
Computer Table Price in Pakistan
Sofa Set Price in Pakistan
Office Table Price in Pakistan
Wardrobe Price in Pakistan
ReplyDeleteYamas Furniture
Office Furniture in Karachi
office chairs in Karachi
office table in Karachi
study table in Karachi
computer chair in Karachi
computer table in Karachi
Revolving Chair in Karachi
ReplyDeleteFumigation Services Karachi
Termite Treatment Services in Karachi
Water Tank Cleaning Services in Karachi
Fumigation Services in Karachi
fire fighting companies in pakistan
ReplyDeletefire hydrant system
fire extinguisher price in pakistan
fire fighting equipment
dcp fire extinguisher
fire alarm system in pakistan
afff fire extinguisher
ReplyDeleteIncredible Fitness Tips
15 Dynamic Exercises For Skating
10 long head bicep Exercises
15 Gym Exercises for Back Fat
14 Effective Exercises For Forearm
10 Effective Exercises for 6 Packs
How to Improve Push-Ups
How to Increase Height after 21
3 Minute Workouts
10 Balance Exercises for Parkinson’s Disease
ReplyDeletePakistan Fumigation Services
Disinfection Services in Karachi
Disinfection Services in Lahore
Pest Control Services in Karachi
Fumigation Service in Karachi
Termite Control in Lahore
Pest Control Services in Lahore
Water Tank Cleaning Services in Karachi
This comment has been removed by the author.
ReplyDeleteThis is great content for your readers. Thanks for sharing.
ReplyDeletetartan skirt
Vedant Computer is Nagpur's 1st Ecommerce website for Refurbished Laptops, Refurbished Desktops, Providing consumers with an almost new-like experience.
ReplyDeleteVisit Here::- refurbished desktop
2nd hand laptop
Founded in 2018, Adventure Mania is one of the most trusted travel partner in India. It has around 4.8 rating on google (as of June 2022). We cater to all type of travel enthusiast across the globe.
ReplyDeleteVisit here andaman tour packages
Very interesting article, thank you for sharing with us. plz click here :- malaysia visa
ReplyDeleteWe as an Adventure Travel company aim to show you nice people the most beautiful
ReplyDeletevisit here - tadiandamol trekking