oracle11.2.0.4rac恢复到单实例(二)

run{
set newname for database to '/oradata/%b';
set until scn 394762;
restore database;
switch datafile all;
}

executing command: SET NEWNAME

Starting restore at 12-DEC-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=170 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oradata/system.262.850940553
channel ORA_DISK_1: restoring datafile 00002 to /oradata/sysaux.263.850940565
channel ORA_DISK_1: restoring datafile 00003 to /oradata/undotbs1.264.850940573
channel ORA_DISK_1: restoring datafile 00004 to /oradata/undotbs2.266.850940597
channel ORA_DISK_1: restoring datafile 00005 to /oradata/users.267.853590391
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db_0bpq0k84_1_1_20141212.bak
channel ORA_DISK_1: piece handle=/home/oracle/backup/db_0bpq0k84_1_1_20141212.bak tag=TAG20141212T194156
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 12-DEC-14

datafile 1 switched to datafile copy
input datafile copy RECID=6 STAMP=866148453 file name=/oradata/system.262.850940553
datafile 2 switched to datafile copy
input datafile copy RECID=7 STAMP=866148453 file name=/oradata/sysaux.263.850940565
datafile 3 switched to datafile copy
input datafile copy RECID=8 STAMP=866148453 file name=/oradata/undotbs1.264.850940573
datafile 4 switched to datafile copy
input datafile copy RECID=9 STAMP=866148453 file name=/oradata/undotbs2.266.850940597
datafile 5 switched to datafile copy
input datafile copy RECID=10 STAMP=866148453 file name=/oradata/users.267.853590391

RMAN> 



[oracle@11g1 oradata]$ ls -l
total 1765776
-rw-r----- 1 oracle oinstall  18497536 Dec 12 20:48 control.ctl
-rw-r----- 1 oracle oinstall 629153792 Dec 12 20:47 sysaux.263.850940565
-rw-r----- 1 oracle oinstall 734011392 Dec 12 20:47 system.262.850940553
-rw-r----- 1 oracle oinstall 209723392 Dec 12 20:47 undotbs1.264.850940573
-rw-r----- 1 oracle oinstall 209723392 Dec 12 20:47 undotbs2.266.850940597
-rw-r----- 1 oracle oinstall   5251072 Dec 12 20:46 users.267.853590391
[oracle@11g1 oradata]$ 


SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/oradata/system.262.850940553
/oradata/sysaux.263.850940565
/oradata/undotbs1.264.850940573
/oradata/undotbs2.266.850940597
/oradata/users.267.853590391

SQL> alter database open resetlogs;

Database altered.

SQL> select count(*) from test.t1;

  COUNT(*)
----------
	 2

SQL> alter database disable thread 2;

Database altered.



SQL> alter database disable thread 2;

Database altered.

SQL> 
SQL> 
SQL> 
SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.