#acl merlyn:read,write All:read <> = Restore RAC database to different client = == Envirenment == * Master Server: nbumaster (NBU Appliance 5230, 7.6.0.1) * RAC node1: mls-rac01 (OEL6.7, Oracle database 11.2.0.4) * Destination Client: rac-restore (OEL6.7, Oracle database 11.2.0.4) * DBID=920906249 == requirements == I. Successful Netbackup backup of set. I. Same version of database. I. Record Source DBID/DATAFILE/TABLESPACE. I. Install database software only on Destination client. I. Install Netbackup client software on Destination client. {{{ SQL> select name from v$datafile; Press Return to Continue NAME ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ +EAS_DATA/easdb/datafile/system.256.943035169 +EAS_DATA/easdb/datafile/sysaux.257.943035169 +EAS_DATA/easdb/datafile/undotbs1.258.943035169 +EAS_DATA/easdb/datafile/users.259.943035169 +EAS_DATA/easdb/datafile/undotbs2.264.943035365 +EAS_DATA/easdb/datafile/eas_d_mls2015db_index.268.945306733 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.270.945306749 +EAS_DATA/easdb/datafile/eas_d_mls2015db_temp2.279.945306769 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.269.945306785 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.272.945306829 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.273.945307171 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.274.945307197 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.275.945307213 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.276.945307231 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.277.945307251 +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.281.945307259 +EAS_DATA/easdb/datafile/eas_d_mls2015db_index.280.945307301 +EAS_DATA/easdb/datafile/mls_d_mlsmid_standard.278.945360691 +EAS_DATA/easdb/datafile/eas_d_eas8_index.261.945083521 +EAS_DATA/easdb/datafile/eas_d_eas8_standard.266.945083533 +EAS_DATA/easdb/datafile/eas_d_eas8_temp2.265.945083541 +EAS_DATA/easdb/datafile/mls_d_dsp1_standard.283.945362643 22 rows selected. SQL> select name from v$tempfile; Press Return to Continue NAME ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ +EAS_DATA/easdb/tempfile/temp.263.943035277 +EAS_DATA/easdb/tempfile/eas_t_mls2015db_standard.271.945306775 +EAS_DATA/easdb/tempfile/eas_t_eas8_standard.262.945085313 +EAS_DATA/easdb/tempfile/mls_t_mlsmid_standard.282.945360745 +EAS_DATA/easdb/tempfile/mls_t_dsp1_standard.284.945362645 SQL> select name from v$controlfile; Press Return to Continue NAME ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ +EAS_DATA/easdb/controlfile/current.260.943035273 +CRS/easdb/controlfile/current.258.943637341 }}} === Master Server hosts file === nbumaster:/home/maintenance # tail -5 /etc/hosts {{{ 192.168.24.73 it003 it003 192.168.17.161 mls-rac01 192.168.17.162 mls-rac02 192.168.17.168 eas-new 192.168.17.169 rac-restore }}} === Client/Media Server === * Master&Media {{{ nbumaster:/home/maintenance # cat /usr/openv/netbackup/bp.conf SERVER = nbumaster SERVER = TEST_SEVER SERVER = opscenter CLIENT_NAME = nbumaster USE_VXSS = PROHIBITED VXSS_SERVICE_TYPE = INTEGRITYANDCONFIDENTIALITY EMMSERVER = nbumaster VXDBMS_NB_DATA = /usr/openv/db/data ENABLE_ROBUST_LOGGING = YES VERBOSE = 5 NETBACKUP_APPLIANCE_MODE = MANUAL_MASTER_APPLIANCE IP_ADDRESS_FAMILY = AF_UNSPEC VM_PROXY_SERVER = nbumaster OPS_CENTER_SERVER_NAME = TEST_SEVER OPS_CENTER_SERVER_NAME = opscenter TELEMETRY_UPLOAD = YES }}} * Source Client (mls-rac01) {{{ [oracle@mls-rac01 ~]$ cat /usr/openv/netbackup/bp.conf SERVER = nbumaster CLIENT_NAME = mls-rac01 CONNECT_OPTIONS = localhost 1 0 2 }}} * Destination Client (rac-restore) {{{ [root@rac-restore ~]# cat /usr/openv/netbackup/bp.conf SERVER = nbumaster CLIENT_NAME = rac-restore CONNECT_OPTIONS = localhost 1 0 2 }}} == Excute restore == === Create initEASDB.ora & orapwd file === copy pfile from Source client mls-rac02 OR create new one. {{{ EASDB.__db_cache_size=5737807872 EASDB.__java_pool_size=117440512 EASDB.__large_pool_size=134217728 EASDB.__pga_aggregate_target=3221225472 EASDB.__sga_target=7516192768 EASDB.__shared_io_pool_size=0 EASDB.__shared_pool_size=1308622848 EASDB.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/EASDB/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/rac-restore/EASDB/controlfile/ctrl_dEASDB.ctl' *.db_block_size=8192 *.db_create_file_dest='/rac-restore' *.db_domain='' *.db_name='EASDB' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=EASDBXDB)' *.log_archive_dest_1='LOCATION=/rac-restore/EASDB/arch' *.log_archive_format='arch_%t_%s_%r.arc' *.open_cursors=300 *.pga_aggregate_target=3221225472 *.processes=300 *.remote_login_passwordfile='exclusive' *.sessions=335 *.sga_target=7516192768 *.undo_tablespace='UNDOTBS1' }}} {{{ [oracle@rac-restore dbs]$ orapwd password=Systec36 file=orapwEASDB [oracle@rac-restore dbs]$ ls hc_EASDB.dat initEASDB.ora initEASDB.ora.old init.ora orapwEASDB }}} === create directories === {{{ [root@rac-restore ]# mkdir -pv /rac-restore/EASDB/{controlfile,arch} [root@rac-restore ]# chown -Rv oracle:oinstall /rac-restore/EASDB/ [oracle@rac-restore dbs]$ mkdir -pv /u01/app/oracle/admin/EASDB/{adump,bdump,cdump,ddump,udump,pfile} mkdir: created directory `/u01/app/oracle/admin/EASDB' mkdir: created directory `/u01/app/oracle/admin/EASDB/adump' mkdir: created directory `/u01/app/oracle/admin/EASDB/bdump' mkdir: created directory `/u01/app/oracle/admin/EASDB/cdump' mkdir: created directory `/u01/app/oracle/admin/EASDB/ddump' mkdir: created directory `/u01/app/oracle/admin/EASDB/udump' mkdir: created directory `/u01/app/oracle/admin/EASDB/pfile' }}} === restore controlfile === * find out correct controlfile in Netbackup /usr/openv/netbackup/bin/bplist -S nbumaster -C mls-rac02 -t 4 -l -R / | tee nbu_backups20170704_mls-rac02.txt {{{ export ORACLE_SID=EASDB rman target / nocatalog RMAN> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initEASDB.ora'; RMAN> set DBID=920906249 run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; # 07-02 2:00 #restore controlfile from '/ctrl_dEASDB_um5s8a6ll_s1733_p1_t948247221'; # 06-30 21:05 restore controlfile from '/ctrl_dEASDB_ukps84cjs_s1689_p1_t948056700'; # 06-29 22:18 # restore controlfile from '/ctrl_dEASDB_uj7s81sie_s1639_p1_t947974734'; RELEASE CHANNEL ch00; } RMAN> startup mount }}} * output {{{ run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; restore controlfile from '/ctrl_dEASDB_u09s8ehds_s9_p1_t948389308'; RELEASE CHANNEL ch00; 6> } allocated channel: ch00 channel ch00: SID=122 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2013111313) sent command to channel: ch00 Starting restore at 04-7月 -2017 16:08:44 channel ch00: restoring control file channel ch00: restore complete, elapsed time: 00:00:15 output file name=/rac-restore/EASDB/controlfile/ctrl_dEASDB.ctl Finished restore at 04-7月 -2017 16:08:59 released channel: ch00 RMAN> startup mount; database is already started database mounted }}} === restore database by UNTIL TIME === Following is the very important script that one can use to check the recoverability of the DB. {{{ spool log to rman_restore-EASDB-preview.log set echo on show all; report schema; list backup summary; list backup; list copy; run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac01'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; #set UNTIL TIME "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; SET UNTIL TIME "to_date('2017-07-01:17:00:00','YYYY-MM-DD:HH24:MI:SS')"; restore database preview; restore database validate; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; } spool log off }}} {{{ RMAN> spool log to rman_restore-EASDB-v1.log set echo on run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; set UNTIL TIME "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; restore database; restore archivelog all; recover database; RELEASE CHANNEL ch00; } spool log off }}} ==== recover database by UNTIL TIME ==== {{{ RMAN > spool log to rman_recover-EASDB-v1.log set echo on run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; set UNTIL TIME "to_date('2017-06-29 18:00:00','YYYY-MM-DD HH24:MI:SS')"; recover database; RELEASE CHANNEL ch00; } spool log off }}} {{{ run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; #set UNTIL TIME "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; restore datafile 2; RELEASE CHANNEL ch00; } }}} ==== restore archivelog by UNTIL TIME ==== {{{ RMAN > list backup of archivelog time between "to_date('2017-06-29 17:00:00','YYYY-MM-DD HH24:MI:SS')" and "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; }}} {{{ spool log to rman_v1.log set echo on run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac01'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; #set UNTIL TIME "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; #restore validate database archivelog from sequence 33171; #RESTORE VALIDATE CHECK LOGICAL ARCHIVELOG from sequence 33171; restore archivelog from logseq 30013 until logseq 30019 thread=1; restore archivelog from logseq 33161 until logseq 33169 thread=2; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; } spool log off }}} {{{ spool log to rman_v1.log set echo on RMAN> run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; set UNTIL TIME "to_date('2017-07-01 17:00:00','YYYY-MM-DD HH24:MI:SS')"; set until sequence 30024 thread 1; recover database; #restore validate database archivelog all; #restore validate archivelog all; #restore archivelog from time "TRUNC(sysdate)" until time "sysdate"; #restore validate archivelog from scn 31231 until scn 33225; #restore validate archivelog from scn 31178 until scn 33171; RELEASE CHANNEL ch00; } spool log off }}} {{{ archived log file name=/rac-restore/EASDB/arch/arch_1_45_948384202.arc thread=1 sequence=45 unable to find archived log archived log thread=1 sequence=46 released channel: ch00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/04/2017 16:20:36 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 46 and starting SCN of 1025994 run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; 3> SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; 4> RESTORE ARCHIVELOG FROM SEQUENCE 46; 5> RELEASE CHANNEL ch00; 6> } allocated channel: ch00 channel ch00: SID=122 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2013111313) sent command to channel: ch00 Starting restore at 04-7月 -2017 16:24:53 released channel: ch00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 07/04/2017 16:24:53 RMAN-20242: specification does not match any archived log in the repository }}} https://www.veritas.com/support/en_US/article.000021590 {{{ RMAN> run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; #restore controlfile from '/ctrl_dEASDB_u09s8ehds_s9_p1_t948389308'; restore controlfile from '/ctrl_dEASDB_u0is8epih_s18_p1_t948397649'; RELEASE CHANNEL ch00; }}} === Open database === {{{ export ORACLE_SID=EASDB; sqlplus / as sysdba SQL> recover database until cancel using backup controlfile; ===> CANCEL SQL> alter database open resetlogs; Database altered. SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ EASDB OPEN SQL> create spfile from pfile; }}} == NBU restore script == * recovery catalog (if used). At the rman command prompt, enter the following: {{{ crosscheck backupset of database; }}} Use restore ... validate when you want RMAN to choose the backups to test. NetBackup 7.7.1 AdministratorGuide => 131 to 138 pages https://www.veritas.com/support/en_US/article.HOWTO64200 1. Make sure you have installed Oracle with the same user as used on the original source client machine 2. Install NetBackup Client and Oracle agent 3. Patch if needed 4. Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions 5. Browse the Oracle backups by running /usr/openv/netbackup/bin/bplist -S - C -t 4 -l -R / => Make sure you can browse the backups 6. Restore the control file (in NOMOUNT mode) - See exact steps for this procedure in technote HOWTO63971 {{{ => SQL> STARTUP NOMOUNT pfile='/u01/xxx.ora' rman nocatalog => RMAN> connect target => RMAN> SET DBID=XXXXXX RMAN> restore controlfile from '/tmp/xxx'; }}} 7. Restore the database (in MOUNT mode) {{{ RMAN> mount database 8. Restore the database using the script in /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh {{{ SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS; ALTER DATABASE RENAME FILE '/old/location' TO '/new/location'; SQL> select log_mode from v$database; SQL> select name from v$datafile; SQL> select member from v$logfile; SQL> select name from v$tempfile; SQL> select name from v$controlfile; }}} * SQL> SELECT NAME,FILE#,STATUS FROM V$DATAFILE; {{{ RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'; SEND 'NB_ORA_SERV=, NB_ORA_CLIENT=’; set newname for datafile 1 to '/data/lsdb/datafile/system01.dbf' set newname for datafile 2 to '/data/lsdb/datafile/sysaux01.dbf' RESTORE DATABASE; RECOVER DATABASE; sql 'alter database open resetlogs'; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; } }}} = Troubleshooting = == ORA-01152: file 1 was not restored from a sufficiently old backup == {{{ ORA-01152: file 3 was not restored from a sufficiently old backup This means your controlfile and datafile are not synchronized. your controlfile is older and datafile 3 is newer. Why you restore controlfile? if you have latest controlfile available then restore it then restore backup and then try to recover database. Make sure that all archived log file are available to recover database. }}} NetBackup 7.7.1 AdministratorGuide => 208 pages /usr/openv/netbackup/logs/user_ops UNIX: /usr/openv/netbackup/logs/dbclient/log.mmddyy The debug logs are located in /usr/openv/netbackup/logs . {{{ To set the debug level on a UNIX client Enter the following line in the bp.conf file. VERBOSE = X Where X is the debug level you want. }}} == Modifying the maxjobs for "NBU_POLICY" == * Info nbrb (pid=3037) Limit has been reached for the logical resource .NBU_POLICY.MAXJOBS. you can chage that form your Policy attributes but do make sure that it will not effect the other jobs... if you increase value there may be a possiblity that other polices run out of resources for backups.. its you need to make sure that ,chaning this value will not impact the other jobs to get the resources.. {{{ Select the Policy in the GUI and adjust Limit Jobs per Policy }}} == Restore & Recover LOGS == {{{ Spooling started in log file: rman_restore-EASDB-v3.log Recovery Manager11.2.0.4.0 RMAN> echo set on RMAN> run { 2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; 3> SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; 4> restore database; 5> recover database; 6> RELEASE CHANNEL ch00; 7> } allocated channel: ch00 channel ch00: SID=122 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2013111313) sent command to channel: ch00 Starting restore at 06-7月 -2017 01:02:30 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00003 to +EAS_DATA/easdb/datafile/undotbs1.258.943035169 channel ch00: reading from backup piece bk_dEASDB_uj8s847r9_s1640_p1_t948051817 channel ch00: piece handle=bk_dEASDB_uj8s847r9_s1640_p1_t948051817 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:05:05 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00009 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.269.945306785 channel ch00: reading from backup piece bk_dEASDB_uj9s84855_s1641_p1_t948052133 channel ch00: piece handle=bk_dEASDB_uj9s84855_s1641_p1_t948052133 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:45 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00013 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.275.945307213 channel ch00: reading from backup piece bk_dEASDB_ujas848e2_s1642_p1_t948052418 channel ch00: piece handle=bk_dEASDB_ujas848e2_s1642_p1_t948052418 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:56 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00014 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.276.945307231 channel ch00: reading from backup piece bk_dEASDB_ujbs848mv_s1643_p1_t948052703 channel ch00: piece handle=bk_dEASDB_ujbs848mv_s1643_p1_t948052703 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00010 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.272.945306829 channel ch00: reading from backup piece bk_dEASDB_ujcs848vt_s1644_p1_t948052989 channel ch00: piece handle=bk_dEASDB_ujcs848vt_s1644_p1_t948052989 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:25 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00012 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.274.945307197 channel ch00: reading from backup piece bk_dEASDB_ujds8498g_s1645_p1_t948053264 channel ch00: piece handle=bk_dEASDB_ujds8498g_s1645_p1_t948053264 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00011 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.273.945307171 channel ch00: reading from backup piece bk_dEASDB_ujes849hd_s1646_p1_t948053549 channel ch00: piece handle=bk_dEASDB_ujes849hd_s1646_p1_t948053549 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00007 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.270.945306749 channel ch00: reading from backup piece bk_dEASDB_ujfs849pm_s1647_p1_t948053814 channel ch00: piece handle=bk_dEASDB_ujfs849pm_s1647_p1_t948053814 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:45 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00015 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.277.945307251 channel ch00: reading from backup piece bk_dEASDB_ujgs84a1v_s1648_p1_t948054079 channel ch00: piece handle=bk_dEASDB_ujgs84a1v_s1648_p1_t948054079 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00016 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_standard.281.945307259 channel ch00: reading from backup piece bk_dEASDB_ujhs84aa9_s1649_p1_t948054345 channel ch00: piece handle=bk_dEASDB_ujhs84aa9_s1649_p1_t948054345 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:46 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00006 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_index.268.945306733 channel ch00: reading from backup piece bk_dEASDB_ujis84aj6_s1650_p1_t948054630 channel ch00: piece handle=bk_dEASDB_ujis84aj6_s1650_p1_t948054630 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:04:25 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00017 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_index.280.945307301 channel ch00: reading from backup piece bk_dEASDB_ujjs84ar5_s1651_p1_t948054885 channel ch00: piece handle=bk_dEASDB_ujjs84ar5_s1651_p1_t948054885 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:03:45 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00005 to +EAS_DATA/easdb/datafile/undotbs2.264.943035365 channel ch00: reading from backup piece bk_dEASDB_ujks84b1s_s1652_p1_t948055100 channel ch00: piece handle=bk_dEASDB_ujks84b1s_s1652_p1_t948055100 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:01:25 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00002 to +EAS_DATA/easdb/datafile/sysaux.257.943035169 channel ch00: reading from backup piece bk_dEASDB_ujls84b4r_s1653_p1_t948055195 channel ch00: piece handle=bk_dEASDB_ujls84b4r_s1653_p1_t948055195 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:01:15 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00020 to +EAS_DATA/easdb/datafile/eas_d_eas8_standard.266.945083533 channel ch00: reading from backup piece bk_dEASDB_ujms84b6t_s1654_p1_t948055261 channel ch00: piece handle=bk_dEASDB_ujms84b6t_s1654_p1_t948055261 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00001 to +EAS_DATA/easdb/datafile/system.256.943035169 channel ch00: reading from backup piece bk_dEASDB_ujns84b8k_s1655_p1_t948055316 channel ch00: piece handle=bk_dEASDB_ujns84b8k_s1655_p1_t948055316 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00008 to +EAS_DATA/easdb/datafile/eas_d_mls2015db_temp2.279.945306769 channel ch00: reading from backup piece bk_dEASDB_ujos84ba1_s1656_p1_t948055361 channel ch00: piece handle=bk_dEASDB_ujos84ba1_s1656_p1_t948055361 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:35 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00019 to +EAS_DATA/easdb/datafile/eas_d_eas8_index.261.945083521 channel ch00: reading from backup piece bk_dEASDB_ujps84bbe_s1657_p1_t948055406 channel ch00: piece handle=bk_dEASDB_ujps84bbe_s1657_p1_t948055406 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:15 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00021 to +EAS_DATA/easdb/datafile/eas_d_eas8_temp2.265.945083541 channel ch00: reading from backup piece bk_dEASDB_ujqs84bch_s1658_p1_t948055441 channel ch00: piece handle=bk_dEASDB_ujqs84bch_s1658_p1_t948055441 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:15 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00018 to +EAS_DATA/easdb/datafile/mls_d_mlsmid_standard.278.945360691 channel ch00: reading from backup piece bk_dEASDB_ujss84ber_s1660_p1_t948055515 channel ch00: piece handle=bk_dEASDB_ujss84ber_s1660_p1_t948055515 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:07 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00022 to +EAS_DATA/easdb/datafile/mls_d_dsp1_standard.283.945362643 channel ch00: reading from backup piece bk_dEASDB_ujts84bfk_s1661_p1_t948055540 channel ch00: piece handle=bk_dEASDB_ujts84bfk_s1661_p1_t948055540 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:07 channel ch00: starting datafile backup set restore channel ch00: specifying datafile(s) to restore from backup set channel ch00: restoring datafile 00004 to +EAS_DATA/easdb/datafile/users.259.943035169 channel ch00: reading from backup piece bk_dEASDB_ujus84bh1_s1662_p1_t948055585 channel ch00: piece handle=bk_dEASDB_ujus84bh1_s1662_p1_t948055585 tag=TAG20170630T194337 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:07 Finished restore at 06-7月 -2017 02:03:03 Starting recover at 06-7月 -2017 02:03:03 starting media recovery Oracle Error: ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/rac-restore/EASDB/datafile/o1_mf_system_dotbc725_.dbf' released channel: ch00 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 07/06/2017 02:03:06 RMAN-06053: unable to perform media recovery because of missing log RMAN-06025: no backup of archived log for thread 2 with sequence 33171 and starting SCN of 16689609185 found to restore RMAN-06025: no backup of archived log for thread 2 with sequence 33170 and starting SCN of 16689566652 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 30022 and starting SCN of 16689655939 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 30021 and starting SCN of 16689654014 found to restore RMAN-06025: no backup of archived log for thread 1 with sequence 30020 and starting SCN of 16689566649 found to restore RMAN> spool log off }}} {{{ SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01152: 文件 1 没有从过旧的备份中还原 ORA-01110: 数据文件 1: '/rac-restore/EASDB/datafile/o1_mf_system_dotbc725_.dbf' SQL> !oerr ora 01152 01152, 00000, "file %s was not restored from a sufficiently old backup " // *Cause: An incomplete recovery session was started, but an insufficient // number of logs were applied to make the database consistent. This // file is still in the future of the last log applied. The most // likely cause of this error is forgetting to restore the file // from a backup before doing incomplete recovery. // *Action: Either apply more logs until the database is consistent or // restore the database file from an older backup and repeat recovery. }}} {{{ RMAN> list archivelog all; list archivelog all; List of Archived Log Copies for database with db_unique_name EASDB ===================================================================== Key Thrd Seq S Low Time ------- ---- ------- - --------------------- 58482 1 30020 A 30-6月 -2017 20:47:25 Name: +EAS_ARCH/easdb/archivelog/2017_06_30/thread_1_seq_30020.1934.948056333 58483 1 30021 A 30-6月 -2017 20:58:53 Name: +EAS_ARCH/easdb/archivelog/2017_06_30/thread_1_seq_30021.953.948056337 58485 1 30022 A 30-6月 -2017 20:58:57 Name: +EAS_ARCH/easdb/archivelog/2017_06_30/thread_1_seq_30022.515.948056509 58481 2 33170 A 30-6月 -2017 20:47:25 Name: +EAS_ARCH/easdb/archivelog/2017_06_30/thread_2_seq_33170.1261.948056047 58484 2 33171 A 30-6月 -2017 20:54:06 Name: +EAS_ARCH/easdb/archivelog/2017_06_30/thread_2_seq_33171.1911.948056413 RMAN> list backup of archivelog sequence 30020 thread 1; list backup of archivelog sequence 30020 thread 1; specification does not match any backup in the repository }}} {{{ run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; restore archivelog from logseq 33161 until logseq 33169 thread 2; RELEASE CHANNEL ch00; } }}} {{{ run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; restore archivelog from logseq 30013 until logseq 30019 thread 1; RELEASE CHANNEL ch00; } }}} {{{ SQL> recover database until cancel using backup controlfile; ORA-00279: 更改 16688849813 (在 06/30/2017 19:43:38 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33153_943035275.arc ORA-00280: 更改 16688849813 (用于线程 2) 在序列 #33153 中 Specify log: {=suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log '/rac-restore/EASDB/arch/arch_2_33153_943035275.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-00308: cannot open archived log '/rac-restore/EASDB/arch/arch_2_33153_943035275.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/rac-restore/EASDB/datafile/o1_mf_system_dovdgn9l_.dbf' SQL> select * from v$log where SEQUENCE#='33153'; no rows selected }}} {{{ run { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; SEND 'NB_ORA_SERV=nbumaster, NB_ORA_CLIENT=mls-rac02'; restore archivelog logseq 33153 thread 2; restore archivelog logseq 30005 thread 1; restore archivelog logseq 30006 thread 1; restore archivelog from logseq 30001 until logseq 30019 thread=1; restore archivelog from logseq 33000 until logseq 33169 thread=2; RELEASE CHANNEL ch00; RELEASE CHANNEL ch01; RELEASE CHANNEL ch02; RELEASE CHANNEL ch03; } allocated channel: ch00 channel ch00: SID=122 device type=SBT_TAPE channel ch00: Veritas NetBackup for Oracle - Release 7.6 (2013111313) sent command to channel: ch00 Starting restore at 06-7月 -2017 12:01:52 channel ch00: starting archived log restore to default destination channel ch00: restoring archived log archived log thread=2 sequence=33153 channel ch00: reading from backup piece arch_dEASDB_ukns84chd_s1687_p1_t948056621 channel ch00: piece handle=arch_dEASDB_ukns84chd_s1687_p1_t948056621 tag=TAG20170630T204727 channel ch00: restored backup piece 1 channel ch00: restore complete, elapsed time: 00:00:35 Finished restore at 06-7月 -2017 12:02:29 released channel: ch00 }}} {{{ Specify log: {=suggested | filename | AUTO | CANCEL} +EAS_ARCH/easdb/archivelog/2019_03_08/thread_2_seq_75145.257.1002374107 ORA-00279: ��� 144459150216 (�� 02/25/2019 11:31:47 ���) �����߳� 2 �DZ���� ORA-00289: ����: +EAS_ARCH ORA-00280: ��� 144459150216 (�����߳� 2) ������ #75146 �� ORA-00278: �˻ָ�������Ҫ��־�ļ� '+EAS_ARCH/easdb/archivelog/2019_03_08/thread_2_seq_75145.257.1002374107' Specify log: {=suggested | filename | AUTO | CANCEL} CANCEL Media recovery cancelled. }}} Then Database open normal!!! {{{ SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01152: 文件 1 没有从过旧的备份中还原 ORA-01110: 数据文件 1: '/rac-restore/EASDB/datafile/o1_mf_system_dovdgn9l_.dbf' SQL> recover database until cancel using backup controlfile; ORA-00279: 更改 16688961842 (在 06/30/2017 19:54:10 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30008_943035275.arc ORA-00280: 更改 16688961842 (用于线程 1) 在序列 #30008 中 Specify log: {=suggested | filename | AUTO | CANCEL} auto ORA-00279: 更改 16688961842 (在 06/30/2017 19:50:11 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33155_943035275.arc ORA-00280: 更改 16688961842 (用于线程 2) 在序列 #33155 中 ORA-00279: 更改 16688969496 (在 06/30/2017 19:55:09 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33156_943035275.arc ORA-00280: 更改 16688969496 (用于线程 2) 在序列 #33156 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33155_943035275.arc' ORA-00279: 更改 16689017975 (在 06/30/2017 19:58:18 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30009_943035275.arc ORA-00280: 更改 16689017975 (用于线程 1) 在序列 #30009 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30008_943035275.arc' ORA-00279: 更改 16689019180 (在 06/30/2017 19:58:24 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33157_943035275.arc ORA-00280: 更改 16689019180 (用于线程 2) 在序列 #33157 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33156_943035275.arc' ORA-00279: 更改 16689036239 (在 06/30/2017 20:00:05 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33158_943035275.arc ORA-00280: 更改 16689036239 (用于线程 2) 在序列 #33158 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33157_943035275.arc' ORA-00279: 更改 16689038966 (在 06/30/2017 20:00:12 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30010_943035275.arc ORA-00280: 更改 16689038966 (用于线程 1) 在序列 #30010 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30009_943035275.arc' ORA-00279: 更改 16689058869 (在 06/30/2017 20:01:50 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33159_943035275.arc ORA-00280: 更改 16689058869 (用于线程 2) 在序列 #33159 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33158_943035275.arc' ORA-00279: 更改 16689072470 (在 06/30/2017 20:02:23 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30011_943035275.arc ORA-00280: 更改 16689072470 (用于线程 1) 在序列 #30011 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30010_943035275.arc' ORA-00279: 更改 16689124031 (在 06/30/2017 20:05:42 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30012_943035275.arc ORA-00280: 更改 16689124031 (用于线程 1) 在序列 #30012 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30011_943035275.arc' ORA-00279: 更改 16689125267 (在 06/30/2017 20:05:45 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33160_943035275.arc ORA-00280: 更改 16689125267 (用于线程 2) 在序列 #33160 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33159_943035275.arc' ORA-00279: 更改 16689171808 (在 06/30/2017 20:09:13 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33161_943035275.arc ORA-00280: 更改 16689171808 (用于线程 2) 在序列 #33161 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33160_943035275.arc' ORA-00279: 更改 16689186881 (在 06/30/2017 20:12:01 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30013_943035275.arc ORA-00280: 更改 16689186881 (用于线程 1) 在序列 #30013 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30012_943035275.arc' ORA-00279: 更改 16689190432 (在 06/30/2017 20:12:43 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33162_943035275.arc ORA-00280: 更改 16689190432 (用于线程 2) 在序列 #33162 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33161_943035275.arc' ORA-00279: 更改 16689277590 (在 06/30/2017 20:19:26 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30014_943035275.arc ORA-00280: 更改 16689277590 (用于线程 1) 在序列 #30014 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30013_943035275.arc' ORA-00279: 更改 16689279641 (在 06/30/2017 20:19:56 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33163_943035275.arc ORA-00280: 更改 16689279641 (用于线程 2) 在序列 #33163 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33162_943035275.arc' ORA-00279: 更改 16689365643 (在 06/30/2017 20:26:31 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33164_943035275.arc ORA-00280: 更改 16689365643 (用于线程 2) 在序列 #33164 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33163_943035275.arc' ORA-00279: 更改 16689376783 (在 06/30/2017 20:29:08 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30015_943035275.arc ORA-00280: 更改 16689376783 (用于线程 1) 在序列 #30015 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30014_943035275.arc' ORA-00279: 更改 16689415457 (在 06/30/2017 20:31:03 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30016_943035275.arc ORA-00280: 更改 16689415457 (用于线程 1) 在序列 #30016 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30015_943035275.arc' ORA-00279: 更改 16689416211 (在 06/30/2017 20:31:11 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33165_943035275.arc ORA-00280: 更改 16689416211 (用于线程 2) 在序列 #33165 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33164_943035275.arc' ORA-00279: 更改 16689464374 (在 06/30/2017 20:36:32 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30017_943035275.arc ORA-00280: 更改 16689464374 (用于线程 1) 在序列 #30017 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30016_943035275.arc' BP Key: 1682 Status: AVAILABLE Compressed: NO Tag: TAG20170630T204727 Handle: arch_dEASDB_ukns84chd_s1687_p1_t948056621 Media: @aaaag List of Archived Logs in backup set 1682 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------------------- ---------- --------- 1 30005 16688830396 30-6月 -2017 19:41:43 16688854322 30-6月 -2017 19:44:54 2 33153 16688834231 30-6月 -2017 19:41:52 16688859961 30-6月 -2017 19:45:12 1 30006 16688854322 30-6月 -2017 19:44:54 16688915262 30-6月 -2017 19:49:26 2 33154 16688859961 30-6月 -2017 19:45:12 16688917421 30-6月 -2017 19:50:11 1 30007 16688915262 30-6月 -2017 19:49:26 16688961842 30-6月 -2017 19:54:10 archived log thread=2 sequence=33109 channel ch00: restoring archived log archived log thread=2 sequence=33110 ORA-00279: 更改 16689468168 (在 06/30/2017 20:37:14 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33166_943035275.arc ORA-00280: 更改 16689468168 (用于线程 2) 在序列 #33166 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33165_943035275.arc' ORA-00279: 更改 16689469255 (在 06/30/2017 20:37:15 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33167_943035275.arc ORA-00280: 更改 16689469255 (用于线程 2) 在序列 #33167 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33166_943035275.arc' ORA-00279: 更改 16689513199 (在 06/30/2017 20:42:30 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30018_943035275.arc ORA-00280: 更改 16689513199 (用于线程 1) 在序列 #30018 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30017_943035275.arc' ORA-00279: 更改 16689519577 (在 06/30/2017 20:43:24 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33168_943035275.arc ORA-00280: 更改 16689519577 (用于线程 2) 在序列 #33168 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33167_943035275.arc' ORA-00279: 更改 16689566404 (在 06/30/2017 20:47:17 生成) 对于线程 2 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_2_33169_943035275.arc ORA-00280: 更改 16689566404 (用于线程 2) 在序列 #33169 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_2_33168_943035275.arc' ORA-00279: 更改 16689566586 (在 06/30/2017 20:47:19 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30019_943035275.arc ORA-00280: 更改 16689566586 (用于线程 1) 在序列 #30019 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30018_943035275.arc' ORA-00279: 更改 16689566649 (在 06/30/2017 20:47:25 生成) 对于线程 1 是必需的 ORA-00289: 建议: /rac-restore/EASDB/arch/arch_1_30020_943035275.arc ORA-00280: 更改 16689566649 (用于线程 1) 在序列 #30020 中 ORA-00278: 此恢复不再需要日志文件 '/rac-restore/EASDB/arch/arch_1_30019_943035275.arc' ORA-00308: cannot open archived log '/rac-restore/EASDB/arch/arch_1_30020_943035275.arc' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 SQL> alter database open resetlogs; Database altered. SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ EASDB OPEN SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ EASDB OPEN }}}