| sql script help [message #457036] |
Thu, 20 May 2010 18:57  |
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' )
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
