WEB开发网
开发学院数据库Oracle 建repository存放的表空间和rman用户 阅读

建repository存放的表空间和rman用户

 2008-09-09 12:55:02 来源:WEB开发网   
核心提示: 2、 恢复(1) 将数据库启动到nomount状态:$svrmgrlOracle Server Manager Release 3.1.6.0.0 - ProductionCopyright (c) 1997, 1999, Oracle Corporation. All Rights Re

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> }

上一页  1 2 3 4 5  下一页

Tags:repository 存放 空间

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接