May be the cause of this error, to your account first:
(1) copy from other machines to DMP backup library (about 8 g) file size, the reduction in personal laptop (native), reduction for about 2 to 4 hours, finally also prompt reduction import a success, and even after the hangar other users deal with the problem is normal in business table, laptop after two days also shutdown (typically set to sleep), libraries also have use, no other anomalies were found,
(2) the NEXT day when using other Oracle user processing business, there is a prompt "ORA - 01658: unable to create the INITIAL segment of the USERS for the table space area", then searched for online automatic extension tablespace statement "the ALTER DATABASE datafile 'D: \ \ app \ \ Administrator \ \ oradata \ \ wouldn \ \ USERS01 DBF' autoextend ON NEXT 10 m maxsize unlimited;" The file path is right, isn't it using the double slash reason?
After execution is successful, also no longer prompt the USERS table space is a reminder of the works,
(3) later for other things, the computer restart, Oracle listening and services are starting to normal, but the database connection is not on, SYS could not connect,
Basic situation is like this, no other special operations, Oracle or computer
Because I at ordinary times to the operation of the Oracle will only some business development aspects, above or incorrect operation, search the Internet a lot, also tried a lot of online method, is still not solved,
Here, hope to get everybody to help, thank you,
(the following is a alter_orcl. Some screenshots of the log, hope useful for everyone,)

CodePudding user response:

You are no open successful database, how is it possible to visit?

CodePudding user response:

Three groups of redo log, there are questions, Mr Khoja don't get up,

CodePudding user response:

reference 1st floor xifenfei response:

you are not open successful database, how is it possible to visit?

Thank you for your reply first, how to solve the problem of the open now?

CodePudding user response:

refer to the second floor wmxcn2000 response:

three group of redo logs, have a problem, not Mr Khoja.

To say thank you
The moderator can give a solution

CodePudding user response:

To mount state, recover the database, and then try the _allow_resetlogs_corruption hidden parameters of recovery

CodePudding user response:

reference 5 floor jdsnhan reply:

to mount, recover the database, and then try the _allow_resetlogs_corruption hidden parameter recovery

Did not understand, can say specific point, how to operate

CodePudding user response:

refer to 6th floor zzxiaozhi response:

Quote: refer to the fifth floor jdsnhan reply:

To mount state, recover the database, and then try the _allow_resetlogs_corruption hidden parameter recovery

Did not understand, can say specific point, how to operate the

CodePudding user response:

refer to 7th floor zzxiaozhi response:

Quote: refer to the sixth floor zzxiaozhi response:

Quote: refer to the fifth floor jdsnhan reply:

To mount state, recover the database, and then try the _allow_resetlogs_corruption hidden parameter recovery

Did not understand, can say specific point, how to operate the

CodePudding user response:

Monitor and associated instance is not correct,

CodePudding user response:

To monitor distribution service? Former service such as the red box

CodePudding user response:

Redo damage
Use http://www.xifenfei.com/oracle_recovery_check to gather information, to send up to look at it

CodePudding user response:

Seems not to monitor the problem