A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message:
Which is the recommended sequence of operations you need to perform for the query successfully?
A.
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B.
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
I choose B. but the answer is C. I don’t know why must open resetlogs?
Pleas explain it?
I would choose ‘B’ as well, but ‘B’ doesn’t have the recover command, that’s why ‘C’ is right.
But in a real world scenario ‘B’ would apply if recover is being executed after restoring the affected datafile.
Database Incarnations
A database incarnation is created whenever you open the database with the RESETLOGS option. After complete recovery, you can resume normal operations without an OPEN RESETLOGS. After a DBPITR or recovery with a backup control file, however, you must open the database with the RESETLOGS option, thereby creating a new incarnation of the database. The database requires a new incarnation to avoid confusion when two different redo streams have the same SCNs, but occurred at different times. If you apply the wrong redo to your database, then you will corrupt it.
…
OPEN RESETLOGS Operations
When you open the database with the RESETLOGS option, the database performs the following actions:
…
Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
Because the database will not apply an archived redo log to a datafile unless the RESETLOGS SCN and time stamps match, the RESETLOGS requirement prevents you from corrupting datafiles with archived logs that are not from direct parent incarnations of the current incarnation. The relationship among incarnations is explained more fully in the following section.
http://docs.oracle.com/cd/E25054_01/backup.1111/e10642/rcmrvcon.htm#autoId12
B is Correct Answer.
Why?
Userdata belongs to a non-critical tablespace. So recovery process is: take datafile offline => restore failure datafile => recover failure datafile => take datafile online.
i agree for B, too.
Why?
I’m no longer positive where you’re getting your info,
but great topic. I must spend a while finding out more or understanding more.
Thanks for fantastic information I used to be looking for this info for my mission.
It’s remarkable to visit this web site and reading the views of
all friends concerning this post, while I am also eager of getting knowledge.
This article will assist the internet people for setting
up new web site or even a weblog from start to end.
http://mattpondpa.tumblr.com/post/142682043010/clase-de-lengua
Hands down, Apple’s app store wins by a mile. It’s a huge selection of all sorts of apps vs a rather sad selection of a handful for Zune. Microsoft has plans, especially in the realm of games, but I’m not sure I’d want to bet on the future if this aspect is important to you. The iPod is a much better choice in that case.
http://mysticaldazefun.tumblr.com/post/142461799145/cuatro-tipos-de-familia-nuclear
Please take a look at the sites we adhere to, like this a single, because it represents our picks from the web.