| Can I make rman inform/fail if there are offline datafiles? [message #483887] |
Thu, 25 November 2010 05:08  |
 |
arikp
Messages: 3
Registered: November 2010
|
Junior Member |
|
|
Hi all,
Is there any method that rman can warn we about offline datafiles(also when those files are accessible)?
I want to make a full database backup and I want rman to warn me or make the backup failed if there are
some offline datafiles.
Thanks
|
|
|
|
| Re: Can I make rman inform/fail if there are offline datafiles? [message #483888 is a reply to message #483887] |
Thu, 25 November 2010 05:33  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>Is there any method that rman can warn we about offline datafiles(also when those files are accessible)?
Using OFFLINE and ACCESSIBLE/INACCESSIBLE in same like is quite confusing. Because they are quite different in Oracle.
Quoting docs
Quote:A datafile is only considered inaccessible if it cannot be read. Some offline datafiles can still be read because they exist on disk. Others have been deleted or moved and so cannot be read, making them inaccessible.
RMAN will backup offline datafiles (made with Alter database datafile thisFile offline) by default.
Use "skip offline" option to skip offline files.
If the files are inaccessible, rman will error unless "skip inaccessible" is used.
http://download.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmbackp.htm
Just check v$datafile.status for status of datafile.
[Updated on: Thu, 25 November 2010 05:37] Report message to a moderator |
|
|
|
|
|
| Re: Can I make rman inform/fail if there are offline datafiles? [message #483894 is a reply to message #483890] |
Thu, 25 November 2010 06:32 |
|
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
I did understand your question and was under false impression that I addressed it directly.
>>I want that rman backup will always warn/fail if there are offline datafiles.
RMAN will not see this as an issue. Offline datafiles are backed up by default. May be, you can employ some scripting to check the status of datafile and proceed accordingly.
If files are INACCESSIBLE, rman backup will fail.
And what is the oracle version?
Have not checked the options in latest versions yet.
[Updated on: Thu, 25 November 2010 06:34] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
