Tuesday, December 20, 2011

Oracle Recovery Manager(RMAN) New features in 11g

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

83 comments:

  1. 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'.

    ReplyDelete
  2. 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.

    Discover 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

    ReplyDelete
  3. 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

    facebook baixar , whatsapp baixar , square quick

    ReplyDelete
  4. I think what you say on here is the best thing. Looking forward for our lives become increasingly more beautiful
    baixar facebook gratis , baixar whatsapp gratis , return man , subway surfers game , download hola launcher , pokemon go game , minecraft

    ReplyDelete
  5. 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.

    Discover 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

    ReplyDelete
  6. 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:
    crosswords puzzles | dream league soccer apk | cookie clicker | dream league soccer apk | crossword puzzles | cookie clicker

    ReplyDelete
  7. 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.

    baixar banana kong , banana kong , download banana kong , banana kong download , banana kong

    ReplyDelete
  8. 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

    tank trouble, tank trouble 2, tank trouble games, tank trouble

    ReplyDelete
  9. 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
    dr driving, dr driving baixar ,download dr driving, dr driving

    ReplyDelete
  10. 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.
    dream league soccer download , dream league soccer apk , download dream league soccer , dream league soccer

    ReplyDelete
  11. Thanks I have read your article, it is very interesting and exciting
    download go launcher, go launcher apk, go launcher , go launcher androi,

    ReplyDelete
  12. 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.
    hotmail login l login hotmai l hotmail log in l hotmail sign in l hotmail sign up

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. • Thank you for your information that you've shared. It's really helpful for me. * Street view

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete
  17. شركة تنظيف خزانات بجدة الجوهرة من افضل شركات تنظيف الخزانات بجدة حيث ان تنظيف خزانات بجدة يحتاج الى مهارة فى كيفية غسيل وتنظيف الخزانات الكبيرة والصغيرة بجدة على ايدى متخصصين فى تنظيف الخزانات بجدة
    شركة تنظيف خزانات بجدة
    شركة كشف تسربات المياه بالدمام
    شركة نقل عفش واثاث

    ReplyDelete
  18. I have read your article, the information you give is very interesting.

    instagram online

    ReplyDelete
  19. Superb article and valuable information because it’s really helpful for me, Thank you so much for share this wonderful information with us.
    Jeans Manufacturers in Delhi

    ReplyDelete
  20. 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.
    Top Commercial Vehicle Painters

    ReplyDelete
  21. 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.
    Web design company

    ReplyDelete
  22. Great article, Very interesting to read this article, I would like to thank you for writing this helpful article share with us.
    Motorcycle Tour in Mumbai

    ReplyDelete
  23. Good article, Very interesting to read this article, I would like to thank you for writing this helpful article share with us.
    Lifestyle Magazine

    ReplyDelete
  24. Thank You! For sharing such a great article, It’s been a amazing article.
    It’s provide lot’s of information, I really enjoyed to read this.
    Mobile app development company in toronto

    ReplyDelete
  25. Nice and interesting post,I appreciate your hard work,keep uploading more, Thank you for sharing valuable information.
    App Development Company in Delhi

    ReplyDelete
  26. Bharat 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.

    Apply CSP
    CSP registration
    CSP provider
    Top CSP Provider in India
    Apply Online For Bank CSP
    Online Money Transfer

    ReplyDelete
  27. 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.

    CSP Apply
    CSP Online Application
    Apply for CSP
    Top CSP Provider in India

    ReplyDelete
  28. 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.
    Digital Marketing company in Delhi

    ReplyDelete

  29. Thanks 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.

    ReplyDelete
  30. 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.

    ReplyDelete
  31. Wow!!! 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.

    ReplyDelete
  32. 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.

    Apply CSP
    CSP Registration
    CSP Provider
    Bank CSP
    CSP Kisok

    ReplyDelete
  33. 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.

    ReplyDelete
  34. Thanks 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.

    ReplyDelete
  35. I 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

    ReplyDelete
  36. Thank 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.

    ReplyDelete
  37. Ripple 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.

    ReplyDelete
  38. Tekniko Global is an award-winning mobile app development company in Delhi and other city or countries. We develop high-quality.

    ReplyDelete
  39. cutting 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

    ReplyDelete
  40. Award-winning mobile app development agency. Our android application development company builds custom mobile apps for 7+years. Over 600+ clients served.
    mobile app development agency

    ReplyDelete
  41. Applying for Malaysia passport renewal ? Are you worried on document preparation ?IVC has successfully helped renewing 10,000+ Passports
    malaysia passport renewal

    ReplyDelete
  42. Great article! This is the type of information that are meant to
    be 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

    ReplyDelete
  43. 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.
    Website: expert guessing forum

    ReplyDelete
  44. 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.

    window screen fixes in Frisco Tx

    ReplyDelete
  45. Perched at an elevation of 1893 meters, The Whitestone Resorts Feel the Nature with Luxury in Manali.
    Best Resort in Manali

    ReplyDelete
  46. Great article! This is the type of information that are meant to
    be 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

    ReplyDelete
  47. Great article! This is the type of information that are meant to
    be 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

    ReplyDelete
  48. We are the one of the certified and top-rated Riverside Chevrolet Dealership Peoria Il.
    Visit here - Riverside Chevrolet Dealership

    ReplyDelete
  49. 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
    Visit here - india china latest news today

    ReplyDelete
  50. 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
    Visit here Hotels in Manali 4 Star

    ReplyDelete
  51. 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.

    ReplyDelete
  52. Very 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.

    ReplyDelete
  53. We 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
  54. من افضل واقوى شركات تنظيف خزانات المياه بجدة تلك التي تقوم بأعمال تنظيف وتعقيم خزانات المياه في جدة بمنتهى الدقة والاحترافية بعمل افضل شركة تنظيف خزانات بجده بكل تروي وترى افضل الخدمات الجيدة في تنظيف وتعقيم الخزانات لكي تحافظ على الماء نظيفا ومعقما كما في شركات تنظيف خزانات بمكه التي تقوم بتنظيف وتعقيم الخزانات وفي مدينة الطائف تعمل شركة تنظيف خزانات بالطائف على جعل الخزان نظيفا اطول فترة زمنية ممكنة في شركات تنظيف خزانات بالمدينة المنورة ومحتملة وهذا كله لكي تكون مياهك نظيفة وقد تقوم شركات تنظيف الخزانات محترفة ومستعدة لاستقبال مكالمتكم في أي وقت وطلب الخدمة وافضل خدمات منزلية تقدمها افضل شركه تنظيف خزانات بالرياض باحترافية عالية غير مسبوقة بين شركات الخدمات المنزلية في الرياض

    ReplyDelete
  55. Your 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.

    ReplyDelete
  56. I really like your site it’s very impressive. Thanks for the inspiration! I really appreciate people like you!
    website: Leather kilt

    ReplyDelete
  57. This comment has been removed by the author.

    ReplyDelete
  58. This is great content for your readers. Thanks for sharing.
    tartan skirt

    ReplyDelete
  59. Vedant Computer is Nagpur's 1st Ecommerce website for Refurbished Laptops, Refurbished Desktops, Providing consumers with an almost new-like experience.
    Visit Here::- refurbished desktop
    2nd hand laptop

    ReplyDelete
  60. 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.

    Visit here andaman tour packages

    ReplyDelete
  61. Very interesting article, thank you for sharing with us. plz click here :- malaysia visa

    ReplyDelete
  62. We as an Adventure Travel company aim to show you nice people the most beautiful
    visit here - tadiandamol trekking

    ReplyDelete