El maximato
RMAN for the
Busy DBA
Practical
RMAN Recipes for Oracle Database 11g
An example-based approach to backing up and recovering your Oracle database.
A Problem-Solution Approach
Darl Kuhn, Sam Alapati, and Arup Nanda
RMAN Recipes for Oracle Database 11g
A Problem-Solution Approach
Darl Kuhn, Sam Alapati, and Arup Nanda
RMAN Recipes for Oracle Database 11g: A Problem-Solution Approach Copyright © 2007 by Darl Kuhn, Sam Alapati, Arup Nanda
All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written …ver más…
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Jump-Starting RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Using the Flash Recovery Area . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Using RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Configuring the RMAN Environment . . . . . . . . . . . . . . . . . . . . . 113 Using the Recovery Catalog . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Making Backups with RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 177 Maintaining RMAN Backups and the Repository . . . . . . . . . 225 Scripting RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257 Restoring the Control File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 295 Performing Complete Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . 313 Performing Incomplete Recovery . . . . . . . . . . . . . . . . . . . . . . . . 359 Performing Flashback Recovery . . . . . . . . . . . . . . . . . . . . . . . . . 385 Handling Online Redo Log Failures . . . . . . . . . . . . . . . . . . . . . . 427 Duplicating Databases and Transporting Data . . . . . . . . . . . 443 Tuning RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 491 Troubleshooting RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .