3.手动归档，查看主备库告警日志 SYS@PROD>alter system archive log current;
System altered. --------------------------------------------------------------------------------------------------------------- 主库告警日志： LNS1 started with pid=55, OS id=3972 Sat Mar 29 16:29:54 2014 Thread 1 advanced to log sequence 32 Current log# 5 seq# 32 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo05.log Current log# 5 seq# 32 mem# 1: /u01/app/oracle/oradata/PROD/Disk2/redo05_1.log Sat Mar 29 16:29:56 2014 LNS: Standby redo logfile selected for thread 1 sequence 32 for destination LOG_ARCHIVE_DEST_2 Sat Mar 29 16:29:58 2014 ARC7: Standby redo logfile selected for thread 1 sequence 31 for destination LOG_ARCHIVE_DEST_2
备库告警日志： Sat Mar 29 16:29:55 2014 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[2]: Assigned to RFS process 8613 RFS[2]: Identified database type as 'physical standby' Primary database is in MAXIMUM PERFORMANCE mode Primary database is in MAXIMUM PERFORMANCE mode RFS[2]: Successfully opened standby log 7: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby07.log' Sat Mar 29 16:29:57 2014 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[3]: Assigned to RFS process 8615 RFS[3]: Identified database type as 'physical standby' RFS[3]: Successfully opened standby log 6: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby06.log' --------------------------------------------------------------------------------------------------------------- 4,在主库验证是否有新的表空间和数据文件
SYS@PROD>select name from v$datafile;
NAME --------------------------------------------------------------------------------------------------------------- /u01/app/oracle/oradata/PROD/Disk1/system01.dbf /u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf /u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf /u01/app/oracle/oradata/PROD/Disk1/example01.dbf /u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf /u01/app/oracle/oradata/PROD/Disk1/users01.dbf
6 rows selected.
5，在备库验证是否有新的表空间和数据文件
SYS@PRODSTD>select name from v$datafile;
NAME ---------------------------------------------------------------------------------------- /u01/app/oracle/oradata/PRODSTD/Disk1/system01.dbf /u01/app/oracle/oradata/PRODSTD/Disk1/undotbs01.dbf /u01/app/oracle/oradata/PRODSTD/Disk1/sysaux01.dbf /u01/app/oracle/oradata/PRODSTD/Disk1/example01.dbf /u01/app/oracle/oradata/PRODSTD/Disk1/PRODSTD/datafile/o1_mf_swtich_t_9m21f1f0_.dbf /u01/app/oracle/oradata/PRODSTD/Disk1/users01.dbf
6 rows selected.
8.3.1.2 When STANDBY_FILE_MANAGEMENT Is Set to MANUAL
8.3.1.2 当STANDBY_FILE_MANAGEMENT设置为MANUAL时This section shows how to add a new datafile to the primary and standby database when the STANDBY_FILE_MANAGEMENT initialization parameter is set to MANUAL. You must set the STANDBY_FILE_MANAGEMENT initialization parameter to MANUAL when the standby datafiles reside on raw devices. This section also describes how to recover from errors after they have occurred.
这个部分展示的是添加一个新的数据文件到主库，而备库的STANDBY_FILE_MANAGEMENT参数设置为MAUNAL，当备库的数据文件放在裸设备时，你必须将STANDBY_FILE_MANAGEMENT初始化参数设置为MANUAL。这部分也描述怎么恢复遇到的错误。
Note:
Do not use the following procedure with databases that use Oracle Managed Files. Also, if the raw device path names are not the same on the primary and standby servers, use the DB_FILE_NAME_CON