Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1062046
  • 博文数量: 239
  • 博客积分: 10
  • 博客等级: 民兵
  • 技术积分: 3618
  • 用 户 组: 普通用户
  • 注册时间: 2012-11-12 13:17
文章分类

全部博文(239)

文章存档

2021年(1)

2016年(1)

2015年(30)

2014年(91)

2013年(116)

发布时间:2013-09-11 10:52:38

1.备份控制文件RMAN> backup current controlfile;Starting backup at 10-SEP-13using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setincluding current control file in backup setchannel ORA_DISK_1: starting piece 1 at.........【阅读全文】

阅读(1197) | 评论(0) | 转发(0)

发布时间:2013-09-11 10:41:04

RMAN> backup datafile '/oradata/portaldb_ICMSFQ04_01.dbf';Starting backup at 10-SEP-13using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00007 name=/oradata/portaldb_ICMSFQ04_01.dbfch.........【阅读全文】

阅读(1101) | 评论(0) | 转发(0)

发布时间:2013-09-11 10:37:50

[oracle@oracle backup]$ sqlplus "/as sysdba";SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 10 18:49:16 2013Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLA.........【阅读全文】

阅读(922) | 评论(0) | 转发(0)

发布时间:2013-09-11 09:48:01

RMAN> backup tablespace ICMLFQ32;Starting backup at 10-SEP-13using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00005 name=/oradata/portaldb_ICMLFQ32_01.dbfchannel ORA_DISK_1: startin.........【阅读全文】

阅读(808) | 评论(0) | 转发(0)

发布时间:2013-09-11 09:35:29

用rman备份数据库时,遇到如下信息RMAN-03009: failure of backup command on ORA_DISK_1 channelORA-19602: cannot backup or copy active file in NOARCHIVELOG modeRman需要在归档模式下SQL> connect sys/chaya as sysdbaSQL> shutdown immediate;SQL> startup mount;SQL> alter database archivelog;SQL> alter.........【阅读全文】

阅读(1865) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册