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
- Successful Netbackup backup of set.
- Same version of database.
- Record Source DBID/DATAFILE/TABLESPACE.
- Install database software only on Destination client.
- 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 offRMAN>
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 offrun {
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 offspool 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 offarchived 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 repositoryhttps://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
- Make sure you have installed Oracle with the same user as used on the original source client machine
Install NetBackup Client and Oracle agent
- Patch if needed
Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions
Browse the Oracle backups by running /usr/openv/netbackup/bin/bplist -S <master server> - C <Oracle source client name> -t 4 -l -R /
=> Make sure you can browse the backups
- 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';
- 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=<master server>, NB_ORA_CLIENT=<Oracle source client name>’;
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 <Master server>.NBU_POLICY.MAXJOBS.<Policy name>
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 offSQL> 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 repositoryrun {
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: {<RET>=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 selectedrun {
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: ch00Specify log: {<RET>=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: {<RET>=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: {<RET>=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