1Z0-032-13: RMAN complete recovry:
noarchivelog mode:
在rman环境下作以下事情: DOS>rman tartget /;
RMAN>startup mount;
RMAN>run {sql 'alter database noarchive log';} //如果以前是archivelog mode;
RMAN>run {sql 'alter database open';} //在此是不可以用backup进行备份。
RMAN>shutdown immediate
RMAN>startup mount
RMAN>backup database format 'c:/oradata/%U.bak';
RMAN>run { allocate channel d1 type disk; backup database format 'c:/oradata/%U.bak'; release channel d1;} 也可以。
archivelog mode:
DOS>rman tartget /;
RMAN>startup mount;
RMAN>restore database;
RMAN>recover database;
RMAN>alter database open;
对某个或某些表空间进行恢复方法:
restore tablespace;
recover tablespace;
e.g1: RMAN>backup database format 'c:/oradata/%U.bak'; //这个是在archivelog下作的。
RMAN>shutdown immediate //此时删除DB中所有数据文件,只留下redolog control;
RMAN>startup mount;
RMAN>restore database; //好象存在这样一个问题启动DB与restore db or backup db;
RMAN>recover database;
RMAN>run {sql 'alter database open';}
e.g2: RMAN>startup mount //针对单个表空间的恢复。
RMAN>run {allocate channel d1 type disk;
set newname for datafile 'd:/oracle/oradata/fox/user01.dbf' to 'd:/user01.dbf';
restore tablespace users;
switch datafile 'd:/user01.dbf'; //更改controlfile 的信息。
recover tablespace users;
release channel d1;}
在rman环境下作以下事情: DOS>rman tartget /;
RMAN>startup mount;
RMAN>run {sql 'alter database noarchive log';} //如果以前是archivelog mode;
RMAN>run {sql 'alter database open';} //在此是不可以用backup进行备份。
RMAN>shutdown immediate
RMAN>startup mount
RMAN>backup database format 'c:/oradata/%U.bak';
RMAN>run { allocate channel d1 type disk; backup database format 'c:/oradata/%U.bak'; release channel d1;} 也可以。
archivelog mode:
DOS>rman tartget /;
RMAN>startup mount;
RMAN>restore database;
RMAN>recover database;
RMAN>alter database open;
对某个或某些表空间进行恢复方法:
restore tablespace;
recover tablespace;
e.g1: RMAN>backup database format 'c:/oradata/%U.bak'; //这个是在archivelog下作的。
RMAN>shutdown immediate //此时删除DB中所有数据文件,只留下redolog control;
RMAN>startup mount;
RMAN>restore database; //好象存在这样一个问题启动DB与restore db or backup db;
RMAN>recover database;
RMAN>run {sql 'alter database open';}
e.g2: RMAN>startup mount //针对单个表空间的恢复。
RMAN>run {allocate channel d1 type disk;
set newname for datafile 'd:/oracle/oradata/fox/user01.dbf' to 'd:/user01.dbf';
restore tablespace users;
switch datafile 'd:/user01.dbf'; //更改controlfile 的信息。
recover tablespace users;
release channel d1;}