Rman 0级别备份和恢复

最新推荐文章于 2024-04-07 22:32:28 发布

cizhaorun3127

最新推荐文章于 2024-04-07 22:32:28 发布

阅读量375

点赞数

文章标签：数据库网络

点击(此处)折叠或打开

1.删除备份
RMAN> delete backup;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=131 devtype=DISK
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
3 3 1 1 AVAILABLE DISK /backup/YWS_4.dbf
4 4 1 1 AVAILABLE DISK /backup/YWS_0.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/backup/YWS_4.dbf recid=3 stamp=832767718
deleted backup piece
backup piece handle=/backup/YWS_0.dbf recid=4 stamp=832767926
Deleted 2 objects
2.0级别全备
RMAN> backup incremental level 0 database format \'/backup/%s_%f.dbf\';
Starting backup at 29-NOV-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/oracle/oradata/yws/system01.dbf
input datafile fno=00003 name=/u01/oracle/oradata/yws/sysaux01.dbf
input datafile fno=00005 name=/u01/oracle/oradata/yws/example01.dbf
input datafile fno=00002 name=/u01/oracle/oradata/yws/undotbs01.dbf
input datafile fno=00004 name=/u01/oracle/oradata/yws/users01.dbf
channel ORA_DISK_1: starting piece 1 at 29-NOV-13
channel ORA_DISK_1: finished piece 1 at 29-NOV-13
piece handle=/backup/5_4.dbf tag=TAG20131129T122643 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 29-NOV-13
channel ORA_DISK_1: finished piece 1 at 29-NOV-13
piece handle=/backup/6_0.dbf tag=TAG20131129T122643 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 29-NOV-13
3.查看备份
RMAN> LIST BACKUP OF CONTROLFILE;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
Piece Name: /backup/6_0.dbf
Control File Included: Ckp SCN: 482504 Ckp time: 29-NOV-13
RMAN> LIST BACKUP OF SPFILE;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
Piece Name: /backup/6_0.dbf
SPFILE Included: Modification time: 29-NOV-13
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Incr 0 577.39M DISK 00:00:41 29-NOV-13
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
Piece Name: /backup/5_4.dbf
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/system01.dbf
2 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/undotbs01.dbf
3 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/sysaux01.dbf
4 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/users01.dbf
5 0 Incr 482473 29-NOV-13 /u01/oracle/oradata/yws/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Incr 0 6.80M DISK 00:00:03 29-NOV-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20131129T122643
Piece Name: /backup/6_0.dbf
Control File Included: Ckp SCN: 482504 Ckp time: 29-NOV-13
SPFILE Included: Modification time: 29-NOV-13
4.删除文件
[oracle@yws oracle]$ cd oradata/
[oracle@yws oradata]$ ls
yws
[oracle@yws oradata]$ cd yws/
[oracle@yws yws]$ ls
control01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
[oracle@yws yws]$ rm -rf *
[oracle@yws yws]$ ls
[oracle@yws yws]$ ls
[oracle@yws yws]$ pwd
/u01/oracle/oradata/yws
5.删除归档
RMAN> delete archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=131 devtype=DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 2 A 29-NOV-13 /arc/1_2_832764548.dbf
2 1 3 A 29-NOV-13 /arc/1_3_832764548.dbf
3 1 4 A 29-NOV-13 /arc/1_4_832764548.dbf
4 1 5 A 29-NOV-13 /arc/1_5_832764548.dbf
5 1 6 A 29-NOV-13 /arc/1_6_832764548.dbf
6 1 7 A 29-NOV-13 /arc/1_7_832764548.dbf
Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/arc/1_2_832764548.dbf recid=1 stamp=832768513
deleted archive log
archive log filename=/arc/1_3_832764548.dbf recid=2 stamp=832768513
deleted archive log
archive log filename=/arc/1_4_832764548.dbf recid=3 stamp=832768518
deleted archive log
archive log filename=/arc/1_5_832764548.dbf recid=4 stamp=832768569
deleted archive log
archive log filename=/arc/1_6_832764548.dbf recid=5 stamp=832768575
deleted archive log
archive log filename=/arc/1_7_832764548.dbf recid=6 stamp=832768583
Deleted 6 objects
6.启动数据库
[oracle@yws arc]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 29 12:46:59 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 79693392 bytes
Database Buffers 201326592 bytes
Redo Buffers 2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info --报找不到控制文件
7.恢复控制文件
RMAN> restore controlfile from \'/backup/6_0.dbf\';
Starting restore at 29-NOV-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:05
output filename=/u01/oracle/oradata/yws/control01.ctl
output filename=/u01/oracle/oradata/yws/control02.ctl
output filename=/u01/oracle/oradata/yws/control03.ctl
Finished restore at 29-NOV-13
8.数据库起到mount
SQL> alter database mount;
Database altered.
9.查看相关信息
SQL> select checkpoint_change#,fuzzy from v$datafile_header;
CHECKPOINT_CHANGE# FUZ
------------------ ---
482473 NO
482473 NO
482473 NO
482473 NO
482473 NO
SQL> select CHECKPOINT_CHANGE#,OPEN_RESETLOGS,ARCHIVE_CHANGE# from v$database;
CHECKPOINT_CHANGE# OPEN_RESETL ARCHIVE_CHANGE#
------------------ ----------- ---------------
479088 REQUIRED 0
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 2 52428800 1 NO CURRENT 474499 29-NOV-13
3 1 1 52428800 1 YES INACTIVE 446075 29-NOV-13
2 1 0 52428800 1 YES UNUSED 0
10.恢复库
RMAN> restore database;
Starting restore at 29-NOV-13
released channel: ORA_DISK_1
Starting implicit crosscheck backup at 29-NOV-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 29-NOV-13
Starting implicit crosscheck copy at 29-NOV-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-NOV-13
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/oradata/yws/system01.dbf
restoring datafile 00002 to /u01/oracle/oradata/yws/undotbs01.dbf
restoring datafile 00003 to /u01/oracle/oradata/yws/sysaux01.dbf
restoring datafile 00004 to /u01/oracle/oradata/yws/users01.dbf
restoring datafile 00005 to /u01/oracle/oradata/yws/example01.dbf
channel ORA_DISK_1: reading from backup piece /backup/5_4.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/backup/5_4.dbf tag=TAG20131129T122643
channel ORA_DISK_1: restore complete, elapsed time: 00:00:57
Finished restore at 29-NOV-13
RMAN> recover database;
Starting recover at 29-NOV-13
using channel ORA_DISK_1
starting media recovery
unable to find archive log
archive log thread=1 sequence=2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/29/2013 12:53:18
RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 482473 --报错
11.查看记录
[oracle@yws yws]$ ls
control01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf
12.打开数据库
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
SQL> select status from v$datafile;
STATUS
-------
SYSTEM
ONLINE
ONLINE
ONLINE
ONLINE
SQL> select checkpoint_change#,fuzzy from v$datafile_header;
CHECKPOINT_CHANGE# FUZ
------------------ ---
482475 YES
482475 YES
482475 YES
482475 YES
482475 YES
SQL> select CHECKPOINT_CHANGE#,OPEN_RESETLOGS,ARCHIVE_CHANGE# from v$database;
CHECKPOINT_CHANGE# OPEN_RESETL ARCHIVE_CHANGE#
------------------ ----------- ---------------
482475 NOT ALLOWED 0
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 1 52428800 1 NO CURRENT 482474 29-NOV-13
2 1 0 52428800 1 YES UNUSED 0
3 1 0 52428800 1 YES UNUSED 0
看告警
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 71303168
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 285212672
control_files = /u01/oracle/oradata/yws/control01.ctl, /u01/oracle/oradata/yws/control02.ctl, /u01/oracle/oradata/yws/control03.ctl
db_block_size = 8192
__db_cache_size = 201326592
compatible = 10.2.0.1.0
log_archive_dest_1 = location=/arc
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=ywsXDB)
job_queue_processes = 10
background_dump_dest = /u01/oracle/admin/yws/bdump
user_dump_dest = /u01/oracle/admin/yws/udump
core_dump_dest = /u01/oracle/admin/yws/cdump
audit_file_dest = /u01/oracle/admin/yws/adump
db_name = yws
open_cursors = 300
pga_aggregate_target = 94371840
PMON started with pid=2, OS id=22552
PSP0 started with pid=3, OS id=22554
MMAN started with pid=4, OS id=22556
DBW0 started with pid=5, OS id=22558
LGWR started with pid=6, OS id=22560
CKPT started with pid=7, OS id=22562
SMON started with pid=8, OS id=22564
RECO started with pid=9, OS id=22566
CJQ0 started with pid=10, OS id=22568
MMON started with pid=11, OS id=22570
MMNL started with pid=12, OS id=22572
Fri Nov 29 12:48:42 2013
starting up 1 dispatcher(s) for network address \'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\'...
starting up 1 shared server(s) ...
Fri Nov 29 12:48:42 2013
Fri Nov 29 12:48:42 2013
starting up 1 dispatcher(s) for network address \'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))\'...
starting up 1 shared server(s) ...
Fri Nov 29 12:48:42 2013
ALTER DATABASE MOUNT
Fri Nov 29 12:48:42 2013
ORA-00202: control file: \'/u01/oracle/oradata/yws/control01.ctl\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:48:45 2013
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Nov 29 12:51:09 2013
alter database mount
Fri Nov 29 12:51:13 2013
Setting recovery target incarnation to 2
Fri Nov 29 12:51:13 2013
Successful mount of redo thread 1, with mount id 4198944637
Fri Nov 29 12:51:13 2013
Database mounted in Exclusive Mode
Completed: alter database mount
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: \'/u01/oracle/oradata/yws/system01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: \'/u01/oracle/oradata/yws/undotbs01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: \'/u01/oracle/oradata/yws/sysaux01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: \'/u01/oracle/oradata/yws/users01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: \'/u01/oracle/oradata/yws/example01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: \'/u01/oracle/oradata/yws/system01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: \'/u01/oracle/oradata/yws/undotbs01.dbf\'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u01/oracle/oradata/yws/sysaux01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/oracle/oradata/yws/users01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 2: '/u01/oracle/oradata/yws/undotbs01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u01/oracle/oradata/yws/sysaux01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/oracle/oradata/yws/users01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:48 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u01/oracle/oradata/yws/example01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 12:51:51 2013
Full restore complete of datafile 4 /u01/oracle/oradata/yws/users01.dbf. Elapsed time: 0:00:00
checkpoint is 482473
Full restore complete of datafile 2 /u01/oracle/oradata/yws/undotbs01.dbf. Elapsed time: 0:00:04
checkpoint is 482473
Fri Nov 29 12:52:06 2013
Full restore complete of datafile 5 /u01/oracle/oradata/yws/example01.dbf. Elapsed time: 0:00:14
checkpoint is 482473
Fri Nov 29 12:52:18 2013
Full restore complete of datafile 3 /u01/oracle/oradata/yws/sysaux01.dbf. Elapsed time: 0:00:28
checkpoint is 482473
Fri Nov 29 12:52:35 2013
Full restore complete of datafile 1 /u01/oracle/oradata/yws/system01.dbf. Elapsed time: 0:00:44
checkpoint is 482473
Fri Nov 29 12:53:15 2013
alter database recover datafile list clear
Fri Nov 29 12:53:15 2013
Completed: alter database recover datafile list clear
Fri Nov 29 12:53:15 2013
alter database recover datafile list
1 , 2 , 3 , 4 , 5
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5
Fri Nov 29 12:53:15 2013
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
ORA-279 signalled during: alter database recover if needed
start until cancel using backup controlfile
...
Fri Nov 29 12:53:16 2013
alter database recover cancel
Fri Nov 29 12:53:18 2013
Media Recovery Canceled
Completed: alter database recover cancel
Fri Nov 29 13:03:45 2013
db_recovery_file_dest_size of 2048 MB is 0.00% 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.
Fri Nov 29 13:09:25 2013
alter database open
Fri Nov 29 13:09:25 2013
ORA-1589 signalled during: alter database open...
Fri Nov 29 13:09:45 2013
alter database open noresetlogs
Fri Nov 29 13:09:45 2013
ORA-1588 signalled during: alter database open noresetlogs...
Fri Nov 29 13:09:58 2013
alter database open resetlogs
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:09:58 2013
RESETLOGS after incomplete recovery UNTIL CHANGE 482473
Resetting resetlogs activation ID 4198903106 (0xfa462d42)
Fri Nov 29 13:09:58 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oracle/oradata/yws/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:10:00 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/oracle/oradata/yws/redo02.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:10:02 2013
Errors in file /u01/oracle/admin/yws/udump/yws_ora_22577.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/yws/redo03.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:10:04 2013
Setting recovery target incarnation to 3
Fri Nov 29 13:10:04 2013
Assigning activation ID 4198944637 (0xfa46cf7d)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=19, OS id=23381
ARC1 started with pid=20, OS id=23383
Fri Nov 29 13:10:05 2013
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Fri Nov 29 13:10:05 2013
ARC0: STARTING ARCH PROCESSES
Fri Nov 29 13:10:05 2013
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Fri Nov 29 13:10:05 2013
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/oracle/oradata/yws/redo01.log
Successful open of redo thread 1
Fri Nov 29 13:10:05 2013
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=21, OS id=23385
Fri Nov 29 13:10:05 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Nov 29 13:10:05 2013
SMON: enabling cache recovery
Fri Nov 29 13:10:08 2013
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Nov 29 13:10:08 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/oracle/oradata/yws/temp01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:10:08 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ARC2: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
ARC2 started with pid=21, OS id=23385
Fri Nov 29 13:10:05 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Nov 29 13:10:05 2013
SMON: enabling cache recovery
Fri Nov 29 13:10:08 2013
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Fri Nov 29 13:10:08 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/oracle/oradata/yws/temp01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Fri Nov 29 13:10:08 2013
Errors in file /u01/oracle/admin/yws/bdump/yws_dbw0_22558.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/oracle/oradata/yws/temp01.dbf'
Fri Nov 29 13:10:08 2013
File 201 not verified due to error ORA-01157
Fri Nov 29 13:10:08 2013
Dictionary check complete
Fri Nov 29 13:10:08 2013
SMON: enabling tx recovery
Fri Nov 29 13:10:08 2013
Re-creating tempfile /u01/oracle/oradata/yws/temp01.dbf
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=22, OS id=23401
Fri Nov 29 13:10:15 2013
LOGSTDBY: Validating controlfile with logical metadata
Fri Nov 29 13:10:15 2013
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Fri Nov 29 13:16:05 2013
Shutting down archive processes
Fri Nov 29 13:16:10 2013
ARCH shutting down
ARC2: Archival stopped