|
|
10-11-恢复原数据库信息
本帖最后由 zcs0237 于 2014-7-23 04:00 编辑
一、恢复参数文件
1、恢复参数文件
SYS@RACDB1> show parameter spfile
spfile string +DG1/racdb/spfileracdb.ora
SYS@RACDB1> create spfile from pfile='/rac_arch/pfile.bak';
2、重启数据库
$ srvctl stop database -d RACDB ;#第一次竟然报错
PRKP-1002 : Error stopping instance RACDB1 on node rac1
CRS-0216: Could not stop resource 'ora.RACDB.RACDB1.inst'.
PRKP-1002 : Error stopping instance RACDB2 on node rac2
CRS-0216: Could not stop resource 'ora.RACDB.RACDB2.inst'.
$ srvctl stop database -d RACDB ;#第二次成功
3、使用恢复好的参数启动
$ srvctl start database -d RACDB #竟然失败reboot两个节点的OS后成功
[oracle@rac2 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....B1.inst application ONLINE ONLINE rac1
ora....B2.inst application ONLINE ONLINE rac2
ora.RACDB.db application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
二、恢复控制文件
1、关闭所有实例及数据库
$ srvctl stop database -d RACDB
2、设置原来的DBID
[oracle@rac2 ~]$ rman target /
connected to target database (not started)
RMAN> set DBID=850267053
3、加载恢复好的spfile进入nomount状态
RMAN> startup nomount
4、恢复控制文件
RMAN> restore controlfile from '/rac_arch/full_RACDB_20140721_7';
output filename=+DG1/racdb/control01.ctl
output filename=+DG1/racdb/control02.ctl
output filename=+DG1/racdb/control03.ctl
三、从全备中恢复数据库
1、使用恢复好的控制文件启动到mount状态
RMAN> alter database mount;
2、查看备份信息
RMAN> list backup of database;
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 95.02M DISK 00:00:15 21-JUL-14
BP Key: 3 Status: AVAILABLE Compressed: YES Tag: FULL
Piece Name: /rac_arch/full_RACDB_20140721_6
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 571080 21-JUL-14 +DG1/racdb/system01.dbf
2 Full 571080 21-JUL-14 +DG1/racdb/undotbs01.dbf
3 Full 571080 21-JUL-14 +DG1/racdb/sysaux01.dbf
4 Full 571080 21-JUL-14 +DG1/racdb/users01.dbf
5 Full 571080 21-JUL-14 +DG1/racdb/undotbs02.dbf
四、restore/recover数据库（没有变更数据文件的位置）
1、物理还原
RMAN> restore database;
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DG1/racdb/system01.dbf
restoring datafile 00002 to +DG1/racdb/undotbs01.dbf
restoring datafile 00003 to +DG1/racdb/sysaux01.dbf
restoring datafile 00004 to +DG1/racdb/users01.dbf
restoring datafile 00005 to +DG1/racdb/undotbs02.dbf
channel ORA_DISK_1: reading from backup piece /rac_arch/full_RACDB_20140721_6
2、逻辑恢复
RMAN> recover database;
starting media recovery
archive log thread 1 sequence 9 is already on disk as file /rac_arch/redo06.rd
archive log thread 1 sequence 10 is already on disk as file /rac_arch/redo05.rd
archive log thread 2 sequence 10 is already on disk as file /rac_arch/redo08.rd
archive log thread 2 sequence 11 is already on disk as file /rac_arch/redo07.rd
archive log filename=/rac_arch/redo08.rd thread=2 sequence=10
archive log filename=/rac_arch/redo06.rd thread=1 sequence=9
archive log filename=/rac_arch/redo07.rd thread=2 sequence=11
archive log filename=/rac_arch/redo05.rd thread=1 sequence=10
media recovery complete, elapsed time: 00:00:10
Finished recover at 22-JUL-14
五、打开数据库
SYS@RACDB2> select status from v$instance;
--MOUNTED
SYS@RACDB2> alter database open noresetlogs;
--ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SYS@RACDB2> alter database open NORESETLOGS;
ORA-01588: must use RESETLOGS option for database open
SYS@RACDB2> shutdown immediate
SYS@RACDB2> startup mount
SYS@RACDB2> alter database open RESETLOGS;
SYS@RACDB2> select username from dba_users where username='ZCS';
--ZCS
zcs0237
2014.07.22
More cleaner and more efficient!
|
|
楼主: zcs0237
IP卡
狗仔卡
楼主
显身卡
发表于 2014-7-31 21:51
发表于 2014-11-5 02:35
