Home » RDBMS Server » Backup & Recovery » backups of read-only tablespaces ?
backups of read-only tablespaces ? [message #401912] Wed, 06 May 2009 23:29 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
I read in the doc 'Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2)'
that for a read-only tablespace, we need to only backup this tablespace.


But when I was reading some OUI student guide, I found that all tablespace datafiles, including the read-only ones should be backed up.


So I am confused, which is the correct method for read-only tablespace backups ?


Report message to a moderator

Re: backups of read-only tablespaces ? [message #401918 is a reply to message #401912] Thu, 07 May 2009 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
When the tablespace is read-only you only need to backup it ONCE because as it is read-only it does not change.

ALWAYS quote (copy and paste) what you read and if it exists post a link to it otherwise give a PRECISE location not just the title of hundreds pages book. Your first quote is wrong.

Regards
Michel

Report message to a moderator

Re: backups of read-only tablespaces ? [message #401920 is a reply to message #401912] Thu, 07 May 2009 00:33 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
When you are quoting docs,
please post the exact URL or exact content of documentation
instead of explaining the documentation in your words.

Report message to a moderator

Previous Topic: RMAN Channel
Next Topic: Hot backup of control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 08:25:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.