ORACLE 10G RAC ASM Recovery Example

The libraries in the ASM instance of the RAC server are corrupted, some data files are missing, and control files and SPFile are lost. The DB instance is also in the shutdown state.

1, find the location of the backup slice

By looking, the backup slice is in

/u01/app/oracle/product/10.2.0/db_1/dbs/01ntr7ob_1_1datafile

/u01/app/oracle/product/10.2.0/db_1/dbs/02ntr7qn_1_1controlfile and SPFile

2. First boot the dummy instance in Rman

Copy the Init.ora to Initkdata.ora first

In Rman

Connect Target/

Startup Nomount;

3. Remove the spfile from the backup slice

Restore SPFile from '/u01/app/oracle/product/10.2.0/db_1/dbs/02ntr7qn_1_1 ';

4. Close the Database Dummy instance

Shutdown immediate;

5. Start the DB instance to Nomount

Startup Nomount;

6. Remove the controlfile from the backup slice

Restore Controlfile from '/u01/app/oracle/product/10.2.0/db_1/dbs/02ntr7qn_1_1 ';

7. Start the DB instance to mount

ALTER DATABASE Mount;

8. Restore the database

Restore database;

9. Restore the Database

Due to the loss of Archivelog and Onlinelog, it is only possible to use incomplete recovery.

Recover database using Backup controlfile until cancel;

Specify log: {<ret>=suggested | AUTO | CANCEL}
CANCEL

10. Open the Database

ALTER DATABASE open resetlogs;

Follow-up question one:

This may be a problem, that is, the recovered SPFile is not under the ASM instance, but comes to the host file system. This will require a re-spfile of the ASM instance, otherwise the instance of the other node may not be able to start.

1. Create Pfile

Create Pfile from SPFile;

2. Create SPFile on ASM

Create spfile= ' +as/chsh/spfilekdata.ora ' from pfile= '/u01/app/oracle/product/10.2.0/db_1/dbs/initkdata1.ora ';

So there's spfile on ASM.

3, confirm the two nodes

Whether the contents of ~/dbs/initkdata1.ora and ~/dbs/initkdata2.ora are:

Spfile= ' +as/chsh/spfilechsh.ora '

Follow-up question two:

When you open a DB instance, everything is fine, but when you open the DB instance, there is a serious problem.

In

ALTER DATABASE open Resetlogs appears when

Ora-03113:end-of-file on communication file

View dump file is

Ora-00600:internal error code, arguments: [3705], [2], [4], [4], [1], [], [], []

Online logs have serious problems

First try to use

Recover database until cancel;

ALTER DATABASE open resetlogs;

is still

Ora-03113:end-of-file on communication file

And the instance died immediately.

Repeated attempts failed.

At this time try to use ALTER DATABASE clear log Group 4, the result fails.

and the current log group cannot drop.

Finally try using recover database using Backup controlfile until cancel;

Then an archive log under ASM is specified, although the error says that it does not contain the desired SCN value, but the recover is completed normally, try again

ALTER DATABASE open resetlogs;

The library is open.

ORACLE 10G RAC ASM Recovery Example