Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database - 数据库编程

, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance; STATUS ------------ MOUNTED SQL> set lines 100 pages 100 SQL> select name from v$datafile 2 union all 3 select name from v$tempfile 4 union all 5 select member from v$logfile 6 union all 7 select name from v$controlfile 8 / NAME ---------------------------------------------------------------------------------------------------- /u01/app/oracle/oradata/zwc/system01.dbf /u01/app/oracle/oradata/zwc/sysaux01.dbf /u01/app/oracle/oradata/zwc/undotbs1.dbf /u01/app/oracle/oradata/zwc/users01.dbf /u01/app/oracle/oradata/zwc/example01.dbf /u01/app/oracle/oradata/zwc/undotbs2.dbf /u01/app/oracle/oradate/zwc/temp01.dbf +DATADG/zwc/onlinelog/group_2.262.826495123 +FRADG/zwc/onlinelog/group_2.258.826495125 +DATADG/zwc/onlinelog/group_1.261.826495119 +FRADG/zwc/onlinelog/group_1.257.826495121 +DATADG/zwc/onlinelog/group_3.266.826495573 +FRADG/zwc/onlinelog/group_3.259.826495577 +DATADG/zwc/onlinelog/group_4.267.826495581 +FRADG/zwc/onlinelog/group_4.260.826495585 /u01/app/oracle/oradata/zwc/control01.ctl /u01/app/oracle/oradata/zwc/control02.ctl 17 rows selected. SQL> alter database rename file '+FRADG/zwc/onlinelog/group_1.257.826495121' to '/u01/app/oracle/oradata/zwc/redo_1_1.log'; Database altered. SQL> alter database rename file '+DATADG/zwc/onlinelog/group_1.261.826495119' to '/u01/app/oracle/oradata/zwc/redo_1_2.log'; Database altered. SQL>

alter database rename file '+FRADG/zwc/onlinelog/group_2.258.826495125' to '/u01/app/oracle/oradata/zwc/redo_2_1.log'; Database altered. SQL> alter database rename file '+DATADG/zwc/onlinelog/group_2.262.826495123' to '/u01/app/oracle/oradata/zwc/redo_2_2.log'; Database altered. SQL> alter database rename file '+FRADG/zwc/onlinelog/group_3.259.826495577' to '/u01/app/oracle/oradata/zwc/redo_3_1.log'; Database altered. SQL> alter database rename file '+DATADG/zwc/onlinelog/group_3.266.826495573' to '/u01/app/oracle/oradata/zwc/redo_3_2.log'; Database altered. SQL> alter database rename file '+FRADG/zwc/onlinelog/group_4.260.826495585' to '/u01/app/oracle/oradata/zwc/redo_4_1.log'; Database altered. SQL> alter database rename file '+DATADG/zwc/onlinelog/group_4.267.826495581' to '/u01/app/oracle/oradata/zwc/redo_4_2.log'; Database altered. SQL> set lines 100 pages 100 SQL> select name from v$datafile 2 union all 3 select name from v$tempfile 4 union all 5 select member from v$logfile 6 union all 7 select name from v$controlfile 8 / NAME ---------------------------------------------------------------------------------------------------- /u01/app/oracle/oradata/zwc/system01.dbf /u01/app/oracle/oradata/zwc/sysaux01.dbf /u01/app/oracle/oradata/zwc/undotbs1.dbf /u01/app/oracle/oradata/zwc/users01.dbf /u01/app/oracle/oradata/zwc/example01.dbf /u01/app/oracle/oradata/zwc/undotbs2.dbf /u01/app/oracle/oradate/zwc/temp01.d

Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(八)