When you use alter database to move a data file, after you run the alter database rename {Tagshow (event, '% Ca % fd % be % DD % BF % e2 ');} "Href =" http://www.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self ">Database: Alter database open. Error: ORA-01113: file 7 media recovery required ORA-01110: data file 7 : 'e: oracle \ product \ 10.2.0 \ oradata \ orcl \ test01.dbf '
Tinkpad Laptop Double-click Development Q Disk no longer prompts to create a recovery media dialog box, and the folder is empty after entering the disk workaround
Tonight, almost a sleepless night ah, there are a lot of people on the Internet to reply, almost brother believe he sent to repair station maintenance.
Anyway
1. If you encounter the above situation, do not panic, after entering the Q-disk, cli
tablespace users online ';}-- RecoveredSQL> select * from t_user;TEXT--------------------Java _SQL> select name from v $ datafile where file # = 4;NAME--------------------------------------------------------------------------------/Oracle/10g/oracle/product/10.2.0/oradata/oralife/user01.dbfData Block Media recoveryIf some data blocks in the data file are damaged, use the blockrecover command to restore the damaged data blocks.For example:RMAN> blockr
Creating an OEM recovery media requires a larger space, with a 16G or more USB disk or a removable hard drive is recommended. (The Removable Storage device will be formatted, please back up the data in advance).
Create a recovery media step like the WIN8.1 created by the
Today I learned about Oracle backup while performing altertablespaceusersbeginbackup; then there is: Row 1st error: ORA-01123: unable to start online backup
Today I learned about Oracle backup after executing alter tablespace users begin backup; then there is: Row 1st error: ORA-01123: unable to start online backup
I learned about Oracle backup today.
Alter tablespace users begin backup is executed;
Then:
Row 3 has an error:ORA-01123: online backup cannot be started;
Today, a server opened the archive, resulting in a full file system, because we are a development library, no need to open the archive, so we changed the database to a non-archive mode, but at the time of the change encountered ora-01143:cannot disable Media recovery-file 20 Needs media recovery error. The data file wa
Environment: Oracle 121020In the Dataguard construction, encountered the ORA-01153 error, prompt as follows:Ora-01153:an incompatible Media recovery is activeAn incompatible media recovery is in progressThis problem is performed twice in succession sql> ALTER DATABASE recover managed standby database using current logf
recovery
ORA-01110: data file 7: 'e: Oracle/product/10.2.0/oradata/orcl/test01.dbf '.
This is because the database considers this data file to be damaged and needs to be usedRecoverCommandBackupAnd log information. Database Backup Recovery is a complex problem, but the solution for this instance is relatively simple.
Run the following command:
Recover datafile 'e: Oracle/product/10.2.0/oradata/orcl/test01.
ORA-16139: media recovery required error encountered during physical DG Master/Slave database switchover
SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-16139: media recovery required
Solution:
-- If the ORA-16139:
Two days ago, due to forced shutdown, data files in the database were damaged. One database cannot be started and the media needs to be restored. Follow the online method:
Login data: sqlplus "/as sysdba"
Disable data: shutdown immediate;
Then start the data: startup;
An error was reported during startup:
ORA-01113: File 1 requires media recovery
ORA-01110:
Case 1:recover Database (media fails, most data files are lost)
Solution: Need to do media recovery, first restore lost data files, and then recover database, from the library.
(1) Simulation environment
05:45:49 sql> SELECT * from test;
Id
----------
1
2
3
05:45:52 sql> INSERT INTO test values (4);
1 row created.
05:46:01 sql> commit;
Commit complete
1. Online Backup error:
sql> alter tablespace ZY begin backup;
Alter TABLESPACE users begin backup
*
ERROR at line 1:
Ora-01123:cannot Start online backup;media recovery not enabled
2. Find the cause of the error:Alter TABLESPACE XXX begin backup cannot be done in noarchive mode, and online backups can only be made in the Archivelog mode in which the database is located.
3. Look at the archiving situation:S
The organization assigned a ThinkPad sl400 27437mc, t5870/2g/250g/9300 m Gs, and the seller said that it could only run the Create Product Recovery media once and tried it, originally, the Registry was used to record whether a backup was performed.Import the following registry, and then burn the product recovery disk. I used 1cd + 2dvd to back up the system. Now
Corruption of online logs to be analyzed based on log status, online logs typically have three states of current, active, and inactive. Inactive status does not cause data loss. The log of active and current states generally results in loss of data. Judge the state of the corrupted log according to V$log.status.A. If the log in the inactive state is corrupted, drop the group log to be able. Because each thread must have at least two sets of logs, you should add a group before deleting it.B. In t
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.