rman RAC到单机

rman RAC到单机

备份
RMAN> run{
allocate channel c1 type disk format '/backup/%U';
backup database;
backup archivelog all;
}

创建pfile
SQL>create pfile='/backup/pfile.ora' from spfile;

修改pfile
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='NONE'
*.compatible='11.2.0.4.0'
*.control_files='/oradata/ORCL/controlfile/o1_mf_c96lbkj5_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/oradata'
*.db_domain=''
*.db_name='orcl'
*.deferred_segment_creation=FALSE
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.log_archive_dest_1='LOCATION=/arch'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=314572800
*.processes=1500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1655
*.sga_max_size=1258291200
*.sga_target=1258291200
*.undo_tablespace='UNDOTBS1'

oracle用户创建路径
mkdir /u01/app/oracle/admin/orcl/adump -p
mkdir /oradata/ORCL/datafile/ -p
mkdir /oradata/ORCL/controlfile -p
mkdir /oradata/ORCL/onlinelog -p

用pfile创建spfile
sqlplus / as sysdba
startup nomount pfile='/backup/pfile.ora';
create spfile from pfile='/backup/pfile.ora';
shutdown immediate;
startup nomount;

rman恢复
rman target / nocatalog
restore controlfile from '/u01/oracle/oradata/ractest/c-610677177-20070212-00';
alter database mount;
路径结构相同可以跳过catalog这一步
RMAN> catalog backuppiece '/u01/oracle/oradata/ractest/09i9sruq_1_1';
RMAN> catalog backuppiece '/u01/oracle/oradata/ractest/0ai9ss14_1_1';
list backup of archivelog all;
根据上条命令得出的最新的进程数加1
run {
set until sequence 59 thread 1;
set newname for datafile 1 to '/u01/oracle/oradata/ractest/data/system01.dbf';
set newname for datafile 2 to '/u01/oracle/oradata/ractest/data/undotbs01.dbf';
set newname for datafile 3 to '/u01/oracle/oradata/ractest/data/sysaux01.dbf';
set newname for datafile 4 to '/u01/oracle/oradata/ractest/data/users01.dbf';
set newname for datafile 5 to '/u01/oracle/oradata/ractest/data/undotbs02.dbf';
restore database;
switch datafile all;
recover database;
}

打开数据库之前修改日志组
select member from v$logfile;
SQL> alter database rename file '/ocfs2/oradata/racdb/redo01.log' to '/u01/oracle/oradata/ractest/log/redo01.log';
……

打开数据库
alter database open resetlogs

移除其它实例的线程日志
SQL> select THREAD#, STATUS, ENABLED
  2  from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC
         2 CLOSED PRIVATE

SQL> select group# from v$log where THREAD#=2;

    GROUP#
----------
         4
         5
         6

SQL> alter database disable thread 2;

Database altered.

SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-00350: log 4 of instance racdb2 (thread 2) needs to be archived
ORA-00312: online log 4 thread 2: '/u01/oracle/oradata/ractest/log/redo04.log'

SQL> alter database clear unarchived logfile group 4;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

SQL> alter database drop logfile group 5;

Database altered.

SQL> alter database drop logfile group 6;

Database altered.

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED
---------- ------ --------
         1 OPEN   PUBLIC

移除其它实例的undo表空间并创建新的临时表空间
SQL> sho parameter undo;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
SQL>
SQL>
SQL> select tablespace_name from dba_tablespaces where contents='UNDO';

TABLESPACE_NAME
------------------------------
UNDOTBS1
UNDOTBS2

SQL> drop tablespace UNDOTBS2 including contents and datafiles;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------
/ocfs2/oradata/racdb/temp01.dbf


SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

SQL> create temporary tablespace TEMP1
  2  tempfile '/u01/oracle/oradata/ractest/data/temp01.dbf'
  3  size 50M;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL> drop tablespace TEMP including contents and datafiles;

Tablespace dropped.