Language:EN
Pages: 2
Rating : ⭐⭐⭐⭐⭐
Price: $10.99
Page 1 Preview
user accidentally drops table corrupts data

User accidentally drops table corrupts data

Chapter 11: Facilitating Backup and Recovery

261

Instead of backing up all archive logs every time, you might try backing up only the ones created since the last backup. To do so, type this:

<backup archivelog all not backed up tag=archive_bak;>

✓ It allows you to back up any archive logs that exist in your archive desti-

Run an archive log backup command every time you do any database backup. That way, you have everything you need to recover if there’s a failure. cessfully backs up, you can specify “all” every time, ensuring that none are missed.

Many types of failures can befall your database. Oracle Recovery Manager is a tool that can help you get back on your feet after many of these failures.

262

Part III: Caring for and Feeding an Oracle Database

However, if the user has purged the Recyclebin or the Flashback Database isn’t configured, Recovery Manager is your only choice.

RMAN can do two types of recoveries:

Finding out what went wrong with your database isn’t always an easy task. Sometimes you get lucky (if you want to use the term lucky in the face of a broken database). For example, maybe you know what happened:

✓ A system administrator told you a disk croaked.

You are viewing 1/3rd of the document.Purchase the document to get full access instantly

Immediately available after payment
Both online and downloadable
No strings attached
How It Works
Login account
Login Your Account
Place in cart
Add to Cart
send in the money
Make payment
Document download
Download File
img

Uploaded by : Gokul Dixit

PageId: DOC6886536