发布时间: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.........【阅读全文】
发布时间: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.........【阅读全文】
发布时间: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.........【阅读全文】
发布时间: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.........【阅读全文】
发布时间: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.........【阅读全文】