Home » Infrastructure » Unix » sql script help (AIX)
sql script help [message #457036] Thu, 20 May 2010 18:57 Go to next message
Messages: 1
Registered: May 2010
Junior Member

Can some help me building a sql script for the below task.I am totally new to scripts,your help is highly appreciated.

Validate db file placement is correct (ie. each file should be on mount point shown and no other files should be in those dirs with the exception of oradata07)







Redo logs make sure there are at least 3 groups with two members each and "a" files are on oradata04 and "b" files are on oradata05.

GROUP 1 ( '/local/$APP_NAME/oradata04/$DB_NAME/redo01a.log', '/local/$APP_NAME/oradata05/$DB_NAME/redo01b.log' )

GROUP 2 ( '/local/$APP_NAME/oradata04/$DB_NAME/redo02a.log', '/local/$APP_NAME/oradata05/$DB_NAME/redo02b.log' )

GROUP 3 ( '/local/$APP_NAME/oradata04/$DB_NAME/redo03a.log', '/local/$APP_NAME/oradata05/$DB_NAME/redo03b.log' )
Re: sql script help [message #457037 is a reply to message #457036] Thu, 20 May 2010 19:06 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member


writing bash script has NOTHING to do with Oracle RDBMS

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

some/most/all can be done within the DB & no script is required
Previous Topic: errors while running the script
Next Topic: Find out Process doing maximum I/O
Goto Forum:

Current Time: Wed Mar 22 23:38:55 CDT 2023