OraFAQ Forum: Backup & Recovery » RMAN tablespace backup and restore

Home » RDBMS Server » Backup & Recovery » RMAN tablespace backup and restore (Oracle 10g 10.2.0.1.0)

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

RMAN tablespace backup and restore [message #516728]

Wed, 20 July 2011 05:11

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Hi All,

I have taken the backup of a tablespace using the below mentioned command.

run
{
allocate channel c1 device type disk;
backup tablespace tcs_tbs;
}

Now I after even after one month or one year I want to restore the backup on my same database to bring the tablespace to the previous position.

Is it possible to restore even after one year, Is retention period gonna play its role in this?

What would be the script?

Thanks
DS

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516730 is a reply to message #516728]

Wed, 20 July 2011 05:44

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is it possible to restore even after one year

Yes, if you have the archived logs since this time or if the tablespace was put in read-only mode before.

Quote:

Is retention period gonna play its role in this?

Yes, but
- if you didn't make another backup then the policy does not come into action
- if you did then you can always recatalog the backup to use it

Regards
Michel

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516733 is a reply to message #516730]

Wed, 20 July 2011 06:10

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Thanks for the reply Sir, let me explain you possibilities at my side, I just want to take the backup only once for a tablespace.

I want to restore the tablespace back to the earlier point using the backup, but there is no limit for the time.

I want that if I can restore it just the next day, next week, next month or may be after year.

What are all the requirement that I have to fulfill?

Thanks
Deepak

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516738 is a reply to message #516733]

Wed, 20 July 2011 07:07

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use Transportable Tablespace technic.

Regards
Michel

[Updated on: Wed, 20 July 2011 07:07]

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516743 is a reply to message #516738]

Wed, 20 July 2011 07:43

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

What if my database is in NO ARCHIVE MODE Sir?

Thanks
Deepak

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516744 is a reply to message #516743]

Wed, 20 July 2011 08:08

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Not possible.
No database should be in NOARCHIVELOG mode, no one except those you want to throw.

Regards
Michel

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516770 is a reply to message #516744]

Wed, 20 July 2011 14:17

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

No this is true Sir, I have database in No Archive Mode in my company, since the transaction are very high and there many developers who access that database for testing purpose so the archives will be generated in large quantity.

Now what I have the situation that I have created seperate tablespace for each client's data.So I want to take the backup of each tablespace once an keep it with me.

Later on I can do my testing work or anything on the database but I want that If I want to go back to previous stage when the backup was taken, I should be able to whether it is after a week, a month or after six months.

Whick approach should I follow Sir?

Thanks
Deepak

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516772 is a reply to message #516770]

Wed, 20 July 2011 14:41

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

since the transaction are very high and there many developers who access that database for testing purpose so the archives will be generated in large quantity.

1/ If it is a production database NO developer should access it
2/ If it is a development database then data is of no importance and so I don't see the reason to backup a tablespace and keep it 6 months.
3/ If it is a production database then it MUST be in ARCHIVELOG mode otherwise it means you don't care of your transactions.

Anyway, a NOARCHIVELOG mode database supports ONLY 1 backup type: full cold one and the only thing you can restore is a full database at time of backup.

Regards
Michel

[Updated on: Wed, 20 July 2011 14:43]

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516775 is a reply to message #516772]

Wed, 20 July 2011 14:51

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Yes Sir it is the development database.. we need to use it for testing purpose.. just for ourself.

I just want to take tke backup of individual tablespaces so that as per my requirement I can restore the respective tablespace.

How can I do this using RMAN?

Regards
Deepak

Report message to a moderator

Re: RMAN tablespace backup and restore [message #516797 is a reply to message #516775]

Wed, 20 July 2011 23:23

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Anyway, a NOARCHIVELOG mode database supports ONLY 1 backup type: full cold one and the only thing you can restore is a full database at time of backup.

So, you can't.

Regards
Michel

[Updated on: Wed, 20 July 2011 23:24]

Report message to a moderator

Previous Topic:	Recovery without backup
Next Topic:	How can i recover my db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:47:29 CDT 2024