ALTER DATABASE open Resetlogs when the output of alert

Source: Internet
Author: User

sql> ALTER DATABASE open resetlogs;

Database altered.
When you are prompted:


ORA-279 signalled During:alter DATABASE RECOVER datafile 5 ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed:alter DATABASE RECOVER CANCEL
Sat APR 18 18:41:33 2015
ALTER DATABASE open Resetlogs
ORA-1139 signalled during:alter database open resetlogs ...
Sat APR 18 18:42:06 2015
ALTER database RECOVER database until cancel
Media Recovery Start
Started Logmerger process
Parallel Media Recovery started with 4 slaves
Sat APR 18 18:42:06 2015
Warning:datafile 5 (/U01/APP/ORACLE/ORADATA/TEST/TEN01.DBF) is offline during full database recovery and would not be reco Vered
Media Recovery not Required
Completed:alter database RECOVER database until cancel
Sat APR 18 18:42:23 2015
ALTER DATABASE open Resetlogs
Resetlogs after complete recovery through change 3580552
Archived Log entry added for thread 1 sequence 155 ID 0x7d875fb4 dest 1:
Resetting resetlogs activation ID 2106023860 (0X7D875FB4)
Sat APR 18 18:42:28 2015
Setting recovery target incarnation to 3
Sat APR 18 18:42:28 2015
assigning activation ID 2175494118 (0x81ab67e6)
Lgwr:starting ARCH PROCESSES
Sat APR 18 18:42:28 2015
ARC0 started with pid=20, OS id=3826
Arc0:archival started
Lgwr:starting ARCH PROCESSES Complete
Arc0:starting ARCH PROCESSES
Sat APR 18 18:42:29 2015
ARC1 started with pid=21, OS id=3828
Sat APR 18 18:42:29 2015
ARC2 started with pid=22, OS id=3830
Sat APR 18 18:42:29 2015
ARC3 started with pid=23, OS id=3832
Arc1:archival started
Arc2:archival started
Arc3:archival started
Arc0:starting ARCH PROCESSES Complete
Arc0:becoming the ' no FAL ' ARCH
Arc0:becoming the ' no SRL ' ARCH
Arc1:becoming the Heartbeat ARCH
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0:/u01/app/oracle/oradata/test/redo01.log
Successful open of Redo thread 1
MTTR advisory is disabled because fast_start_mttr_target are not set
Sat APR 18 18:42:29 2015
Smon:enabling Cache Recovery
[3781] successfully onlined Undo tablespace 2.
Undo initialization finished serial:0 start:11031024 end:11032224 diff:1200 (seconds)
Dictionary Check Beginning
File #5 is offline, and is part of the online tablespace.
Data file 5: '/U01/APP/ORACLE/ORADATA/TEST/TEN01.DBF '
File #12 is offline, and is part of the online tablespace.
Data file: '/U01/APP/ORACLE/ORADATA/TEST/TEST.DBF '
Dictionary Check Complete
Verifying file header compatibility for 11g tablespace encryption:
Verifying 11g file Header compatibility for tablespace encryption completed
smon:enabling TX Recovery
Database Characterset is ZHS16GBK
No Resource Manager Plan Active
Sat APR 18 18:42:33 2015
Replication_dependency_tracking turned off (no async multimaster replication found)
Starting background Process QMNC
Sat APR 18 18:42:37 2015
QMNC started with pid=24, OS id=3834
Logstdby:validating Controlfile with logical metadata
Logstdby:validation Complete
Sat APR 18 18:42:50 2015
Completed:alter Database Open Resetlogs
Sat APR 18 18:42:50 2015
Starting background Process CJQ0
Sat APR 18 18:42:50 2015
CJQ0 started with pid=27, OS id=3854
Sat APR 18 18:42:51 2015
Checker Run found 2 new persistent data failures

ALTER DATABASE open Resetlogs when the output of alert

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.