Re: backup and restore

Before you do hot backup, get the current redo log file information by issuing

               SVRMGR> archive log list this will give you the archive destination and the starting log sequence. then you set the destination tablespace to hot backup mode

              SVRMGR> alter tablespace xxxx begin backup; backup your tablespace datafile using os command, then reset the tablespace hot backup mode

              SVRMGR> alter tablespace xxxx end backup; get the archive log information again. This is the last redo file sequence you keep as part of your backup.

              SVRMGRL> archive log list Force a logfile switch so that the redo will be stored in another logfile

              SVRMGRL> alter system switch logfile; backup your archived logfiles and controlfile For recovery, just restore the datafiles and redo logfile, then perform a tablespace recovery.

hth

John Chiu. Received on Thu Nov 04 1999 - 17:32:06 CST