Create a Batch File from Trace in Oracle
How to make a batch file by using the trace file
For a large database, you may have dozens of datafiles. It is rather cumbersome to copy them one by one when you perform backup or restore,
but you can establish a procedure to customize these processes. One thing you can do to make your life easier is to create a batch file to include the copy commands.
Each time you need to make a backup or restore a NOARCHIVELOG database, you can run this batch file.
In order to include all the database files in the batch file, you create a trace file by issuing the
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
statement. Locate this trace file in the ORACLE_HOME\RDBMS80\TRACE folder, open it with an operating system editor and find the part you are interested in.
GROUP 1 'C:\ORANT\DATABASE\LOG4ORCL.ORA' SIZE 1M,
GROUP 2 'C:\ORANT\DATABASE\LOG3ORCL.ORA' SIZE 1M,
GROUP 3 'C:\ORANT\DATABASE\LOG2ORCL.ORA' SIZE 1M,
GROUP 4 'C:\ORANT\DATABASE\LOG1ORCL.ORA' SIZE 1M
Then you edit it and save it as a batch file (such as DO_BACKUP.BAT) in your file system. .
View the code below to see an example.
COPY C:\ORANT\DATABASE\LOG4ORCL.ORA D:\ORCL_BCKUP\LOG4ORCL.ORA
COPY C:\ORANT\DATABASE\LOG3ORCL.ORA D:\ORCL_BCKUP\LOG3ORCL.ORA
COPY C:\ORANT\DATABASE\LOG2ORCL.ORA D:\ORCL_BCKUP\LOG2ORCL.ORA
COPY C:\ORANT\DATABASE\LOG1ORCL.ORA D:\ORCL_BCKUP\LOG1ORCL.ORA
COPY C:\ORANT\DATABASE\SYS1ORCL.ORA D:\ORCL_BCKUP\SYS1ORCL.ORA
COPY C:\ORANT\DATABASE\USR1ORCL.ORA D:\ORCL_BCKUP\USR1ORCL.ORA
COPY C:\ORANT\DATABASE\RBS1ORCL.ORA D:\ORCL_BCKUP\RBS1ORCL.ORA
COPY C:\ORANT\DATABASE\TMP1ORCL.ORA D:\ORCL_BCKUP\TMP1ORCL.ORA
COPY C:\ORANT\DATABASE\OEM1ORCL.ORA D:\ORCL_BCKUP\OEM1ORCL.ORA
COPY C:\ORANT\DATABASE\INITORCL.ORA D:\ORCL_BCKUP\INITORCL.ORA
COPY C:\ORANT\DATABASE\CTL1ORCL.ORA D:\ORCL_BCKUP\CTL1ORCL.ORA
Do not forget to add 1) the control files, 2) parameter files, and 3) the password file in your batch file, otherwise you will not get a complete backup.
These three files are not included in the trace file. You can create a similar batch file to perform restore.
If you change the structure of these files, for instance, if you move one file to a different location,
remember to edit the batch file to reflect the change.