oracle异机不完全恢复数据库

原创

llc018198 2015-12-30 18:02:14 ©著作权

文章标签 oracle 文章分类 数据库

©著作权归作者所有：来自51CTO博客作者llc018198的原创作品，请联系作者获取转载授权，否则将追究法律责任

准备参数文件：

[oracle@erpdev ~]$ cat pfileCWERPDB.ora

CWERPDB.__db_cache_size=8959033344

CWERPDB.__java_pool_size=67108864

CWERPDB.__large_pool_size=100663296

CWERPDB.__oracle_base='/home/u01/oracle'#ORACLE_BASE set from environment

CWERPDB.__pga_aggregate_target=2684354560

CWERPDB.__sga_target=10737418240

CWERPDB.__shared_io_pool_size=0

CWERPDB.__shared_pool_size=1509949440

CWERPDB.__streams_pool_size=33554432

*.audit_file_dest='/home/u01/oracle/admin/CWERPDB/adump'

*.audit_trail='db'

*.compatible='11.2.0.4.0'

*.control_files='/home/u01/oracle/oradata/CWERPDB/control01.ctl','/home/u01/oracle/fast_recovery_area/CWERPDB/control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='CWERPDB'

*.db_recovery_file_dest='/home/u01/oracle/fast_recovery_area/CWERPDB/'

*.db_recovery_file_dest_size=4385144832

*.diagnostic_dest='/home/u01/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=CWERPDBXDB)'

*.open_cursors=300

*.pga_aggregate_target=2684354560

*.processes=1000

*.remote_login_passwordfile='EXCLUSIVE'

*.sec_case_sensitive_logon=FALSE

*.sga_max_size=10737418240

*.sga_target=10737418240

*.undo_tablespace='UNDOTBS1' ；

启动数据库到nomount：

SQL> startup nomount pfile='/home/oracle/pfileCWERPDB.ora';

ORACLE instance started.

Total System Global Area 1.0689E+10 bytes

Fixed Size 2262656 bytes

Variable Size 2013268352 bytes

Database Buffers 8657043456 bytes

Redo Buffers 16900096 bytes

恢复控制文件：

RMAN> restore controlfile from '/home/oracle/level0/data_0uqpkqld_1_1.bak';

Starting restore at 24-DEC-15

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/home/u01/oracle/oradata/CWERPDB/control01.ctl

output file name=/home/u01/oracle/fast_recovery_area/CWERPDB/control02.ctl

Finished restore at 24-DEC-15

挂载数据库：

RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

注册备份集：

RMAN> catalog start with '/home/oracle/level0';

Starting implicit crosscheck backup at 24-DEC-15

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=958 device type=DISK

Crosschecked 19 objects

Finished implicit crosscheck backup at 24-DEC-15

Starting implicit crosscheck copy at 24-DEC-15

using channel ORA_DISK_1

Finished implicit crosscheck copy at 24-DEC-15

searching for all files in the recovery area

cataloging files...

no files cataloged

searching for all files that match the pattern /home/oracle/level0

List of Files Unknown to the Database

=====================================

File Name: /home/oracle/level0/arc_CWERPDBx_20151224_10qpkqok_1_1

File Name: /home/oracle/level0/data_0nqpkqa4_1_1.bak

File Name: /home/oracle/level0/data_0qqpkqak_1_1.bak

File Name: /home/oracle/level0/data_0sqpkqau_1_1.bak

File Name: /home/oracle/level0/data_0vqpkqlf_1_1.bak

File Name: /home/oracle/level0/data_0tqpkqld_1_1.bak

File Name: /home/oracle/level0/data_0uqpkqld_1_1.bak

File Name: /home/oracle/level0/data_0rqpkqar_1_1.bak

File Name: /home/oracle/level0/data_0oqpkqa4_1_1.bak

File Name: /home/oracle/level0/data_0mqpkqa1_1_1.bak

File Name: /home/oracle/level0/data_0pqpkqaj_1_1.bak

File Name: /home/oracle/level0/data_0lqpkqa1_1_1.bak

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /home/oracle/level0/arc_CWERPDBx_20151224_10qpkqok_1_1

File Name: /home/oracle/level0/data_0nqpkqa4_1_1.bak

File Name: /home/oracle/level0/data_0qqpkqak_1_1.bak

File Name: /home/oracle/level0/data_0sqpkqau_1_1.bak

File Name: /home/oracle/level0/data_0vqpkqlf_1_1.bak

File Name: /home/oracle/level0/data_0tqpkqld_1_1.bak

File Name: /home/oracle/level0/data_0uqpkqld_1_1.bak

File Name: /home/oracle/level0/data_0rqpkqar_1_1.bak

File Name: /home/oracle/level0/data_0oqpkqa4_1_1.bak

File Name: /home/oracle/level0/data_0mqpkqa1_1_1.bak

File Name: /home/oracle/level0/data_0pqpkqaj_1_1.bak

File Name: /home/oracle/level0/data_0lqpkqa1_1_1.bak

与原来的库文件路径不一样，用set newname 修改

脚本：

run

{set newname for datafile 4 to "/home/u01/oracle/oradata/CWERPDB/users.259.886161065";

set newname for datafile 3 to "/home/u01/oracle/oradata/CWERPDB/undotbs1.258.886161065";

set newname for datafile 2 to "/home/u01/oracle/oradata/CWERPDB/sysaux.257.886161065";

set newname for datafile 1 to "/home/u01/oracle/oradata/CWERPDB/system.256.886161065";

set newname for datafile 5 to "/home/u01/oracle/oradata/CWERPDB/proframe.dbf";

set newname for datafile 6 to "/home/u01/oracle/oradata/CWERPDB/proframe01.dbf";

set newname for datafile 7 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in01.dbf";

set newname for datafile 8 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in02.dbf";

set newname for datafile 9 to "/home/u01/oracle/oradata/CWERPDB/cosmos_in03.dbf";

set newname for datafile 10 to "/home/u01/oracle/oradata/CWERPDB/cosmos01.dbf";

set newname for datafile 11 to "/home/u01/oracle/oradata/CWERPDB/cosmos02.dbf";

set newname for datafile 12 to "/home/u01/oracle/oradata/CWERPDB/cosmos03.dbf";

set newname for datafile 13 to "/home/u01/oracle/oradata/CWERPDB/APPORACLEORADATAPGSCMEXAMPLE01.DBF";

set newname for datafile 14 to "/home/u01/oracle/oradata/CWERPDB/statlog.dbf";

restore database;

switch datafile all;}

执行过程：

RMAN> list incarnation;

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

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

1 1 CWERPDB 490184294 PARENT 1 24-AUG-13

2 2 CWERPDB 490184294 PARENT 925702 27-JUL-15

3 3 CWERPDB 490184294 ORPHAN 12939483587242 24-DEC-15

4 4 CWERPDB 490184294 CURRENT 12939484174408 29-DEC-15

RMAN> reset database to incarnation 2;

database reset to incarnation 2