oracle8i&9i standby 文件同步命令.txt

alter database create datafile '/data/umlaut/log_data42.dbf' as '/data/umlaut/log_data42.dbf' size 2000m;

alter database create datafile '/data/umlaut/temp04.dbf' as '/data/umlaut/temp04.dbf';(datafile&tempfile--->datafile)

SQL> alter database create datafile 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00018' as 'E:\DT2ESD\BASE_IDX03.DBF';

SQL> alter database create datafile 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\UNNAMED00019' as 'E:\DT2ESD\WIP_DATA01.DBF';

E:\DT2ESD\WIP_DATA01.DBF

alter database create datafile 'E:\DT2ESD\BASE_IDX03.DBF' as 'E:\DT2ESD\BASE_IDX03.DBF' size 2000m;

oracle_awr_procedure.txt
$sqlplus / as sysdba
sql>exec dbms_workload_repository.create_snapshot(flush_level=>'ALL');
sql>exec dbms_workload_repository.create_snapshot(flush_level=>'ALL');
sql>@?/rdbms/admin/awrrpt.sql;

standby_tempfile_add.txt

SQL>STARTUP NOMOUNT;
SQL>ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> alter database tempfile '/u01/product/oradata/delll6/temp01.dbf' drop;
SQL>ALTER DATABASE OPEN READ ONLY;
SQL> alter tablespace temp add tempfile '/u01/product/oradata/delll10/temp01.dbf' size 2000m;
or
SQL> alter tablespace temp add tempfile '/u01/product/oradata/delll10/temp01.dbf' size 2000m reuse;