incremental restore (alert.log)

backup incremental level 0/1 database;

restore/recover database;

alter database mount
Tue Mar 20 11:39:45 2007
Setting recovery target incarnation to 4
Tue Mar 20 11:39:45 2007
Successful mount of redo thread 1, with mount id 1823524860
Tue Mar 20 11:39:45 2007
Database mounted in Exclusive Mode
Completed: alter database mount
Tue Mar 20 11:40:07 2007
Incremental restore complete of datafile 4 /u01/app/oracle/oradata/grid/users01.dbf
checkpoint is 162851652
Incremental restore complete of datafile 2 /u01/app/oracle/oradata/grid/undotbs01.dbf
checkpoint is 162851652
Incremental restore complete of datafile 1 /u01/app/oracle/oradata/grid/system01.dbf
checkpoint is 162851652
Incremental restore complete of datafile 3 /u01/app/oracle/oradata/grid/sysaux01.dbf
checkpoint is 162851652
Tue Mar 20 11:40:51 2007
Incremental restore complete of datafile 4 /u01/app/oracle/oradata/grid/users01.dbf
checkpoint is 162869589
Tue Mar 20 11:41:38 2007
Incremental restore complete of datafile 2 /u01/app/oracle/oradata/grid/undotbs01.dbf
checkpoint is 162869589
Tue Mar 20 11:41:54 2007
Incremental restore complete of datafile 1 /u01/app/oracle/oradata/grid/system01.dbf
checkpoint is 162869589
Incremental restore complete of datafile 3 /u01/app/oracle/oradata/grid/sysaux01.dbf
checkpoint is 162869589
Tue Mar 20 11:41:58 2007
alter database recover datafile list clear
Tue Mar 20 11:41:58 2007
Completed: alter database recover datafile list clear
Tue Mar 20 11:41:58 2007
alter database recover datafile list
1 , 2 , 3 , 4
Completed: alter database recover datafile list
1 , 2 , 3 , 4
Tue Mar 20 11:41:58 2007
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
parallel recovery started with 3 processes
ORA-279 signalled during: alter database recover if needed
start until cancel using backup controlfile
...
Tue Mar 20 11:41:59 2007
alter database recover logfile '/u01/app/oracle/arch/1_1951_613397329.dbf'
Tue Mar 20 11:41:59 2007
Media Recovery Log /u01/app/oracle/arch/1_1951_613397329.dbf
ORA-279 signalled during: alter database recover logfile '/u01/app/oracle/arch/1_1951_613397329.dbf'...
Tue Mar 20 11:42:00 2007
alter database recover cancel
Tue Mar 20 11:42:01 2007
Media Recovery Canceled
Completed: alter database recover cancel
Tue Mar 20 11:42:35 2007
alter database open
Tue Mar 20 11:42:35 2007
ORA-1589 signalled during: alter database open...
Tue Mar 20 11:42:49 2007
alter database open resetlogs
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/grid/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/grid/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/grid/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/grid/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/grid/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:49 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/grid/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:50 2007
RESETLOGS after incomplete recovery UNTIL CHANGE 162870050
Resetting resetlogs activation ID 1819188917 (0x6c6e9eb5)
Tue Mar 20 11:42:50 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/grid/redo01.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:42:57 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/grid/redo02.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:43:05 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/grid/redo03.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:43:12 2007
Setting recovery target incarnation to 5
Tue Mar 20 11:43:12 2007
Assigning activation ID 1823524860 (0x6cb0c7fc)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=20, OS id=9715
Tue Mar 20 11:43:12 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=21, OS id=9717
Tue Mar 20 11:43:12 2007
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/grid/redo01.log
Successful open of redo thread 1
Tue Mar 20 11:43:12 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Mar 20 11:43:12 2007
ARC0: STARTING ARCH PROCESSES
Tue Mar 20 11:43:12 2007
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue Mar 20 11:43:12 2007
SMON: enabling cache recovery
Tue Mar 20 11:43:12 2007
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=22, OS id=9719
Tue Mar 20 11:43:13 2007
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Tue Mar 20 11:43:13 2007
Errors in file /u01/app/oracle/admin/grid/bdump/grid_dbw0_9410.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/grid/temp01.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Tue Mar 20 11:43:13 2007
Errors in file /u01/app/oracle/admin/grid/bdump/grid_dbw0_9410.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/grid/temp01.dbf'
Tue Mar 20 11:43:13 2007
File 201 not verified due to error ORA-01157
Tue Mar 20 11:43:13 2007
Dictionary check complete
Tue Mar 20 11:43:13 2007
SMON: enabling tx recovery
Tue Mar 20 11:43:13 2007
Re-creating tempfile /u01/app/oracle/oradata/grid/temp01.dbf
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=23, OS id=9721
Tue Mar 20 11:43:14 2007
LOGSTDBY: Validating controlfile with logical metadata
Tue Mar 20 11:43:14 2007
LOGSTDBY: Validation complete
Tue Mar 20 11:43:14 2007
db_recovery_file_dest_size of 2048 MB is 34.26% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Mar 20 11:43:15 2007
Starting control autobackup
Tue Mar 20 11:43:17 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
Tue Mar 20 11:43:17 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
Tue Mar 20 11:43:17 2007
Errors in file /u01/app/oracle/admin/grid/udump/grid_ora_9429.trc:
Control autobackup written to DISK device
handle '/u01/app/oracle/flash_recovery_area/GRID/autobackup/2007_03_20/o1_mf_s_617715795_2zyp2ng5_.bkp'
Completed: alter database open resetlogs