How to recover a RAC db (raw) to single instance in Oracle

Os:redhat as 4

Oracle:oracle10gr2

The customer presents a request to demonstrate the recovery of RAC DB to single-instance, and their purpose is to verify the backup effectiveness of the production environment

Here are the ideas and the main steps:

1. First generate an init parameter file under RAC DB

2, modify parameters, Cluster_database to false and shielding Local_listener and other parameters related to the cluster

3. Backup of RAC DB via Rman (for simplicity I used catalog)

4. Copy parameter files and RAC DB Backup to Single instance machine

5. Create a directory of Bdump and data files on a single instance machine

6. Modify the Control_files path and name in the parameter file

7. Try to start instance to Nomount state on single instance machine

8. Restore Controlfile via Rman (Restore Controlfile to New Path)

9. Alter DATABASE Mount

10, the main recovery process is as follows

rman> restore Controlfile to '/app/oracle/oradata/rawdb/control01.ctl ';

Start restore at 2011-06-16 21:51:43

Using channel Ora_disk_1

Channel Ora_disk_1: Starting recovery of data file backup set

Channel ora_disk_1: Restoring Control files

Output filename =/app/oracle/oradata/rawdb/control01.ctl

Channel Ora_disk_1: Reading backup segment/app/dbbak/rawdb_20110616_03mf10gp_1_1.bak

Channel Ora_disk_1: restored backup Segment 1

Segment handle =/app/dbbak/rawdb_20110616_03mf10gp_1_1.bak Mark = tag20110616t090953

Channel Ora_disk_1: Restore Complete, spents: 00:00:03

Completing restore at 2011-06-16 21:51:50

rman> restore Controlfile to '/app/oracle/oradata/rawdb/control02.ctl ';

Start restore at 2011-06-16 21:51:55

Using channel Ora_disk_1

Channel Ora_disk_1: Starting recovery of data file backup set

Channel ora_disk_1: Restoring Control files

Output filename =/app/oracle/oradata/rawdb/control02.ctl

Channel Ora_disk_1: Reading backup segment/app/dbbak/rawdb_20110616_03mf10gp_1_1.bak

Channel Ora_disk_1: restored backup Segment 1

Segment handle =/app/dbbak/rawdb_20110616_03mf10gp_1_1.bak Mark = tag20110616t090953

Channel Ora_disk_1: Restore Complete, spents: 00:00:06

Completing restore at 2011-06-16 21:52:05

Rman>

Startup Mount

Rman> Run {

2> set newname for datafile 1 to '/app/oracle/oradata/rawdb/system01.dbf ';

3> set newname for datafile 2 to '/app/oracle/oradata/rawdb/undotbs01.dbf ';

4> set newname for datafile 3 to '/app/oracle/oradata/rawdb/sysaux01.dbf ';

5> set newname for datafile 4 to '/app/oracle/oradata/rawdb/undotbs02.dbf ';

6> set newname for datafile 5 to '/app/oracle/oradata/rawdb/users01.dbf ';

7> Restore Database;

8> switch datafile all;

9>}

Executing command: SET NEWNAME

Executing command: SET NEWNAME

Executing command: SET NEWNAME

Executing command: SET NEWNAME

Executing command: SET NEWNAME

Start restore at 2011-06-16 22:21:41

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=155 Devtype=disk

Channel Ora_disk_1: Starting recovery of data file backup set

Channel Ora_disk_1: Specifying a data file to recover from a backup set

Restoring data file 00001 to/APP/ORACLE/ORADATA/RAWDB/SYSTEM01.DBF

Restoring data file 00002 to/APP/ORACLE/ORADATA/RAWDB/UNDOTBS01.DBF

Restoring data file 00003 to/APP/ORACLE/ORADATA/RAWDB/SYSAUX01.DBF

Restoring data file 00004 to/APP/ORACLE/ORADATA/RAWDB/UNDOTBS02.DBF

Restoring data file 00005 to/APP/ORACLE/ORADATA/RAWDB/USERS01.DBF

Channel Ora_disk_1: Reading backup segment/app/dbbak/rawdb_20110616_02mf10f1_1_1.bak

Channel Ora_disk_1: restored backup Segment 1

Segment handle =/app/dbbak/rawdb_20110616_02mf10f1_1_1.bak Mark = tag20110616t090953

Channel Ora_disk_1: Restore Complete, spents: 00:02:08

Completing restore at 2011-06-16 22:24:30

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45562.htm