OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Selective Backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Selective Backup [message #56077]

Wed, 05 March 2003 05:18

Mukesh Raj Singh
Messages: 9
Registered: March 2003

Junior Member

Sir/Madam
Is it possible to take backup of selective tablespaces?
I have 15 tablespaces in my database.
I want to take backup of just 14 tablespaces i.e. I don't want to take backup of one of the tablespace. How Can I take this backup?
I don't want to do it like taking backup of one by one tablespace.
i want to do it in single shot.
rgds
Mukesh

Report message to a moderator

Re: Selective Backup [message #56081 is a reply to message #56077]

Wed, 05 March 2003 06:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You can backup tablespaces selectively using RMAN.
the following sample code from docs will do that..

run { 
     allocate channel ch1 type disk;
     allocate channel ch2 type disk;
     allocate channel ch3 type disk;
     backup filesperset = 3
       tablespace inventory, sales
       include current controlfile;
}

Report message to a moderator

Previous Topic:	RMAN
Next Topic:	error during register the database using RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 10 03:35:11 CDT 2025