Database recovery with archive logs and no baseline backup

Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008. In the company's testing environment, the user has retained the last month

Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008. In the company's testing environment, the user has retained the last month

I. Site Information:

Oracle dual-host Hot Standby using RoseHa. The database version is 11.2.0.1.0 (64-bit) and the operating system is 64-bit windows2008.

In the company's test environment, you have retained the archived logs for the last month without making baseline backups.

The database prompts about 10 days ago that the SYSTEM tablespace has bad blocks. After restarting the computer yesterday, the database cannot be started by itself. Alert_orcl.log prompts the following error:

Ii. handling process

1. Start the database to the mount status to view the data file status.

We can see that there is a problem with the three data files. View the three files on the operating system:

All three files are faulty, all of which are 0 kb, involving two business data files and SYSAUX tablespace.

Only media can be restored.

2. dbv check for SYSTEM files with bad Blocks