发布时间：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.........【阅读全文】
发布时间：2013-09-09 13:34:44
查看字符集SQL> select * from v$nls_parameters; 更改字符集：ALTER DATABASE character set INTERNAL_USE AL32UTF8;重启数据库。......【阅读全文】
