建repository存放的表空间和rman用户
2008-09-09 12:55:02 来源:WEB开发网2、 恢复
(1) 将数据库启动到nomount状态:
$svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> startup nomount;
ORACLE instance started.
Total System Global Area 339275684 bytes
Fixed Size 94116 bytes
Variable Size 318685184 bytes
Database Buffers 16384000 bytes
Redo Buffers 4112384 bytes
SVRMGR> exit
Server Manager complete.
(2) 恢复控制文件:
$rman rcvcat rman_hainan/rman_hainan@rman target /
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN-06006: connected to target database: test (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> allocate channel d1 type disk;
3> restore controlfile;
4> release channel d1;
5> }
(3) 恢复数据文件
RMAN> run {
2> allocate channel d1 type disk;
3> sql "alter database mount";
4> restore datafile 1;
5> restore datafile 2;
6> restore datafile 3;
7> restore datafile 4;
8> release channel d1;
9> }
Tags:repository 存放 空间
编辑录入:爽爽 [复制链接] [打 印]- ››空间商限制功能阻止SEO优化
- ››空间不足引起Exchange邮件服务器罢工
- ››空间环绕<5>
- ››空间环绕<4>
- ››空间环绕
- ››空间环绕<2>
- ››空间环绕<1>
更多精彩
赞助商链接