Archive destination /u01/oracle/app/fast_recovery_area
alter system set log_archive_config='DG_CONFIG=(testdg1,orcl)' scope=spfile;
3.log_archive_dest_1 查看归档日志的目录位置
SELECT DEST_ID, DEST_NAME, STATUS, DESTINATION FROM V$ARCHIVE_DEST where DEST_ID = 1;
alter system set log_archive_dest_1='LOCATION=/u01/oracle/app/product/11.2.0/dbhome_1/dbs/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=oradg1' scope=both;
alter system set log_archive_dest_2='SERVICE=orcl LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' scope=spfile;
7、db_file_name_convert 查找数据文件的位置
SQL> select name from v$datafile;
NAME
/u01/oracle/app/oradata/orcl/system01.dbf /u01/oracle/app/oradata/orcl/sysaux01.dbf /u01/oracle/app/oradata/orcl/undotbs01.dbf /u01/oracle/app/oradata/orcl/users01.dbf
8、log_file_name_convert 查看在线日志文件的位置：
SQL> select member from v$logfile;
MEMBER
/u01/oracle/app/oradata/orcl/redo03.log /u01/oracle/app/oradata/orcl/redo02.log /u01/oracle/app/oradata/orcl/redo01.log
查看正在使用的spfile
SELECT name, value FROM v$parameter WHERE name = 'spfile';
alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=uni_dg1' scope=both;
alter system set log_archive_dest_2='SERVICE=uni_dg2 LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=uni_dg2' scope=spfile;
SQL> select name from v$datafile;
NAME
/u01/app/oracle/oradata/orcl/system01.dbf /u01/app/oracle/oradata/orcl/sysaux01.dbf /u01/app/oracle/oradata/orcl/undotbs01.dbf /u01/app/oracle/oradata/orcl/users01.dbf
alter system set db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl' scope=spfile;
alter system set log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl' scope=spfile;
SQL> alter database add standby logfile group 4 '/u01/app/oracle/oradata/orcl/redo04.log' size 50M;
SQL> alter database add standby logfile group 5 '/u01/app/oracle/oradata/orcl/redo05.log' size 50M;
SQL> alter database add standby logfile group 6 '/u01/app/oracle/oradata/orcl/redo06.log' size 50M;
SQL> alter database add standby logfile group 7 '/u01/app/oracle/oradata/orcl/redo07.log' size 50M;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE 命令在Oracle数据库中用于启动或继续管理恢复（Managed Recovery）模式下的备用数据库（Standby Database）的日志应用（Log Apply）进程。此命令指示备用数据库使用当前可用的归档日志或重做传输服务（Redo Transport Services）传输的重做日志（Redo Logs）进行恢复。
