创建dataguard -- 使用备份创建

之前创建dg 一直都是使用duplicate创建的。前几天同事项目上碰到个问题，带宽问题，不能使用duplicate创建，只能使用备份创建。 昨晚试了试，套路都一样。记录下。

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

RDBMS 11.2.0.3.0
Primary : PROD1
$ORACLE_BASE : /u01/app/oracle
$ORACLE_HOME : /u01/app/oracle/product/11.2.0/dbhome_1
Standby : SBDB1
$ORACLE_BASE : /u01/app/oracle
$ORACLE_HOME : /u01/app/oracle/product/11.2.0/dbhome_1

参考文档： https://docs.oracle.com/cd/E11882_01/server.112/e41134/create_ps.htm#SBYDB4724

步骤：
1 主库启用归档模式，及启用Force logging ，启用flashback on（如果不配置broker，可以不启用）。添加standby logfile
2 创建主库备库的参数文件
3 创建密码文件，也可以把主库的scp一份到备库，更改名称即可
4 创建备库的控制文件，并scp到备库
5 配置Listener.ora， TNSNAMES.ora
6 对主库进行部分，并将备份传输到备库机器上并注册。（这里不需要传，一个主机上）
7 根据之前创建的备库的spfile，备库控制文件，启动备库到mount状态，进行restore
8 应用日志

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- step 1

SYS@PROD1>archive log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     8Next log sequence to archive   10Current log sequence           10SYS@PROD1>select flashback_on from v$database;FLASHBACK_ON------------------NOSYS@PROD1>alter database flashback on;Database altered.SYS@PROD1>alter database force logging;Database altered.SYS@PROD1>select group#,bytes/1024/1024 from v$log;    GROUP# BYTES/1024/1024---------- ---------------         1              50         3              50         2              50SYS@PROD1>alter database add standby logfile group 4 '/u01/app/oracle/oradata/PROD1/stdby01.log' size 50M;Database altered.SYS@PROD1>alter database add standby logfile group 5 '/u01/app/oracle/oradata/PROD1/stdby02.log' size 50M;Database altered.SYS@PROD1>alter database add standby logfile group 6 '/u01/app/oracle/oradata/PROD1/stdby03.log' size 50M;Database altered.SYS@PROD1>alter database add standby logfile group 7 '/u01/app/oracle/oradata/PROD1/stdby04.log' size 50M;Database altered.SYS@PROD1>

-- step 2 ，创建主库备库的参数文件,主库和备库里面的PROD1和SBDB1 对调，但是DB_NAME要设置成PROD1 。

## create pfile form spfile;SYS@PROD1>create spfile from pfile='/home/oracle/pfile_prod1' ;File created.-- 编辑后，创建spfile，用spfile启动，并将备库的SYS@PROD1>shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SYS@PROD1>create pfile='/home/oracle/pfile_prod1' from spfile;[oracle@edbjr2p1 ~]$ ls p*pfile_prod1[oracle@edbjr2p1 ~]$ cp pfile_prod1 pfile_sbdb1/*PROD1.__db_cache_size=247463936PROD1.__java_pool_size=4194304PROD1.__large_pool_size=4194304PROD1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentPROD1.__pga_aggregate_target=251658240PROD1.__sga_target=377487360PROD1.__shared_io_pool_size=0PROD1.__shared_pool_size=113246208PROD1.__streams_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/PROD1/adump'*.audit_trail='db'*.compatible='11.2.0.0.0'*.control_files='/u01/app/oracle/oradata/PROD1/control01.ctl','/u01/app/oracle/oradata/PROD1/control02.ctl'*.db_block_size=8192*.db_domain='us.oracle.com'*.db_name='PROD1'*.db_recovery_file_dest_size=6442450944*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=PROD1XDB)'*.memory_max_target=629145600*.memory_target=629145600*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.sga_max_size=629145600*.undo_tablespace='UNDOTBS1'#DB_NAME=PROD1DB_UNIQUE_NAME=PROD1LOG_ARCHIVE_CONFIG='DG_CONFIG=(PROD1,SBDB1)'LOG_ARCHIVE_DEST_1= 'LOCATION=USE_DB_RECOVERY_FILE_DEST  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=PROD1'LOG_ARCHIVE_DEST_2= 'SERVICE=SBDB1 ASYNC  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=SBDB1'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLEREMOTE_LOGIN_PASSWORDFILE=EXCLUSIVELOG_ARCHIVE_FORMAT=%t_%s_%r.arc#FAL_SERVER=SBDB1DB_FILE_NAME_CONVERT='SBDB1','PROD1'LOG_FILE_NAME_CONVERT='SBDB1','PROD1' STANDBY_FILE_MANAGEMENT=AUTO---SBDB1.__db_cache_size=247463936SBDB1.__java_pool_size=4194304SBDB1.__large_pool_size=4194304SBDB1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentSBDB1.__pga_aggregate_target=251658240SBDB1.__sga_target=377487360SBDB1.__shared_io_pool_size=0SBDB1.__shared_pool_size=113246208SBDB1.__streams_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/SBDB1/adump'*.audit_trail='db'*.compatible='11.2.0.0.0'#*.control_files='/u01/app/oracle/oradata/SBDB1/control01.ctl','/u01/app/oracle/oradata/SBDB1/control02.ctl'*.control_files='/home/oracle/sbdb1.ctl'*.db_block_size=8192*.db_domain='us.oracle.com'*.db_name='PROD1'*.db_recovery_file_dest_size=6442450944*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=SBDB1XDB)'*.memory_max_target=629145600*.memory_target=629145600*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.sga_max_size=629145600*.undo_tablespace='UNDOTBS1'#DB_NAME=PROD1DB_UNIQUE_NAME=SBDB1LOG_ARCHIVE_CONFIG='DG_CONFIG=(SBDB1,PROD1)'LOG_ARCHIVE_DEST_1= 'LOCATION=USE_DB_RECOVERY_FILE_DEST  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=SBDB1'LOG_ARCHIVE_DEST_2= 'SERVICE=PROD1 ASYNC  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=PROD1'LOG_ARCHIVE_DEST_STATE_1=ENABLELOG_ARCHIVE_DEST_STATE_2=ENABLEREMOTE_LOGIN_PASSWORDFILE=EXCLUSIVELOG_ARCHIVE_FORMAT=%t_%s_%r.arc#FAL_SERVER=PROD1DB_FILE_NAME_CONVERT='PROD1','SBDB1'LOG_FILE_NAME_CONVERT='PROD1','SBDB1' STANDBY_FILE_MANAGEMENT=AUTO*//*SYS@SBDB1>startup nomount pfile='/home/oracle/pfile_sbdb1'ORACLE instance started.Total System Global Area  627732480 bytesFixed Size                  1346756 bytesVariable Size             373293884 bytesDatabase Buffers          247463936 bytesRedo Buffers                5627904 bytesSYS@SBDB1>create spfile from pfile='/home/oracle/pfile_sbdb1';File created.*/

-- step 3 ，略

-- step 4 ，创建备库的控制文件

SYS@PROD1>startup mount;ORACLE instance started.Total System Global Area  627732480 bytesFixed Size                  1346756 bytesVariable Size             373293884 bytesDatabase Buffers          247463936 bytesRedo Buffers                5627904 bytesDatabase mounted.SYS@PROD1>alter database create standby controlfile as '/home/oracle/sbdb1.ctl';Database altered.SYS@PROD1>alter database open;Database altered.SYS@PROD1>

-- step 5 ，配置监听器 ,并检验监听的连通性。

## restart listenerLSNRCTL> reloadConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edbjr2p1.example.com)(PORT=1521)))The command completed successfullyLSNRCTL> statusConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=edbjr2p1.example.com)(PORT=1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date                08-DEC-2017 20:10:51Uptime                    0 days 0 hr. 41 min. 57 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/oracle/diag/tnslsnr/edbjr2p1/listener/alert/log.xmlListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edbjr2p1.example.com)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Services Summary...Service "PROD1.us.oracle.com" has 1 instance(s).  Instance "PROD1", status UNKNOWN, has 1 handler(s) for this service...Service "SBDB1.us.oracle.com" has 1 instance(s).  Instance "SBDB1", status UNKNOWN, has 1 handler(s) for this service...Service "plsextproc" has 1 instance(s).  Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfullyLSNRCTL> ## vi tnsnames.ora/*LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = edbjr2p1.example.com)(PORT = 1521))      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))    )  )ADR_BASE_LISTENER = /u01/app/oracleSID_LIST_LISTENER=  (SID_LIST=    (SID_DESC=      (GLOBAL_DBNAME=PROD1.us.oracle.com)      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME=PROD1))     (SID_DESC=      (GLOBAL_DBNAME=SBDB1.us.oracle.com)      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME=SBDB1))      (SID_DESC=      (SID_NAME=plsextproc)      (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)      (PROGRAM=extproc)))  PROD1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = edbjr2p1.example.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = PROD1.us.oracle.com)    )  )SBDB1 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = edbjr2p1.example.com)(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = SBDB1.us.oracle.com)    )  )  */## tnsping [oracle@edbjr2p1 admin]$ tnsping sbdb1TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 08-DEC-2017 20:54:18Copyright (c) 1997, 2011, Oracle.  All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = edbjr2p1.example.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = SBDB1.us.oracle.com)))OK (0 msec)[oracle@edbjr2p1 admin]$ 

-- step 6， 对主库进行备份

[oracle@edbjr2p1 ~]$ export ORACLE_SID=PROD1[oracle@edbjr2p1 ~]$ rman target /Recovery Manager: Release 11.2.0.3.0 - Production on Fri Dec 8 21:05:55 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.connected to target database: PROD1 (DBID=2082231315)RMAN> backup format '/home/oracle/%U' database ;Starting backup at 08-DEC-17using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=19 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/PROD1/system01.dbfinput datafile file number=00002 name=/u01/app/oracle/oradata/PROD1/sysaux01.dbfinput datafile file number=00005 name=/u01/app/oracle/oradata/PROD1/example01.dbfinput datafile file number=00003 name=/u01/app/oracle/oradata/PROD1/undotbs01.dbfinput datafile file number=00004 name=/u01/app/oracle/oradata/PROD1/users01.dbfchannel ORA_DISK_1: starting piece 1 at 08-DEC-17channel ORA_DISK_1: finished piece 1 at 08-DEC-17piece handle=/home/oracle/01slkq9q_1_1 tag=TAG20171208T210810 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:05:47channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setincluding current control file in backup setincluding current SPFILE in backup setchannel ORA_DISK_1: starting piece 1 at 08-DEC-17channel ORA_DISK_1: finished piece 1 at 08-DEC-17piece handle=/home/oracle/02slkqkp_1_1 tag=TAG20171208T210810 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:12Finished backup at 08-DEC-17RMAN> RMAN> list backup of database;List of Backup Sets===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------1       Full    1.05G      DISK        00:05:44     08-DEC-17              BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20171208T210810        Piece Name: /home/oracle/01slkq9q_1_1  List of Datafiles in backup set 1  File LV Type Ckp SCN    Ckp Time  Name  ---- -- ---- ---------- --------- ----  1       Full 954749     08-DEC-17 /u01/app/oracle/oradata/PROD1/system01.dbf  2       Full 954749     08-DEC-17 /u01/app/oracle/oradata/PROD1/sysaux01.dbf  3       Full 954749     08-DEC-17 /u01/app/oracle/oradata/PROD1/undotbs01.dbf  4       Full 954749     08-DEC-17 /u01/app/oracle/oradata/PROD1/users01.dbf  5       Full 954749     08-DEC-17 /u01/app/oracle/oradata/PROD1/example01.dbfRMAN> 

-- step 7， 创建备库的文件夹，启动到mount状态下，进行还原

-- create directory[oracle@edbjr2p1 ~]$ mkdir -p /u01/app/oracle/admin/SBDB1/adump[oracle@edbjr2p1 ~]$ mkdir -p /u01/app/oracle/oradata/SBDB1[oracle@edbjr2p1 ~]$ -- startup nomountSYS@SBDB1>shutdown immediate;ORA-01507: database not mountedORACLE instance shut down.SYS@SBDB1>startup mount;ORACLE instance started.Total System Global Area  627732480 bytesFixed Size                  1346756 bytesVariable Size             373293884 bytesDatabase Buffers          247463936 bytesRedo Buffers                5627904 bytesDatabase mounted.SYS@SBDB1>--- 查看备份的文件，发现没有的，需要注册进去RMAN> list backup of database;using target database control file instead of recovery catalogspecification does not match any backup in the repositoryRMAN> restore database ;Starting restore at 08-DEC-17Starting implicit crosscheck backup at 08-DEC-17allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=14 device type=DISKFinished implicit crosscheck backup at 08-DEC-17Starting implicit crosscheck copy at 08-DEC-17using channel ORA_DISK_1Finished implicit crosscheck copy at 08-DEC-17searching for all files in the recovery areacataloging files...no files catalogedusing channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 12/08/2017 21:42:14RMAN-06026: some targets not found - aborting restoreRMAN-06023: no backup or copy of datafile 5 found to restoreRMAN-06023: no backup or copy of datafile 4 found to restoreRMAN-06023: no backup or copy of datafile 3 found to restoreRMAN-06023: no backup or copy of datafile 2 found to restoreRMAN-06023: no backup or copy of datafile 1 found to restoreRMAN> -- 把备份注册进去RMAN> catalog start with '/home/oracle/01slkq9q_1_1';searching for all files that match the pattern /home/oracle/01slkq9q_1_1List of Files Unknown to the Database=====================================File Name: /home/oracle/01slkq9q_1_1Do you really want to catalog the above files (enter YES or NO)? yescataloging files...cataloging doneList of Cataloged Files=======================File Name: /home/oracle/01slkq9q_1_1RMAN> catalog start with '/home/oracle/02slkqkp_1_1';searching for all files that match the pattern /home/oracle/02slkqkp_1_1List of Files Unknown to the Database=====================================File Name: /home/oracle/02slkqkp_1_1Do you really want to catalog the above files (enter YES or NO)? yescataloging files...cataloging doneList of Cataloged Files=======================File Name: /home/oracle/02slkqkp_1_1RMAN> -- 查看注册进去的备份RMAN> list backup of database;List of Backup Sets===================BS Key  Type LV Size       Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------1       Full    1.05G      DISK        00:00:00     08-DEC-17              BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20171208T210810        Piece Name: /home/oracle/01slkq9q_1_1  List of Datafiles in backup set 1  File LV Type Ckp SCN    Ckp Time  Name  ---- -- ---- ---------- --------- ----  1       Full 954749     08-DEC-17 /u01/app/oracle/oradata/SBDB1/system01.dbf  2       Full 954749     08-DEC-17 /u01/app/oracle/oradata/SBDB1/sysaux01.dbf  3       Full 954749     08-DEC-17 /u01/app/oracle/oradata/SBDB1/undotbs01.dbf  4       Full 954749     08-DEC-17 /u01/app/oracle/oradata/SBDB1/users01.dbf  5       Full 954749     08-DEC-17 /u01/app/oracle/oradata/SBDB1/example01.dbfRMAN> --进行还原RMAN> restore database;Starting restore at 08-DEC-17using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/SBDB1/system01.dbfchannel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/SBDB1/sysaux01.dbfchannel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/SBDB1/undotbs01.dbfchannel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/SBDB1/users01.dbfchannel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/SBDB1/example01.dbfchannel ORA_DISK_1: reading from backup piece /home/oracle/01slkq9q_1_1channel ORA_DISK_1: piece handle=/home/oracle/01slkq9q_1_1 tag=TAG20171208T210810channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:01:16Finished restore at 08-DEC-17RMAN> 

-- step 8 ，应用日志，略。

---  查看日志应用情况SYS@PROD1>select sequence#,applied from v$archived_log; SEQUENCE# APPLIED---------- ---------        10 NO        11 NO        12 NO        13 NOSYS@PROD1>/ SEQUENCE# APPLIED---------- ---------        10 NO        11 NO        12 NO        13 NOSYS@PROD1>/ SEQUENCE# APPLIED---------- ---------        10 NO        11 NO        12 NO        13 NO        12 YES        14 NO        14 YES        13 YES        15 NO        15 NO10 rows selected.SYS@PROD1>--  查看备库的归档SYS@SBDB1>startup mount;ORACLE instance started.Total System Global Area  627732480 bytesFixed Size                  1346756 bytesVariable Size             373293884 bytesDatabase Buffers          247463936 bytesRedo Buffers                5627904 bytesDatabase mounted.SYS@SBDB1>archive log listDatabase log mode              Archive ModeAutomatic archival             EnabledArchive destination            USE_DB_RECOVERY_FILE_DESTOldest online log sequence     14Next log sequence to archive   0Current log sequence           16SYS@SBDB1>

end

++++++++++++++++++

-- 附件几个错误，原因，passwordfile没有的。copy主库的到备库就可以了。

ARC2: Becoming the heartbeat ARCHARC2: Becoming the active heartbeat ARCHErrors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/SBDB1/redo01.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/SBDB1/redo01.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/SBDB1/redo02.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 2 of thread 1ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/SBDB1/redo02.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/SBDB1/redo03.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 3 of thread 1ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/SBDB1/redo03.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 4 of thread 0ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby01.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 4 of thread 0ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby01.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 5 of thread 0ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby02.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 5 of thread 0ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby02.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 6 of thread 0ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby03.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file :ORA-00313: open failed for members of log group 6 of thread 0ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby03.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 7 of thread 0ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby04.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Errors in file /u01/app/oracle/diag/rdbms/sbdb1/SBDB1/trace/SBDB1_lgwr_6766.trc:ORA-00313: open failed for members of log group 7 of thread 0ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/SBDB1/stdby04.log'ORA-27037: unable to obtain file statusLinux Error: 2: No such file or directoryAdditional information: 3Create Relation IPS_PACKAGE_UNPACK_HISTORYARC3: Archival startedARC0: STARTING ARCH PROCESSES COMPLETECompleted: ALTER DATABASE   MOUNTError 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are using a password fileand remote_login_passwordfile is set to SHARED or EXCLUSIVE, and that the SYS password is same in the password files.      returning error ORA-16191

--给备库增加控制文件。因为创建的时候，只有一个控制文件。在创建备库的时候，多创建几个控制文件也是可以的。创建过程略，语句如下：

alter system set control_files='/home/oracle/sbdb1.ctl','/u01/app/oracle/oradata/SBDB1/control02.ctl','/u01/app/oracle/oradata/SBDB1/control03.ctl' scope=spfile;

END