05 2022 档案
摘要：查看建表语句： select dbms_metadata.get_ddl('TABLE','TEST_SQL','TEST') from dual; DBMS_METADATA.GET_DDL('TABLE','TEST_SQL','TEST') CREATE TABLE "TEST"."TEST_
阅读全文
摘要：select trunc(completion_time) as "Date", count(*) as "Count", (sum(blocks * block_size))/1024/1024 as "MB" from v$archived_log group by trunc(completi
阅读全文
摘要：目标库： [oracle@oracle11g ~]$ mkdir -p /u01/app/oracle/oradata/orcl [oracle@oracle11g ~]$ mkdir -p /u01/app/oracle/admin/orcl/{a,dp}dump [oracle@oracle11
阅读全文
摘要：原库： 192.168.162.199 node01 目标库： 192.168.162.200 oracle11g 目标库： [oracle@oracle11g dbs]$ vi ~/.bash_profile export PATH export ORACLE_BASE=/u01/app/orac
阅读全文
摘要：[oracle@rac01 ~]$ srvctl stop database -d racdb [oracle@rac01 ~]$ srvctl status database -d racdb 实例 racdb1 没有在 rac01 节点上运行 实例 racdb2 没有在 rac02 节点上运行
阅读全文
摘要：一、模拟产生GAP 1.备库停止DG同步进程： SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/archive Oldest onl
阅读全文
摘要：开启归档： SQL> host mkdir -p /home/oracle/archivelog SQL> alter system set db_recovery_file_dest_size=5G; System altered. SQL> alter system set db_recover
阅读全文
