E in backupset
channel ch01: starting piece 1 at 13-JUN-11
--ch00关于控制文件备份结束。备份集是bk_11_1_753725696 ,耗时1分41秒。
channel ch00: finished piece 1 at 13-JUN-11
piece handle=bk_11_1_753725696 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch00: backup set complete, elapsed time: 00:01:41
--ch00关于spfile备份结束。备份集是bk_12_1_753725761 ,耗时1分21秒。这里是我们spfile备份所处的备份集。
channel ch01: finished piece 1 at 13-JUN-11
piece handle=bk_12_1_753725761 tag=HOT_DB_BK_LEVEL0 comment=API Version 2.0,MMS Version 5.0.0.0
channel ch01: backup set complete, elapsed time: 00:01:21
Finished backup at 13-JUN-11
因此,利用上述信息进行spfile的还原:
RMAN> run
2> {
allocate channel ch00 type 'SBT_TAPE';
send 'NB_ORA_SERV=sg2ts001, NB_ORA_CLIENT=sg2as059';
restore spfile from 'bk_12_1_753725761';
release channel ch00;
}3> 4> 5> 6> 7>
allocated channel: ch00
channel ch00: sid=39 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
sent command to channel: ch00
Starting restore at 14-JUN-11
channel ch00: autobackup found: bk_12_1_753725761
channel ch00: SPFILE restore from autobackup complete
Finished restore at 14-JUN-11
released channel: ch00
RMAN>
注,关于上述的client和server的信息,可以根据bp.conf 文件来确定:
sg2as059:/usr/openv/netbackup>cat bp.conf
SERVER = sg2ts001
CLIENT_NAME = sg2as059
CLIENT_READ_TIMEOUT = 1800
在此过程中,可以在nbu的控制台看是否已经restore操作。
也可以另开窗口,看到该rman的等待事件是sbtrestore。
另外,也可以看nbu的log,如果没有新log产生,说明备份还停留在rman部分,没传递给NBU。
Restore started Sat Jun 18 21:51:36 2011
21:51:53 (342183.xxx) Restore job id 342183 will require 1 image.
--可以看到是条码为SG2097的磁带用于恢复。
21:51:53 (342183.xxx) Media id SG2097 is needed for the restore.
21:51:58 (342183.001) Restoring from image created 06/13/11 16:38:23
21:52:03 (342183.001) INF - Data socket = sg2as041.sg2.michelin.com.IPC:/tmp/vnet-51486308405120999841000000000-pYqfUa;447c375effa3496638d871ada708993a;4;300
21:52:03 (342183.001) INF - Name socket = sg2as041.sg2.michelin.com.IPC:/tmp/vnet-62398308405121400308000000000-q5uhUa;68faa96764e5b101e55fcebbe7e82816;4;300
21:52:03 (342183.001) INF - Job id = 342183
21:52:03 (342183.001) INF - Backup id = sg2as059_1307954303
21:52:04 (342183.001) INF - Backup time = 1307954303
--等待mount磁带
21:52:04 (342183.001) INF - Waiting for mount of media id SG2097 on server sg2ts001 for reading.
21:52:04 (342183.001) INF - Policy name = sg2as059_oracle_nbutest_backup
21:52:04 (342183.001) INF - Snapshot = 0
21:52:04 (342183.001) INF - Frozen image = 0
21:52:04 (342183.001) INF - Backup copy = 0
21:52:05 (342183.001) INF - Master server = sg2ts001
21:52:05 (342183.001) INF - Media server = sg2ts001
21:52:05 (342183.001) INF - New data socket = sg2as041.sg2.michelin.com.IPC:/tmp/vnet-18016308405119598273000000000-nUIgaa;17e13638af10f48600d99cc9777b3919;4;300
21:52:05 (342183.001) INF - Encrypt = 0
21:52:05 (342183.001) INF - Use shared memory = 0
21:52:06 (342183.001) INF - Restore id = 342183.001
21:52:06 (342183.001) INF - Encrypt = 0
21:52:06 (342183.001) INF - Client read timeout = 300
21:52:06 (342183.001) INF - Media mount timeout = 600
21:52:06 (342183.001) INF - client = sg2as059
21:52:07 (342183.001) INF - requesting_client = sg2as059
21:52:07 (342183.001) INF - browse_client = sg2as059
--在定位SG2097磁带上的备份集。
21:52:54 (342183.001) INF - Waiting for positioning of media id SG2097 on server sg2ts001 for reading.
--从磁带上还原。
21:53:33 (342183.001) INF - Beginning restore f