Access over 20 million homework & study documents

Case II : Redo log file missing

Content type
User Generated
Type
Study Guide
Rating
Showing Page:
1/6
Case I : Data le missing
Recovery Step







Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/6
Case II : Redo log le missing
Recovery Step





Case III : Control le missing



Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/6

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 6 pages?
Access Now
Unformatted Attachment Preview
Case I : Data file missing Recovery Step Restore Data file from backup Prepare archive log file Startup mount and recover database >startup mount >recover database >alter database open; Case II : Redo log file missing Recovery Step Startup mount and recover database >startup mount >recover database until cancel >alter database open resetlogs; Full database backup Case III : Control file missing Backup control to trace >alter database backup control file to trace; Output file Dump file d:\demo\ORA01900.TRC Tue Mar 09 15:45:10 2004 ORACLE V8.1.7.0.0 - Production vsnsta=0 vsnsql=e vsnxtr=3 Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production Windows 2000 Version 5.0 Service Pack 4, CPU type 586 Instance name: demo Redo thread mounted by this instance: 1 Oracle process number: 11 Windows thread id: 1900, image: ORACLE.EXE *** SESSION ID:(10.1) 2004-03-09 15:45:10.625 *** 2004-03-09 15:45:10.625 # The following commands will create a new control file and use it # to open the database. # Data used by the recovery manager will be lost. Additional logs may # be required for media recovery of offline data files. Use this # only if the current version of all online logs are available. STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "DEMO" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 32 MAXINSTANCES 16 MAXLOGHISTORY 1630 LO ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Great study resource, helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents