ArcerZhang`s Technology Blog

摘要： 要报告需要三个或更多增量备份来进行恢复的文件：RMAN > REPORT NEED BACKUP incremental 3 database;要报告三天以来尚未进行备份的系统文件：RMAN > REPORT NEED BACKUP days 3 tablespace system;要报告需要进行备份以恢复到三天前的数据状态：REPORT NEED BACKUP recovery window of 3 days;如果不具有两个或更多个备份则需要进行备份 redundancy 冗余REPORT NEED BACKUP redundancy 2这个report 出来的应该都是数据文件 阅读全文

摘要： sys@TESTDB> alter system set db_create_file_dest='/u01/app/oracle/self_set/omf_dest' scope=both;System altered.sys@TESTDB> show parameter db_createNAME TYPE VALUE------------------------------------ ----------- ------------------------------db_create_file_dest ... 阅读全文

摘要： 问题描述: [root@11203ora ~]# mysql -uroot -parcerzhang ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 解决方法: # /etc/in 阅读全文

摘要： 152. One of the tablespaces is read­only in your database. The loss of all control files forced you to re­create the control file. Which operation do you need to perform after re­creating the control file and opening the database?A.drop and re­create the read­only tablespace 阅读全文

摘要： 151. You lost the PRODSTD tablespace, which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace?A.restore the tablespace from the backup there is no need to apply the redo information.B.restore the full database to recover the da 阅读全文

摘要： 如何调整最佳PGS SIZE1. 首先估计一个 PGA_AGGREGATE_TARGET 参数值。2. 使实例运行在预期的负载下，通过 Oracle 收集的 PGA 统计信息来监控系统性能，从而决定当前参数值是否适当。3. 根据 PGA 顾问工具的统计数据来调整 PGA_AGGREGATE_TARG... 阅读全文

摘要： Shut down the database and perform a backup.Restore all the data files.Mount the database.Recover the database.Without applying all the redo log files, open the database using the RESETLOGS option.Back up the database.注意：不完全恢复只能针对所有数据文件，不能针对某个单独的文件和表空间.1:10g 以前,在进行了不完全恢复用resetlogs 打开后,必须立即执行全备份,因为日志 阅读全文

摘要： LOG_ARCHIVE_FORMAT is applicable only if you are using the redo log in ARCHIVELOG mode. Use a text string and variables to specify the default filename format when archiving redo log files. The string generated from this format is appended to the string specified in the LOG_ARCHIVE_DEST parameter.Th 阅读全文

摘要： 参考文章:http://gaobo424.iteye.com/blog/1344678关于FRA官方给出的解释:To free space in the FRA we could do take a backup of the Flash Recovery Area using the command BACKUP RECOVERY AREA.This command will take the backup of all the files in the FRA to tape only. After this the space occupied by the files in the F 阅读全文

摘要： CentOS/Scientific Linux/Redhat 6 X86_64安装永中office1.下载永中office 永中office下载地址 http://www.yozosoft.com/person/ 可下载rpm包或者tar.gz包 这里用的是tar.gz的包，因为我是在linux mint上安装时下载的，后面就没有下载过了。2.安装 32位运行库 安装需要root权限，你可以用sudo（需要配置），也可以直接su - root切换到root用户$sudo yum install xulrunner.i686安装 libXtst 32位版$sudo yum install lib 阅读全文