answersLogoWhite

0

What oracle will do in datafile media recovery?

User Avatar

Anonymous

 ∙ 12y ago
Updated: 8/17/2019

first of all ur database in mount mode....

and then enable archieve log and then check

User Avatar

Wiki User

 ∙ 12y ago

What else can I help you with?

Related Questions

What is the difference between database file and datafile?

Datafile is a group of files in each table space in an Oracle database. Database files are all files that are found within the database.

What is the purpose of a oracle recovery catalog?

to tell the future

How do you rellocate a datafile?

Alter tablespace is the command

What is the recovery time for otitis media?

The recovery time after having otitis media surgery is about 2 weeks. Another word for otitis media surgery is middle ear surgery.

How do you rename a datafile in Oracle?

â–º Rename a Datafile in Oracle(10g):-SQL> select name from v$datafile; NAME--------------------------------------------------------------------------------/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf8 rows selected.SQL> alter tablespace msb read only;Tablespace altered.SQL> select TABLESPACE_NAME, status from dba_tablespaces;TABLESPACE_NAME STATUS------------------------------ ---------SYSTEM ONLINEUNDOTBS1 ONLINESYSAUX ONLINETEMP ONLINEUSR01 ONLINEUSR02 ONLINETEMP01 ONLINEINNER ONLINEASM ONLINEMSB READ ONLYTEMPORARY ONLINETABLESPACE_NAME STATUS------------------------------ ---------TSPUNDO ONLINE12 rows selected.SQL> alter tablespace msb offline;Tablespace altered.============================================================Work on OS level:-[oracle@abab-YYY-XXX abab]$ CD /u01/app/oracle/product/10.2.0/oradata/nisi/[oracle@abab-YYY-XXX abab]$ lsasm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbfm123.dbf redo2.log system.dbf usr01.dbfredo3.log temporary.dbf usr02.dbf[oracle@abab-YYY-XXX abab]$ cp m123.dbf mmm.dbf[oracle@abab-YYY-XXX abab]$ lsasm01.dbf redo1.log sysaux.dbf undo.dbf usr04.dbfm123.dbf redo2.log system.dbf usr01.dbfmmm.dbf redo3.log temporary.dbf usr02.dbf[oracle@abab-YYY-XXX abab]$============================================================SQL> alter database rename file2 '/u01/app/oracle/product/10.2.0/oradata/abab/m123.dbf'3 to4 '/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf';Database altered.SQL> alter tablespace msb online;Tablespace altered.SQL> alter tablespace msb read write;Tablespace altered.SQL> select name, status from v$datafile;NAME STATUS------------------------------------------------------------ -------/u01/app/oracle/product/10.2.0/oradata/abab/system.dbf SYSTEM/u01/app/oracle/product/10.2.0/oradata/abab/undo.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/sysaux.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr01.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr02.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/asm01.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/usr04.dbf ONLINE/u01/app/oracle/product/10.2.0/oradata/abab/mmm.dbf ONLINE8 rows selected.

Where can you download Windows 8 pro recovery media?

places

What is a Checkpoint in oracle?

A checkpoint performs the following three operations:Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk. It's the DBWR that writes all modified databaseblocks back to the datafiles.The latest SCN is written (updated) into the datafile header.The latest SCN is also written to the controlfiles.The update of the datafile headers and the control files is done by the LGWR(CKPT if CKPT is enabled). As of version 8.0, CKPT is enabled by default.

What is Oracle Database Services?

Oracle Database support services. Data PatrolTech is a technology company in Pune that offers a range of IT services, including Oracle Database Services.These services involve managing and maintaining Oracle databases for businesses and organizations. Oracle Database Services typically include tasks such as installation, configuration, backup and recovery, performance tuning, security management, and troubleshooting.For information you visit our site.

Where to you go on a new vaio PC to create a recovery media kit?

Click START then ALL PROGRAMS then select VAIO RECOVERY

What is the industry average for Capital Expenditure?

http://people.stern.nyu.edu/adamodar/New_Home_Page/datafile/capex.html

What has the author Neil Webster written?

Neil Webster has written: 'DMU Datafile' 'European Locomotive Pocket Book' 'DMU and Light Rail Datafile' 'Locomotive Hauled Travel' 'European Loco Pocket Book' 'EMU Datafile' 'European Railways' 'Panchayati raj and the decentralisation of development planning in West Bengal' -- subject(s): Panchayat, Local government

What brand-name computers have hard drives that contain a partition that can be used to reinstall Windows. What is the name for this partition?

It's called the 'recovery' partition. Various manufacturers will put recovery partitions on certain computer models and not others. Many (older) models came with recovery CDs or DVDs. Newer models expect you to burn recovery media from the recovery partition so that you can recover a system on a new hard drive if the old one fails. You can also try downloading from the computer company web site and burn it to recovery media.

Trending Questions
What is the difference between an autocracy and a democracy? Where can you find a basic maintenance and chemical schedule for the small Easy-Set 12x30 pools? Why does your bearded dragon to turn brown when in the heat? How can one apply for a free or discounted handicap scooter? How can you tell when your girlfriend is ready for sex without her verbally telling you she is? Can radioactivity be canceled? What are Managerial Concerns particular to a Thesis? Multiplication factor pairs of 20 what are they? How much horse power can a car have before illegal? Where is the aux power point fuse location on a 2008 Ford Escape? Who funded hernan Cortes expedition? How far between what cities is 2400 Nautical Miles? ARE DONKEys faster than horses? Dictatorship taken place in Haiti from 1957 - 1987? What is the largest town in Derbyshire? Prizes or gifts that consumers receive when purchasing products are called? What did England import from American colonies? How is a drill a wheel and axle? Is it true that the substances in a heterogeneous mixture can usually be seen and are easily separated? How do you arrange substances in increasing order if you know their density and which substance sinks or floats in various liquids?

Resources

Leaderboard All Tags Unanswered

Top Categories

Algebra Chemistry Biology World History English Language Arts Psychology Computer Science Economics

Product

Community Guidelines Honor Code Flashcard Maker Study Guides Math Solver FAQ

Company

About Us Contact Us Terms of Service Privacy Policy Disclaimer Cookie Policy IP Issues
Answers Logo
Copyright ©2025 Answers.com | Lunias Media Inc. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.