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