channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/arch_ORCL_20061207_56 tag=TAG20061207T193504 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-06
Starting backup at 07-DEC-06
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=00001 name=/free/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/free/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00006 name=/free/oracle/oradata/orcl/gaojf1db.dbf
input datafile fno=00007 name=/free/oracle/oradata/orcl/gaojf2db.dbf
input datafile fno=00008 name=/free/oracle/oradata/orcl/gaojf3db.dbf
input datafile fno=00010 name=/free/oracle/oradata/orcl/cicrodb1.dbf
input datafile fno=00011 name=/free/oracle/oradata/orcl/cicrodb11.dbf
input datafile fno=00009 name=/free/oracle/oradata/orcl/gaojf4db.dbf
input datafile fno=00002 name=/free/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00005 name=/free/oracle/oradata/orcl/gaojfdb.dbf
input datafile fno=00004 name=/free/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-DEC-06 channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/FULL_ORCL_20061207_57 tag=TAG20061207T193507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:55
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby control file in backupset
channel ORA_DISK_1: starting piece 1 at 07-DEC-06
channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/FULL_ORCL_20061207_58 tag=TAG20061207T193507 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 07-DEC-06
Starting backup at 07-DEC-06
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=320 recid=443 stamp=608585946
channel ORA_DISK_1: starting piece 1 at 07-DEC-06
channel ORA_DISK_1: finished piece 1 at 07-DEC-06
piece handle=/free/oracle/arch_ORCL_20061207_59 tag=TAG20061207T193906 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 07-DEC-06
Starting Control File Autobackup at 07-DEC-06
piece handle=/free/oracle/orabak/c-1132959697-20061207-02 comment=NONE
Finished Control File Autobackup at 07-DEC-06
RMAN>
8:复制 rman全备份到备库
利用操作系统命令scp,或者ftp bin方式复制rman全备份到备库。
由于我rman主库备份时设置备份文件位置为/free/oracle,因此必须把此备份文件也放到备库同样的位置。
同时scp 控制文件standby.ctl到备库相应的位置。
9.启动备库到nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
10.利用rman恢复备库
oracle@linux:/free/oracle/oradata/orcl>
rman target sys/cicro@p