Restoring your Mac OS is pretty simple even for those who have limited computer troubleshooting knowledge.īefore you attempt any upgrades to your operating system or any software in general, backup all your files. While that may sound a little ominous, there’s no reason to panic. But sometimes issues are so severe you may have to completely restore your Mac operating system. Sometimes problems can be remedied by running a couple of tools. Sometimes freezes and slow performance can be fixed by simply restarting your Mac. Use the SQL*Plus STARTUP command to start the Oracle database.No matter how reliable your Mac, every once in awhile we encounter some problems. Under the DBA user ID, ensure that the ORA SID environment variable identifies the Oracle Database, which is to be restored. SQL> SELECT GROUP#,MEMBER FROM V$LOGFILE You can determine the name of the log files in a similar way: The following is an example of the result that is displayed: Enter the following command when the SQL prompt is displayed: While Oracle database is running, the names of all files which it comprises can be determined by querying the table V$DATAFILE. Files must be restored with their original name. You may use the BS2000 ARCHIVE utility or the BS2000 /COPY-FILE command. Ensure that the OLS parameter of ARCHIVE is set to YES.Īn Oracle Database can be restored offline from backups, using the following steps:Ĭopy all the database files and the log files from the backup. To perform an online backup of individual tablespaces or data files, use the following procedure:īack up the files of the tablespace using the BS2000 utility ARCHIVE utility. If you do not follow this step, then the resulting backup files are inconsistent. You must never back up database files online without first setting the tablespace to backup mode.

For example, before adding it to a tablespace, not on the occasion of each backup.

You enter this command once for each file. For the CATAL macro to work the database must be shut down or the tablespace in question must be offline. The INSTALL.C.OPNBACK utility calls the BS2000 macro CATAL, which sets the OPNBACK file attribute to YES. The following BS2000 command ensures that ARCHIVE can back up all open files: The ARCHIVE method is faster, and is described in this section.īefore you can perform an online (hot) backup of individual tablespaces, you must ensure that the ARCHIVE utility can back up open files. The BS2000 ARCHIVE utility together with Oracle Database INSTALL.C.OPNBACK utility You can perform an online backup of the database or individual tablespaces by using either:

How to backup files on os x utilities