oracle 测试坚挺,Oracle RMAN测试

,);

SQL> select dbid from v$database;

DBID

----------

2732836240

/*************unregister DB*********************/

如果无catalog，则rman nocatalog

connect target /

3.开始备份

B1.全备份脚本,备份到硬盘上/backup/bckdb/下面:

rman target / catalog rman/rman@rman_catalog

run {

configure controlfile autobackup off;

allocate channel  ch00 TYPE disk;

allocate channel  ch01 TYPE disk;

backup full database  tag full_db_backup

format '/backup/bckdb/dbfile_t%t_s%s_p%p';

sql 'alter system archive log current';

backup filesperset 3 archivelog all delete input;

backup current controlfile format  '/backup/bckdb/ctlfile_t%t_s%s_p%p';

release channel ch00;

release channel ch01;

}

R1:对应的恢复脚本，(比如全部文件丢失，包括control,redo,datafile)

如果是不同的机器恢复：需要配置环境，拷贝RDBMS部分的文件，修改pfile，listener.ora，符合新的环境，指令都差不多。

SQLPlus指令：

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup nomount

SQL> create spfile from pfile;

File created.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  562036736 bytes

Fixed Size                  2074384 bytes

Variable Size             163580144 bytes

Database Buffers          390070272 bytes

Redo Buffers                6311936 bytes

SQL>

RMAN指令：

rman target / catalog rman/rman@rman_catalog

如果RMAN备份了多个数据库并且在异机恢复，需要修改dbid这个变量，让它等于需要恢复的数据库ID。

run{

allocate channel  ch00 TYPE disk;

restore controlfile;

restore database;

sql "alter database mount";

recover database;

release channel ch00;

}

SQLPlus指令：

alter database open resetlogs;

4.Q&A

Q1:

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_TEST'

A1:删除spfile中的*.local_listener='LISTENER_TEST'

Q2:

RMAN-06004: ORACLE error from recovery catalog database:

RMAN-20011: target database incarnation is not current in recovery catalog

A2:在rman中执行了alter database open resetlogs; 这条指令会把修改incarnation，这个值修改后，以前的对应关系会消失，需要reset database一下。如果在sqlplus下面执行就不会出现这个错误了，还有一种办法是，注销重新注册，不推荐。

Q3:恢复时报错

ORA-19870: error reading backup piece /backup/bckdb/dbfile_t669483833_s20_p1

ORA-19504: failed to create file "/disk1/oradata/COMPARD/control01.ctl"

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

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

A3:恢复的时候，恢复目录要事先建立好，否则会出这个错误

Q4:

RMAN-06026: some targets not found - aborting restore

RMAN-06024: no backup or copy of the control file found to restore

A4:如果是控制文件没有备份，那就把源库的拷贝过来，mount后继续。如果在rman中作过resetlogs，参考Q2.

Q5:Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCTEST))

TNS-12555: TNS:permission denied

TNS-12560: TNS:protocol adapter error

TNS-00525: Insufficient privilege for operation

A5:chmod -R 0777 .oracle