PRM an Oracle database disaster recovery ambulance Tool

Source: Internet
Author: User

PRM an Oracle database disaster recovery ambulance Tool

In the real world, I believe many of my friends have encountered database or file system damages, and suddenly precious data cannot be accessed, which is too fatal for companies that use data as the foundation. In most scenarios, standard RMAN-based recovery procedures can solve such problems.

In a few scenarios, conventional recovery methods may fail, often due to backup unavailability, archive loss, or hardware damage, in this scenario, a pile of inconsistent data files and unusable databases are eventually left behind. However, many people do not realize that the contents of the database or file system are not completely cleared. They may not be able to open the database, but the vast majority of data is still intact. PRM is a tool that can directly read the intact data in the data file without running the Oracle Instance database Instance. As long as the data is not completely cleared or damaged, so PRM still has the hope of saving data.

PRM can work based on corrupted file systems, ASM Diskgroup, and data files. If the Oracle Data Dictionary is available, it will use Dictionary to make recovery easier, even if the dictionary comes from an inconsistent SYSTEM. DBF system tablespace backup. For PRM, most Oracle features are supported, such as Cluster, LOB, and partition table.

Download PRM and its documentation

PRM is an open Oracle Database disaster recovery software. It developed PRM and obtained independent software copyrights.

Anyone can download to the latest PRM community edition from the http://www.parnassusdata.com/, which has a limit that each table can only save 10 thousand rows of data.

The latest PRM version is 3.0,: http://parnassusdata.com/sites/default/files/ParnassusData_PRMForOracle...

The PRM software package comes with instructions for use starting from 3.0. For more technical documentation resources, log on to: http://www.parnassusdata.com/resources/whitepapers/

Question or PRM help?

I am not clear about the usage details? Is there a problem? Or have you found the PRM bug? Or do you think that all data is not restored after PRM is used?

If you have these problems, you can go to these areas for help:

Forum: questions about PRM can be discussed on http://t.askmaclean.com/forum-24-1.html Special Edition

Mail: Mail can be sent to report_bugs@parnassusdata.com or service@parnassusdata.com

MAIN FEATURES OF PRM

  • PRM is completely written in JAVA and is a green software. Only one version of the software is required to span all operating system platforms, including AIX, Solaris, HPUX, Linux, and Windows.
  • Because it is written in JAVA, the platform is independent and the performance on all platforms is basically the same
  • The entire GUI Interactive Interface does not require any new commands. Even new DBAs can have full control
  • PRM has created a data bridge mode to save data. The data in the problematic database does not need to be exported in other forms and can be directly transferred to the new target database, reduces the time and extra disk space required for exporting and importing data.
  • The PRM program is very robust. Even if there are hundreds of problems with database corruption, PRM can easily save data.
  • PRM supports almost all common data types, including LOB: BLOB, CLOB, and NCLOB.
  • PRM can directly access the data files on ASM without copying the files from ASM.
  • PRM can directly Save the data files damaged on the ASM Diskgroup, and this function room is free of charge and can be used in the Community edition.
  • PRM has optimized the process of saving the table data truncated by Truncate. You only need to click the mouse to save it.

Restrictions

Although PRM already supports many features, Oracle technology is changing with each other, so there are still the following restrictions:

  • 11g secure file lobs is not supported. secure file lobs also involves other technologies such as encryption and compression.
  • Label security
  • Encryption
  • CELL-based asm disk on Exadata
  • Some complex data types

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.