ORACLE RMAN 非常规恢复DBMS_BACKUP_RESTORE
1. 环境：原机： 192.168.102.156
目标机： 192.168.102.157
2. 需求： 只有数据文件的备份和归档日志的备份 ， 无控制文件备份， 并将备份恢复到 /home/oracle/oradata/datafile下。
3. 参数文件准备
3.1 在原库生成PFILE文件。
SQL> create pfile=’/home/oracle/initgg1.ora’ from spfile;
File created.
3.2奖参数文件移至目标库。
$ scp initgg1.ora oracle@192.168.102.157:/home/oracle
oracle@192.168.102.157′s password:
initgg1.ora 100% 1051 1.0KB/s 00:00
4. 将目标库启动至NOMOUN状态。
4.1 修改参数文件：
*.control_files=’/home/oracle/oradata/datafile/control01.ctl’,'/home/oracle/oradata/datafile/control02.ctl’,'/home/oracle/oradata/datafile/control03.ctl’
*.core_dump_dest=’/home/oracle/admin/gg1/cdump’
4.2 创建PFILE所需要的目录。
$ mkdir -p admin/gg1/adump
$ mkdir -p admin/gg1/cdump
$ mkdir -p admin/gg1/bdump
$ mkdir -p admin/gg1/udump
$ mkdir oradata/datafile
4.3 将目标库启动到NOMOUNT状态。
$ export ORACLE_SID=gg1
$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to an> SQL> startup nomount pfile=’/home/oracle/initgg1.ora’;
ORACLE instance started.
Total System Global Area167772160 bytes
Fixed>
Variable> Database Buffers 75497472 bytes
Redo Buffers 7168000 bytes
5. 备份文件准备。
5.1 备份原库：
RMAN> backup format=’/home/oracle/rman/full_%d_%T_%s’ database plus archivelog;
Starting backup at 21-SEP-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=4 recid=1 stamp=794527523
input archive log thread=1 sequence=5 recid=2 stamp=794538401
input archive log thread=1 sequence=6 recid=3 stamp=794539337
input archive log thread=1 sequence=7 recid=4 stamp=794539385
input archive log thread=1 sequence=8 recid=5 stamp=794539992
input archive log thread=1 sequence=9 recid=6 stamp=794542152
input archive log thread=1 sequence=10 recid=7 stamp=794542215
input archive log thread=1 sequence=11 recid=8 stamp=794549746
channel ORA_DISK_1: starting piece 1 at 21-SEP-12
channel ORA_DISK_1: finished piece 1 at 21-SEP-12
piece handle=/home/oracle/rman/full_GG1_20120921_21 tag=TAG20120921T041546 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 21-SEP-12
Starting backup at 21-SEP-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/home/oracle/oradata/gg1/gg01.dbf
input datafile fno=00001 name=/home/oracle/oradata/gg1/system01.dbf
input datafile fno=00003 name=/home/oracle/oradata/gg1/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oradata/gg1/example01.dbf
input datafile fno=00002 name=/home/oracle/oradata/gg1/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oradata/gg1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-SEP-12
channel ORA_DISK_1: finished piece 1 at 21-SEP-12
piece handle=/home/oracle/rman/full_GG1_20120921_22 tag=TAG20120921T041551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 21-SEP-12
channel ORA_DISK_1: finished piece 1 at 21-SEP-12
piece handle=/home/oracle/rman/full_GG1_20120921_23 tag=TAG20120921T041551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 21-SEP-12
Starting backup at 21-SEP-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=12 recid=9 stamp=794549809
channel ORA_DISK_1: starting piece 1 at 21-SEP-12
channel ORA_DISK_1: finished piece 1 at 21-SEP-12
piece handle=/home/oracle/rman/full_GG1_20120921_24 tag=TAG20120921T041649 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 21-SEP-12
从上面的内容可以看出这里的控制文件已经做了备份， ORACLE 从10G以后就自动备份控制文件和SPFILE文件。这里我们还是继续往下做。
5.2 将备份文件移至目标机：
$ scp * 192.168.102.157:/home/oracle/rman
oracle@192.168.102.157′s password:
full_GG1_20120921_21 100% 48MB11.9MB/s 00:04
full_GG1_20120921_22 100%595MB11.0MB/s 00:54
full_GG1_20120921_23 100% 6976KB 6.8MB/s 00:01
full_GG1_20120921_24 100% 12KB12.0KB/s 00:00
$
6. 定义数据文件恢复过程
SQL> declare
devtype varchar2(256);
done boolean;
begin
devtype:=sys.dbms_backup_restore.deviceAllocate(type=>”,ident=>’t1′);
sys.dbms_backup_restore.restoreSetDatafile;
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>01,toname=>’/home/oracle/oradata/datafile/system01.dbf’);
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>02,toname=>’/home/oracle/oradata/datafile/undotbs01.dbf’);
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>03,toname=>’/home/oracle/oradata/datafile/sysaux01.dbf’);
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>04,toname=>’/home/oracle/oradata/datafile/users01.dbf’);
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>05,toname=>’/home/oracle/oradata/datafile/example01.dbf’);
sys.dbms_backup_restore.restoreDatafileTo(dfnumber=>06,toname=>’/home/oracle/oradata/datafile/gg01.dbf’);
sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>’/home/oracle/rman/full_GG1_20120921_22′,params=>null);
sys.dbms_backup_restore.deviceDeallocate;
end;
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16/
PL/SQL procedure successfully completed.
查看ALERT日志：
Full restore complete of datafile 4 to datafile copy /home/oracle/oradata/datafile/users01.dbf.Elapsed time: 0:00:01
checkpoint is 537114
Full restore complete of datafile 2 to datafile copy /home/oracle/oradata/datafile/undotbs01.dbf.Elapsed time: 0:00:05
checkpoint is 537114
Fri Sep 21 04:41:43 2012
Full restore complete of datafile 5 to datafile copy /home/oracle/oradata/datafile/example01.dbf.Elapsed time: 0:00:10
checkpoint is 537114
Full restore complete of datafile 3 to datafile copy /home/oracle/oradata/datafile/sysaux01.dbf.Elapsed time: 0:00:18
checkpoint is 537114
Fri Sep 21 04:41:58 2012
Full restore complete of datafile 1 to datafile copy /home/oracle/oradata/datafile/system01.dbf.Elapsed time: 0:00:26
checkpoint is 537114
Fri Sep 21 04:42:09 2012
Full restore complete of datafile 6 to datafile copy /home/oracle/oradata/datafile/gg01.dbf.Elapsed time: 0:00:35
checkpoint is 537114
7.恢复归档日志：
SQL> declare
devtype varchar2(256);
done boolean;
begin
devtype:=sys.dbms_backup_restore.deviceallocate(type=>”,ident=>’t1′);
sys.dbms_backup_restore.restoresetarchivedlog(destination=>’/home/oracle/archivelog’);
sys.dbms_backup_restore.restorearchivedlog(thread=>1,sequence=>11);
sys.dbms_backup_restore.restorebackuppiece(done=>done,handle=>’/home/oracle/rman/full_GG1_20120921_21′,params=>null);
sys.dbms_backup_restore.devicedeallocate;
end;
/2 3 4 5 6 7 8 9 10 11
PL/SQL procedure successfully completed.
SQL> declare
devtype varchar2(256);
done boolean;
begin
devtype:=sys.dbms_backup_restore.deviceallocate(type=>”,ident=>’t1′);
sys.dbms_backup_restore.restoresetarchivedlog(destination=>’/home/oracle/archivelog’);
sys.dbms_backup_restore.restorearchivedlog(thread=>1,sequence=>12);
sys.dbms_backup_restore.restorebackuppiece(done=>done,handle=>’/home/oracle/rman/full_GG1_20120921_24′,params=>null);
sys.dbms_backup_restore.devicedeallocate;
end;
/2 3 4 5 6 7 8 9 10 11
PL/SQL procedure successfully completed.
8. 创建控制文件。
SQL>CREATE CONTROLFILE REUSE DATABASE “GG1″ RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ‘/home/oracle/oradata/datafile/redo01.log’SIZE 50M,
GROUP 2 ‘/home/oracle/oradata/datafile/redo02.log’SIZE 50M,
GROUP 3 ‘/home/oracle/oradata/datafile/redo03.log’SIZE 50M
– STANDBY LOGFILE
DATAFILE
‘/home/oracle/oradata/datafile/system01.dbf’,
‘/home/oracle/oradata/datafile/undotbs01.dbf’,
‘/home/oracle/oradata/datafile/sysaux01.dbf’,
‘/home/oracle/oradata/datafile/users01.dbf’,
‘/home/oracle/oradata/datafile/example01.dbf’,
‘/home/oracle/oradata/datafile/gg01.dbf’
CHARACTER SET AL32UTF8
;
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Control file created.
9. 打开数据库。
SQL>>
Database> 10.创建临时表空间。
SQL>>
Tablespace> 11. 关闭数据库，创建SPFILE， 开启数据库。
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile=’/home/oracle/initgg1.ora’;
File created.
SQL> startup
ORACLE instance started.
Total System Global Area167772160 bytes
Fixed>
Variable> Database Buffers 75497472 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
页:
[1]