How to Use the orachk Tool

The robustness after Oracle RAC is installed is a headache. Oracle previously launched a dedicated raccheck tool for it, which makes it easy for us to use these hard-pressed DBAs. Now, Oracle has launched the license HK on the basis of raccheck. orachk includes the EXAchk feature and replaces the popular RACcheck tool to expand coverage based on the priority of the most important issues reported by the user, and actively scans E-Business Suite events als Accounts Payables, Oracle Database, Sun Systems and other products for known issues. We will unveil it for you below.

1. Functions of HK

2. Fields, platforms, and database versions supported by ingress HK

Platform and database version

* 32-bit platforms not supported, no planned support for Linux Itanium

Supported database versions: 10gR2, 11gR1, 11gR2, and 12cR1

Details of the orachk check

3. When do I need to renew HK?

4. Configure and run ingress HK

5. Practice HK

# Getting help information

-Clusternodes

Ordb1: oracle: orcl101>./orachk-

Checking ssh user equivalency settings on all nodes in cluster

Node oadb2 is configured for ssh user equivalency for oracle user

..

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1, 2 etc [1-2] [1].

Checking Status of Oracle Software Stack-Clusterware, ASM, RDBMS

......................................

Copying plug-ins

............. Follow the prompts to go down ..............................

After the check, a corresponding directory and report file will be generated in the current directory. For example, you can directly view the corresponding html file.

For more functions, refer to the help file or view the help HK User Guide.pdf

References

Oracle Flash recovery area)

Snapshot control file)

Backup and recovery solution for small and medium databases rman catalog (1)

Backup and recovery solution for small and medium databases rman catalog (2)

Backup and recovery solution for small and medium databases rman catalog (III)

Block RECOVERY BASED ON RMAN)

Use DBMS_REPAIR to fix Bad blocks

Method for converting the cloned file location in the RMAN Database

RMAN duplicate)

RMAN-based database cloning on the same machine

User-managed database clone

Cloning from an active database based on RMAN (rman duplicate from active DB)

RMAN duplicate from active encountered ORA-17627 ORA-12154

Oracle cold backup

Oracle Hot Backup

Concept of Oracle backup recovery

Oracle instance recovery

Oracle recovery based on user management

SYSTEM tablespace management and Backup Recovery

SYSAUX tablespace management and recovery

Oracle backup control file recovery (unsing backup controlfile)

RMAN overview and architecture

RMAN configuration, Monitoring and Management

Detailed description of RMAN backup

RMAN restoration and recovery

Create and use RMAN catalog

Create RMAN storage script based on catalog

Catalog-based RMAN backup and recovery

RMAN backup path confusion

Customize the date and time format displayed by RMAN

Backup and recovery of read-only tablespace

Incomplete recovery of Oracle based on user management

Understanding using backup controlfile

Use RMAN for recovery from different machine backups (WIN platform)

Use RMAN to migrate a file system database to ASM

Oracle backup policy (RMAN) in Linux)

Linux RMAN backup shell script

Use RMAN to migrate the database to a different machine

Run the SQL statement at the RMAN prompt.

Oracle RMAN-based incomplete recovery (incomplete recovery by RMAN)

Rman restores archivelog)