分享
 
 
 

详细讲解Oracle数据库10g RMAN的备份过程

王朝oracle·作者佚名  2008-06-01
窄屏简体版  字體: |||超大  

1.首先查看一下Oracle的数据文件

SQL> select name from v$datafile;

NAME

-------------------------------------

/dev/rora_system

/dev/rora_undo1

/dev/rora_sysaux

/dev/rora_users

/dev/rora_example

2.建立RMAN所需的表空间,这里采用裸设备“/dev/rora_backup”

SQL> create tablespace ora_backup datafile'/dev/rora_backup' size 500M;

Tablespace created.

进行查看确认

SQL> select name from v$datafile;

NAME

----------------------------------------

/dev/rora_system

/dev/rora_undo1

/dev/rora_sysaux

/dev/rora_users

/dev/rora_example

/dev/rora_backup

6 rows selected.

已经发现ora_backup表空间

3.建立RMAN用户以及设定密码和用户表空间

SQL> create user rman identified by rman default tablespace ora_backup temporay tablespace temp

2 ;

create user rman identified by rman default tablespace ora_backup temporay tablespace temp

*

ERROR at line 1:

ORA-00922: missing or invalid option

在此处出错,原来是temporay打错,继续。

SQL> create user rman identified by rman default tablespace ora_backup temporary tablespace temp;

User created.

呵呵,成功

4.给用户授权

SQL> grant connect,resource,recovery_catalog_owner to rman

2 ;

Grant succeeded.

5.连接到数据库

SQL> rman target 'zhirui' catalog rman/rman

SP2-0734: unknown command beginning "rman targe..." - rest of line ignored.

呵呵,又出错了,没退出SQL。

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

$ rman target 'zhirui'catalog rman/rman

这下应该可以了吧

Argument Value Description

-----------------------------------------------------

target quoted-string connect-string for target database

catalog quoted-string connect-string for recovery catalog

nocatalog none if specified, then no recovery catalog

cmdfile quoted-string name of input command file

log quoted-string name of output message log file

trace quoted-string name of output debugging message log file

append none if specified, log is opened in append mode

debug optional-args activate debugging

msgno none show RMAN-nnnn prefix for all messages

send quoted-string send a command to the media manager

pipe string building block for pipe names

timeout integer number of seconds to wait for pipe input

checksyntax none check the command file for syntax errors

-----------------------------------------------------------------------------

Both single and double quotes (' or ") are accepted for a quoted-string.

Quotes are not required unless the string contains embedded white-space.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00552: syntax error in command line arguments

RMAN-01009: syntax error: found "rman": expecting one of: "append, at, auxiliary, catalog, cmdfile, clone, checksyntax,"

RMAN-01007: at line 2 column 1 file: command line arguments

恩?怎么回事?

$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 25 00:37:24 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN> connect catalog rman/rman

connected to recovery catalog database

RMAN> exit

Recovery Manager complete.

可以连接呀,再来

$ rman target 'zhirui' catalog rman/rman

Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 25 00:38:13 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

target database Password:

connected to target database: ZHIRUI (DBID=1679784276)

connected to recovery catalog database

恩,连接进去了。

6.注册数据库

RMAN> register database;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of register command at 05/25/2007 00:38:55

RMAN-06428: recovery catalog is not installed

出错,recovery catalog is not installed

RMAN> register database zhirui;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "identifier": expecting one of: ";"

RMAN-01008: the bad identifier was: zhirui

RMAN-01007: at line 1 column 19 file: standard input

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, chan"

RMAN-01007: at line 1 column 25 file: standard input

7.建立catalog表空间到ora_backup

RMAN> create catalog tablespace ora_backup

recovery catalog created

这下可以注册了吧。

RMAN> register database;

database registered in recovery catalog

starting full resync of recovery catalog

full resync complete

注册成功

8.尝试备份全库

RMAN> run {

2> allocate channel dev1 type disk;

3> backup

4> format '/home/oracle/data/db_t%t_s%s_p%p'

5> (database);

6> release channel dev1;

7> }

allocated channel: dev1

channel dev1: sid=159 devtype=DISK

Starting backup at 25-MAY-07

channel dev1: starting full datafile backupset

channel dev1: specifying datafile(s) in backupset

input datafile fno=00006 name=/dev/rora_backup

input datafile fno=00001 name=/dev/rora_system

input datafile fno=00003 name=/dev/rora_sysaux

input datafile fno=00005 name=/dev/rora_example

input datafile fno=00002 name=/dev/rora_undo1

input datafile fno=00004 name=/dev/rora_users

channel dev1: starting piece 1 at 25-MAY-07

至此,成功。

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有