-
编辑 删除
using rman to creat oracle10g data guard standby db_with recovery
1,请参上一节，我所述关于利用rman tool to create dg standby示例2,唯一不同的，请在最终rman脚本上，添加如下，或者：修正如下： run{--set until scn scn号；--源于主库的select max(next_change#) from v$...
-
编辑 删除
oracle10g_data guard_rman恢复测试出错_RMAN-06207
事由如下： 不记如何把以前作的控制文件备份（主库上），手工删除，导致 利用rman恢复总提示如下错误：-bash-3.1$ rman target sys/system@centos auxiliary sys/systemRecovery Manager: Release 10.2....
-
编辑 删除
新浪
综合性信息集成
-
编辑 删除
centos3.9 scp相关选项_备注
scp -r -q -v /oracle/testscp oracle@192.168.125.3:/oracle --- -r表递归复制目录下面所有东东 -q关闭复制进度条 &nb...
-
编辑 删除
creating oracle10g data guard using rman(physical db)
1,对主库进行一个全库备份（利用rman) backup as copy incremental level 0 database format '/oracle/rmanbak/%Ubak' tag 'test rman standby db';2,根据主库生成备库pfile(且根据备库实际情况...
-
编辑 删除
与oracle10g data guard(dg)紧密关联的相关视图
Table 16-1 Views That Are Pertinent to Data Guard ConfigurationsViewDatabaseDescriptionDBA_LOGSTDBY_EVENTSLogical onlyContains information about the activity of a logical standbydat...
-
编辑 删除
oracle10g data guard(dg)__归档日志备份删除相关策略_rman_configure
Examples of the CONFIGURE ARCHIVELOG DELETION POLICY CommandWhen backups of archived redo log files are taken on the standby database:Issue the following command on the primary database:CONFIGURE ...
-
编辑 删除
对oracle10g data guard(dg)实行不一致性恢复
1,记录误删除备库数据文件的current_scn及resetlogs_change#SQL> select current_scn from v$database;CURRENT_SCN----------- 5765452,模拟删除备库的数据文件 mv line1...
-
编辑 删除
rman_restore controlfile_and_autobackup之关系测试
1,如下表明：控制文件完完情况下，恢复控制文件从autobackup去找对应备份,所以你一定要形成配置spfile和controlfile自动备份的好习惯，不然，呵呵RMAN> restore controlfile;Starting restore at 30-JAN-10using cha...
-
编辑 删除
oracle10g data guard(dg)_主库控制文件受损或loss_自动关库测试
********************* ATTENTION: ******************** The controlfile header block returned by the OS has a sequence number that is too old. The controlfile might be corrupted. P...
-
编辑 删除
rman运行与控制文件损坏_loss_小测试
[oracle@localhost bdump]$ $ORACLE_HOME/bin/rman target sys/system@centosRecovery Manager: Release 10.2.0.4.0 - Production on Sat Jan 30 20:28:54 2010Copyright (c) 1982, 2007, Oracle. All rights ...
-
编辑 删除
Recovery from the Loss of the Primary Control File
1,根据备库创建主库控制文件 ALTER DATABASE BACKUP CONTROLFILE TO TRACE NORESETLOGS;2,关闭主库，启动到nomount,把上步生成的控制文件脚本，运行3，open主库4,主库切换日志，测试重作应用是否传递且...
-
编辑 删除
Recovery from Loss of Datafiles on the Standby
Recovery from Loss of Datafiles on the Standby DatabaseTo recover the standby database after the loss of one or moredatafiles, you must restore the lost files to the standby database fromthe backu...
-
编辑 删除
oracle10g_rman_backup recovery area_相关备纪
在9i中oracle引入flashback查询，依赖于undo表空间存储的信息来闪回查询以前的版本，当然这个受限于undo表空间的大小，以及保留策略。在10g中oracle又引入了新的flashback功能，使用了flash recovery area来存储flas...
-
编辑 删除
oracle10g data guard(dg)__flashback_physical database
1,在主库配置备库log_archive_dest_state_2=defer；再还原enable时，备库出现不应用日志； 测试主库添删数据文件及表空间提示报错，在alert中2,处理以上方法在主库生成备份控制文件,根据alert进行修改，把在备...
-
编辑 删除
manage logical standby database
1,The DBA_LOGSTDBY_EVENTS view record interesting events that occurred during the operation of SQL Apply. By default, the view records the most recent 100 events. However, you can change the number of...
-
编辑 删除
如何调优物理备库的重作日志应用速率_redo apply_dg_data guard
1,开启备库并行恢复（为备库主机cpu的2倍）2,配置备库db_block_checking=false(注：主库须为true);备库会有损失数据的风险哟3,主备库 PARALLEL_EXECUTION_MESSAGE_SIZE = 4096,须重启主备库 此行...
-
编辑 删除
主库历经open resetlogs后，如何redo apply 物理备库_flashback physical standby db
Flashing Back a Physical Standby Database to a Specific Point-in-TimeThe following steps describe how to avoid re-creating a physical standby database after you issued the OPEN RESETLOGS statement o...
-
编辑 删除
oracle10g data guard(dg)__Adding or Dropping Online Redo Log Files
Consequently, when you add or drop an online redo log file at theprimary site, it is important that you synchronize the changes in thestandby database by following these steps:If Redo Apply is run...
-
编辑 删除
oracle10g data guard(dg)__主库重命名数据文件_在备库上同步重命名数据文件
Renaming a Datafile in the Primary DatabaseWhen you rename one or more datafiles in the primary database, thechange is not propagated to the standby database. Therefore, if youwant to rename the s...
