ITPub博客

首页 > 数据库 > Oracle > ORACLE 10G ASM非归档模式下使用RMAN迁移一例

ORACLE 10G ASM非归档模式下使用RMAN迁移一例

原创 Oracle 作者:wtjiang2008 时间:2014-06-21 14:30:19 0 删除 编辑

迁移源和目标系统均为AIX系统上的ORACLE 10.2.0.4版本的ASM,系统由生产中心,迁移到数据中心;

非归档

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oracle/product/10.2.0/db/dbs/arch

Oldest online log sequence     194644

Current log sequence           194646

RMAN> show all;

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabak/racbak/rac_%d_%t_%U';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 10 G FORMAT   '/orabak/racbak/rac_%d_%t_%U';

CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 10 G FORMAT   '/orabak/racbak/rac_%d_%t_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

ecovery Manager: Release 10.2.0.4.0 - Production on Fri Jun 20 18:28:59 2014

RMAN> run{
2> allocate channel c1 type disk format '/backup/db_t%t_s%s_p%p' maxpiecesize 2000m;
3> allocate channel c2 type disk format '/backup/db_t%t_s%s_p%p' maxpiecesize 2000m;
4> allocate channel c3 type disk format '/backup/db_t%t_s%s_p%p' maxpiecesize 2000m;
5> allocate channel c4 type disk format '/backup/db_t%t_s%s_p%p' maxpiecesize 2000m;
6> backup full database include current controlfile;
7> release channel c1;
8> release channel c2;
9> release channel c3;
10> release channel c4;
11> }

。。。。。。。

channel c2: specifying datafile(s) in backupset
including current control file in backupset
channel c2: starting piece 1 at 20-JUN-14
channel c2: finished piece 1 at 20-JUN-14
piece handle=/backup/db_t850766333_s29_p1 tag=TAG20140620T182905 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:02
channel c1: finished piece 99 at 20-JUN-14
piece handle=/backup/db_t850760950_s25_p99 tag=TAG20140620T182905 comment=NONE
channel c1: starting piece 100 at 20-JUN-14
。。。。。。

piece handle=/backup/db_t850760956_s28_p110 tag=TAG20140620T182905 comment=NONE
channel c4: backup set complete, elapsed time: 01:37:17
channel c3: finished piece 111 at 20-JUN-14
piece handle=/backup/db_t850760955_s27_p111 tag=TAG20140620T182905 comment=NONE
channel c3: backup set complete, elapsed time: 01:37:43
Finished backup at 20-JUN-14


Starting Control File and SPFILE Autobackup at 20-JUN-14
released channel: c1
released channel: c2
released channel: c3
released channel: c4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on c1 channel at 06/20/2014 20:06:59
ORA-19504: failed to create file "/orabak/racbak/auto_c-3221084262-20140620-00"

ORA-27040: file create error, unable to create file

IBM AIX RISC System/6000 Error: 2: No such file or directory

Recovery Manager complete.

 

由于CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/orabak/racbak/rac_%d_%t_%U';

指定的目录'/orabak/racbak/不存在因此Control File and SPFILE Autobackup报错;

但是备份成功完成了,并且备份里包含control file;

备份数据通过HDS  HUR盘阵复制技术传输至远程目标系统;

 

 

 

恢复过程:

SQL> startup nomount pfile='/backup/pfile.ora';

ORACLE instance started.

 

Total System Global Area 2.2549E+10 bytes

Fixed Size                  2124528 bytes

Variable Size            2164262160 bytes

Database Buffers         2.0368E+10 bytes

Redo Buffers               14651392 bytes

 

RMAN> SET DBID 4221064232;

 

executing command: SET DBID

 

RMAN> RESTORE CONTROLFILE FROM '/backup/db_t850766333_s29_p1';

 

Finished restore at 20-JUN-14

 

SQL> create spfile= '+XXXX/xxxx/spfilexxxx.ora' from pfile='/backup/pfile.ora';

 

File created.

 

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> exit

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area 2.2549E+10 bytes

Fixed Size                  2124528 bytes

Variable Size            2164262160 bytes

Database Buffers         2.0368E+10 bytes

Redo Buffers               14651392 bytes

SQL> show parameter spfile;

 

NAME                                 TYPE

------------------------------------ ----------------------

VALUE

------------------------------

spfile                               string

+XXXX/xxxx/spfilexxxx.ora

SQL> alter database mount;

alter database mount

*

ERROR at line 1:

ORA-00205: error in identifying control file, check alert log for more info

 

SQL> alter system set control_files='+XXXX/xxxx/controlfile/current.256.850768855' scope=spfile;

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup  mount;

ORACLE instance started.

 

Total System Global Area 2.2549E+10 bytes

Fixed Size                  2124528 bytes

Variable Size            2164262160 bytes

Database Buffers         2.0368E+10 bytes

Redo Buffers               14651392 bytes

Database mounted.

 

RMAN> run{

2> allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

allocate channel c4 type disk;

restore database;

release channel c1;

3> 4> 5> 6> 7> 8> release channel c2;

release channel c3;

release channel c4;

}9> 10> 11>

 

using target database control file instead of recovery catalog

restoring datafile 00177 to +DWDG/tjdw/datafile/tjdw_data_155.dbf

restoring datafile 00181 to +DWDG/tjdw/datafile/tjdw_data_159.dbf

restoring datafile 00185 to +DWDG/tjdw/datafile/tjdw_data_163.dbf

restoring datafile 00189 to +DWDG/tjdw/datafile/tjdw_data_167.dbf

channel c3: reading from backup piece /backup/db_t850760951_s26_p1

ORA-19870: error reading backup piece /orabak/racbak/rac_TJDW_724253548_0llimerc_1_1

ORA-19505: failed to identify file "/orabak/racbak/rac_TJDW_724253548_0llimerc_1_1"

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-19870: error reading backup piece /orabak/racbak/rac_TJDW_724253548_0mlimerc_1_1

ORA-19505: failed to identify file "/orabak/racbak/rac_TJDW_724253548_0mlimerc_1_1"

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

恢复时居然还去找之前过期的备份;

RMAN> crosscheck backup;

RMAN> delete noprompt expired backup;

之后再执行

RMAN> run{

2> allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

allocate channel c4 type disk;

restore database;

release channel c1;

3> 4> 5> 6> 7> 8> release channel c2;

release channel c3;

release channel c4;

}9> 10> 11>

。。。。。。。。。

channel c2: restored backup piece 105

piece handle=/backup/db_t850760950_s25_p105 tag=TAG20140620T182905

channel c2: restore complete, elapsed time: 00:46:24

Finished restore at 21-JUN-14

恢复成功!

 

RMAN> recover database noredo;

Starting recover at 21-JUN-14

using channel ORA_DISK_1

Finished recover at 21-JUN-14

RMAN> alter database open resetlogs;

database opened

RMAN> exit

srvctl add database -d XXXX -o /oracle/product/10.2.0/db

srvctl add instance -d XXXX -i XXXX1 -n YYYY1

srvctl add instance -d XXXX -i XXXX2 -n YYYY2

 

alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))' sid='XXXX1';

alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))' sid='XXXX2';

修改listener.ora,tnsnames.ora,可以提前先改好。

 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/527318/viewspace-1190660/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-30

  • 博文量
    30
  • 访问量
    192092