Q:

Which RMAN command updates the control file and recovery catalog when restoring a datafile after a media failure?

Like
Answer
Comment
Flag
Thanks for your feedback!
A:

1 Answer

rank
1
2
Like
Comment
Flag
SWITCH Take the tablespace for the datafile offline, copy the file to the new location using the SET NEWNAME command, and make the new datafile active by using the SWITCH command. The RECOVER command will apply the redo logs, archived logs, and incremental and cumulative backups to the file. Issue the ALTER TABLESPACE command to bring the tablespace online. • Evaluate this command: ALTER DATABASE CLEAR LOGFILE GROUP 1 UNRECOVERABLE DATAFILE; Why would you issue this command? To clear a redo log file that is needed for recovery of an offline datafile THE ALTER DATABASE CLEAR UNARCHIVED LOGFILE command can be used when there are only two log groups or the corrupt redo log file is a member of the current group. This command will clear or recreate the files.  more

Related Videos

Add your answer...

Top Related Experts

1.
Steve Longo
Media expert · Articles · 0 Likes
2.
Terri Williams
Media expert · Articles · 0 Likes
3.
Art Cavanaugh
Media expert · Articles · 0 Likes

Top Answerers

1.
Cheap SSL Certificates
7 Answers in the past week
2.
vanity fair
7 Answers in the past week
3.
Robert Turner
4 Answers in the past week

Top Askers

1.
Frank Bell
2 Questions in the past week
2.
Frank Bigaglow
3 Questions in the past week
3.
Charles McAtee
2 Questions in the past week

Top Supporters

1.
Tom Wagner
9 Likes given in the past week
2.
Susan Brunner
3 Likes given in the past week
3.
CableAnd OtherThings Too
2 Likes given in the past week
...