fsck ran on a filesystem hosting an oracle DB ?


 
Thread Tools Search this Thread
Operating Systems AIX fsck ran on a filesystem hosting an oracle DB ?
# 1  
Old 02-19-2010
fsck ran on a filesystem hosting an oracle DB ?

One of our tasks in the office is to do database backups. We were taught (us all operators working here) that it is done via a bunch of specialized scripts. Those scripts are at least 10 years old (system is an AIX 4.1).

One of those script does an fsck against the databases. Everytimes we run it we see a message saying something like running an fsck against a filesystem does not produce reliable results. The databases are in Oracle 7.(something) and are located in a file system on each servers we do it.

All of what the script does is "fsck -n /db_componant_on_a_filesystem".

Is this a good idea to do this ? We are questioning how some of the scripts/tasks are done because we believe (or think) they are either wrong or should be done in a different manner.
# 2  
Old 02-19-2010
Hi.

You don't run an fsck against a database, but on a filesystem.

The error message relates to the filesystem being mounted. It's hard to check something that might be changing.

I'm not sure that it's either a good idea, or a bad one!

This is from the AIX man page for fsck:
Quote:
1. The fsck command does not make corrections to a mounted file system.
2. The fsck command can be run on a mounted file system for reasons other than repairs. However, inaccurate error messages may be returned when the file system is mounted.
In most cases (or very many cases, at least), an Oracle backup will be taken using RMAN (I only ever used Oracle 8 at first - but presume RMAN to have been there before that!). If the database is Oracle 7, then the RMAN scripts will be for that version, and won't need to have been modified.

So what exactly is your problems with the backup scripts?

Last edited by Scott; 02-19-2010 at 07:18 PM..
# 3  
Old 02-19-2010
Please post the exact commands (if known) and the exact error messages with every character typed accurately (or cut/paste if that is available).
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How many times did the scipt ran?

Hi, Can we able to identify how many times any script was ran per day/week/month/year wise (2 Replies)
Discussion started by: penqueen
2 Replies

2. UNIX for Dummies Questions & Answers

MilesWeb.com shared hosting or unlimited hosting plans?

I want to host a website in India, after all my research I have found MilesWeb.com, I am planning to go for their shared plan http://www.milesweb.com/cpanel-hosting.php I have test their contact options and response time, they are really available 24/7. I have checked few other providers, they... (1 Reply)
Discussion started by: Guruguy
1 Replies

3. AIX

Filesystem using Oracle and mirroring VG ?

Hello, I have a filesystem which has Oracle EBS 11.5.9 running and database 9i # df -g Filesystem GB blocks Free %Used Iused %Iused Mounted on /dev/fslv00 270.00 69.68 75% 746263 5% /oratec which is in oraclevg # lsvg oraclevg VOLUME GROUP: ... (5 Replies)
Discussion started by: filosophizer
5 Replies

4. Solaris

unable to repair the / filesystem. Run fsck manually (fsck -F ufs /dev/rdsk/c1t0d0s0)

What can I fix this issue? I have ran below commands but everything is same.:confused: WARNING: Last shutdown is later than time on time-of-day chip: check date. The / file system (/dev/rdsk/c1t0d0s0) is being checked WARNING - unable to repair the / filesystem. Run fsck manually (fsck -F... (4 Replies)
Discussion started by: getrue
4 Replies

5. AIX

Mount Filesystem in AIX Unable to read /etc/filesystem

Dear all, We are facing prolem when we are going to mount AIX filesystem, the system returned the following error 0506-307The AFopen call failed : A file or directory in the path name does not exist. But when we ls filesystems in the /etc/ directory it show -rw-r--r-- 0 root ... (2 Replies)
Discussion started by: m_raheelahmed
2 Replies

6. UNIX for Dummies Questions & Answers

hwo to find shared filesystem and local filesystem in AIX

Hi, I wanted to find out that in my database server which filesystems are shared storage and which filesystems are local. Like when I use df -k, it shows "filesystem" and "mounted on" but I want to know which one is shared and which one is local. Please tell me the commands which I can run... (2 Replies)
Discussion started by: kamranjalal
2 Replies

7. Shell Programming and Scripting

Identify if ran by su or sudo?

Recently I was on an operational call and heard the people running my code placing the code in the /tmp directory and running as root. I had not planned on that. So I want to add some checks to my code (using ksh93): # ---------- ---------- ---------- # root not allowed to run this #... (3 Replies)
Discussion started by: ericdp63
3 Replies

8. HP-UX

Aaarrggghhh HP warranty ran out

We have HP 9000 running UX. Does anybody know a reputable or even a strong maintenance firm that DOESN'T have a help desk the other side of the planet? We've been approached by Newcorp but thay seem rubbish. Please give me some recommendations. Sorry if this is posted in the wrong room but I... (3 Replies)
Discussion started by: Handsy
3 Replies

9. Shell Programming and Scripting

which user ran which command

can we come to know all the command ran bya user for last 1 day (1 Reply)
Discussion started by: narang.mohit
1 Replies
Login or Register to Ask a Question