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

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)



/local/$APP_NAME/oradata02/$ORACLE_SID/system_01.dbf

/local/$APP_NAME/oradata02/$ORACLE_SID/sysaux_01.dbf

/local/$APP_NAME/oradata06/$ORACLE_SID/undo_01.dbf

/local/$APP_NAME/oradata03/$ORACLE_SID/temp_01.dbf

/local/$APP_NAME/oradata07/$ORACLE_SID/tools_01.dbf

/local/$APP_NAME/oradata07/$ORACLE_SID/users_01.dbf



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
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/456406/136107/#msg_456406

http://www.orafaq.com/forum/m/456968/136107/#msg_456968

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: Tue Mar 19 00:25:11 CDT 2024