channel ORA_DISK_1: finished piece 1 at13-MAY-15
piecehandle=/home/oracle/db_increi4q6s1lp_1_1.bbk tag=TAG20150513T202207comment=NONE
channel ORA_DISK_1: backup set complete,elapsed time: 00:00:01
Finished backup at 13-MAY-15
RMAN>
查看是否备份成功
RMAN> list backup of database;
......
BS Key Type LV Size Device TypeElapsed Time Completion Time
------- ---- -- ---------- ----------------------- ---------------
3343 Incr 2.41G DISK 00:09:35 13-MAY-15
BP Key: 3343 Status:AVAILABLE Compressed: NO Tag: TAG20150513T202207
Piece Name: /home/oracle/db_increi3q6s13g_1_1.bbk
Keep: NOLOGS Until:20-MAY-15
List of Datafiles in backup set 3343
File LV Type Ckp SCN CkpTime Name
---- -- ---- ---------- --------- ----
1 Incr 11134253054 13-MAY-15/home/oradata/powerdes/system01.dbf
2 Incr 11134253054 13-MAY-15/home/oradata/powerdes/sysaux01.dbf
3 Incr 11134253054 13-MAY-15/home/oradata/powerdes/undotbs01.dbf
4 Incr 11134253054 13-MAY-15/home/oradata/powerdes/users01.dbf
5 Incr 11134253054 13-MAY-15/home/oradata/powerdes/powerdesk01.dbf
6 Incr 11134253054 13-MAY-15/home/oradata/powerdes/plas01.dbf
7 Incr 11134253054 13-MAY-15/home/oradata/powerdes/pl01.dbf
8 Incr 11134253054 13-MAY-15/home/oradata/powerdes/help01.dbf
9 Incr 11134253054 13-MAY-15/home/oradata/powerdes/adobelc01.dbf
10 Incr 11134253054 13-MAY-15/home/oradata/powerdes/sms01.dbf
11 Incr 11134253054 13-MAY-15/home/oradata/powerdes/plcrm01.dbf
RMAN>
去查看备份的文件,看到2个bbk,表示备份成功,如下所示:
[oracle@localhost ~]$ ll db*
-rw-r----- 1 oracle oinstall 2591825920 May13 20:31 db_increi3q6s13g_1_1.bbk
-rw-r----- 1 oracle oinstall 19234816 May 13 20:31db_increi4q6s1lp_1_1.bbk
[oracle@localhost ~]$
6,在主库重新生成控制文件
ALTER DATABASE CREATE standby controlfileAS '/home/oracle/standby.ctl';
SQL> ALTER DATABASE CREATE standbycontrolfile AS '/home/oracle/standby.ctl';
Database altered.
SQL>
7,copy备份文件到备库
[oracle@localhost ~]$ scp db*/home/oracle/standby.ctl root@192.168.xx.xx:/data/oracle/backup/restore/
root@192.168.xx.xx's password:
db_increi3q6s13g_1_1.bbk 100% 2472MB 95.1MB/s 00:26