Re: Q:Partial backup database using rman
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: AmihayG@xxxxxxxxx
- Date: Mon, 27 Mar 2006 22:39:56 +0200
Backup should include controlfile and required datafiles + redo logs (if
online backup)
Restore:
1. Restore controlfile from backup copy
2. Drop files you don't need "ALTER DATABASE DATAFILE ... OFFLINE DROP"
3. Recover (if online backup)
4. Open (perhaps, resotlogs depending on point in time)
5. Drop objects that were in "non-restored" tablespaces
6. Apply functional scripts to get back objects that were not recovered.
I would recommend to put objects that don't need recovery into separate
tablespaces/schemas to simplify recreation during recovery. The process is
quite simple if you define precise criteria of what should be dropped and
what should be recovered. You can consider export of object definitions
without data so that this dump can be imported during recovery process.
And... test, test, test... ;-)
Hth,
Alex
2006/3/27, Amihay Gonen <AmihayG@xxxxxxxxx>:
>
> Hi ,
>
>
>
> I need to develop a backup procedure for a VLDB (3-4 Tb).
>
> Most of the data is irrelevant for recovery process for the business
> perceptive .
>
>
>
> I know , I can backup only partial list of Tablespaces .
>
> The problem is that the restore process which is complicate the steps need
> to be done (manual) :
>
> 1. Create control file without the Tablespaces which weren't backup
>
> 2. Recover the database
>
> 3. create the new empty Tablespaces. Add the recreate the objects
> (partitions) on the tablespaces.
>
>
>
> This process is not simple and require dba , I wander in 10gr2 which some
> less complicated.
>
>
> IMPORTANT: The contents of this email and any attachments are
> confidential and proprietary to ECtel Ltd. They are intended for the named
> recipient(s) only. If the reader of this message is not the intended
> recipient, you are hereby notified that any dissemination, use, distribution
> or copying of this communication is strictly prohibited and may be unlawful.
>
> If you have received this email in error, please notify us immediately by
> replying to the message and deleting it from your computer.
>
--
Best regards,
Alex Gorbachev
Other related posts:
