ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN Hello World

RMAN Hello World

原创 Linux操作系统 作者:abstractcyj 时间:2013-06-05 08:55:32 0 删除 编辑
D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>rman target xe

Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 5 08:48:01 2013

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

target database Password:
connected to target database: XE (DBID=2681771432)

RMAN> configure default device type to disk;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> configure device type disk backup type to copy;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY PARALLELISM 1;
new RMAN configuration parameters are successfully stored

RMAN> configure controlfile autobackup on;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

RMAN> backup database plus archivelog delete input;


如果恢复区的空间大小不够:
查看恢复区大小:
show parameter db_recovery_file_dest
以DBA身份运行:
alter system set db_recovery_file_dest_size="一个合适的大小" scope=both

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-763001/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Flashback Query
请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091658