Oracle: User Manual
Contents
1. TM bee Pro Backup amp Restore ORACLE User Manual August 2011 awanbee Pro Backup amp Restore Oracle User Manual Table of Contents L UE OCI 1G IA M EIE T OU 3 MM MI MM I UMEN ENIM UNDER 3 EEUU M H 5 4 Step by step instructions to create a Oracle Server backup set for Windows Machine 6 5 Step by step instructions to create a Oracle Server backup set for Linux Solaris and Unix PVG IVINS S oopentese ETENIM MU DIIS MIn UN EUNDI S essen eae UIN E ORIDIPDIM URP E DISQUE DIEA LDE 8 6 How to Restore an oracle Database server esses nennen enne nennen nnne sena 10 7 How to restore a single tablespace 17 Bo PCIE ON 23 August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual 1 Introduction This user manual will cover the techniques used by the awanbee Pro client to backup Oracle database The Oracle Database supported so far are e Oracle 8i e Oracle 9i e Oracle 10g e Oracle 11g Please ensure that the awanbee Pro client is running on the machine in which the Oracle Server is installed and running As the backup process involves creating a temporary file on the machine please make sure that there is sufficient free space 2 Requirments Database must be in archived log mode To switch database to archived l2. i Download the backup files from AhsayOBS Please refer to the Quick Start Backup File section for information on how to download backup files from awanbee DPS server ii Set ORACLE_SID to your database s System Identifier SID S export ORACLE_SID GDB1 assuming your database s SID is GDB1 iii Run SQL Plus and connect to database as SYSDBA S sqlplus as sysdba iv Shutdown database SQL gt shutdown immediate v Put the downloaded tablespace datafiles in place Datafile names and paths can be found by using the REPORT SCHEMA command a Set ORACLE SID to your database s System Identifier SID DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual export ORACLE SID GDB41 assuming your database s SID is GDB1 b Run Oracle Recovery Manager rman and connect to the target database rman target c Start and mount database RMAN startup mount d List the names of all datafiles and tablespaces RMAN report schema For example Report of database schema File K bytes Tablespace RB segs Datafile Name 1 419840 SYSTEM oracle OraHome1 oradata GDB1 systemO1 dbf 2 204800 UNDOTBS1 oracle OraHome1 oradata GDB1 undotbsO1 dbf 3 20480 CWMLITE oracle OraHome1 oradata GDB1 cwmliteO1 dbf 4 20480 DRSYS oracle OraHome1 oradata GDB1 drsys01 dbf 5 141440 EXAMPLE oracle OraHome1 oradata GDB1 example01 dbf 6 25600 INDX oracle OraHome1 oradata GDB1 indx01 dbf 7 20480 O
3. Pro Backup amp Restore Oracle User Manual Oracle 9i 10g 11g Example export ORACLE SID GDB1 rman target Recovery Manager Release 10 2 0 1 0 Production on Thu Nov 8 17 46 27 2007 Copyright c 1982 2005 Oracle All rights reserved connected to target database not started RMAN gt startup mount Oracle instance started database mounted Total System Global Area 285212672 bytes Fixed Size 1216992 bytes Variable Size 113247824 bytes Database Butters 167772160 bytes Redo Buffers 2973696 bytes RMAN gt recover database until zequence 4 thread 1 Starting recover at 08 NOV 07 Starting implicit crosscheck backup at O amp NOV 07 using target database control file instead of recovery catalog allocated channel ORA DISK 1l channel ORA DISK 1 sid 157 devtype DISK Finished implicit crosscheck backup at O0BE NOV 07 Starting implicit crosscheck copy at OBE NOV 07 using channel ORA DISK 1 Finished implicit crosscheck copy at OB NOV 07 searching for all files in the recovery area cataloging files cataloging done List of Cataloged Files File Name oracle product 10 2 0 db 1 flash recovery area GDBl archivelog 2007 11 08 ol mf 1 3 3mShly by arc using channel ORA DISK 1l starting media recovery archive log thread 1 sequence 2 is already on disk as file oracle product 10 2 0 db 1 flash recovery area GDBl archivelog 2007 11 08 ol mf 1 2 3mShls vs arc archive log thread 1 sequence 3 is already on dis
4. ariable Size 96470608 bytes Database Suffers 184549376 bytes Redo Buffers 2973696 bytes Detebase mounted SQL gt alter database open VIII JAVASYSPRIV role is granted to system account You can grant this role to system account by executing Grant permission to system account For Oracle 9i 10g 11g SQL grant javasyspriv to system For Oracle 8i SVRMGRL gt connect internal SVRMGRL gt Q javavm install initjvm sql SVRMGRL rdbms admin catalog saql SVRMGRL rdbms admin catproc saq SVRMGRL gt Q javavm install initdbj sql SQL grant javasyspriv to system DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual Oracle 9i 10g 11g Example SQL grant javasyspriv to system 4 Cd 3 Overview awanbee Pro Client will backup your Oracle database by taking the following steps i Connect to the Oracle database using SQL NET over TCP IP ii Run all Pre Commands of this backup set iii If the backup type to run is Database Backup type all data files in each of the tablespace s selected are copied to the temporary directory specified by this backup set if there are temporary files in the database the script to re create the temporary files are generated to a file located in the temporary directory specified by this backup set all non default initialization parameters will be spooled to an initializing file located in the temporary directory
5. AREA GDB1 ARCHIVELOG 2007 07 19XMO1 MF 1 1 39Y988F0H ARC archive log l sequence 2 is already on disk as file D ORACLE PRODUCT 10 2 0 FLASH RECOVERY AREA GDB1 ARCHIVELOG 2007 07 19XO1 MF 1 2 39Y98JSD ARC archive log thread l sequence 3 is already on disk as file D ORACLE PRODUCT 10 2 0 FLASH RECOVERY AREA GDB1 ARCHIVELOG 2007 07 19 01 MF 1 3 39 S9SW4D ARC archive log ilename D ORACLE PRODUCT 10 2 0 FLASH RECOVERY _ AREA GDB1 ARCHIVELO G 2007_07_19 0l MF 1 1 39Y98F0H ARC thread 1 sequence 1 media recovery complete elapsed time 00 00 01 Finished recover at 19 JUL 07 If your datafiles does not consistent with the database you should see August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual Oracle 9i 10g Example RMAN gt recover tablespace TS1 Starting recover at l15 JUL 07 allocated channel ORA DISK 1 channel ORA DISK 1 sid 156 devtype DISK RMAN 00571 RMAN OOS6S RMAN OOS71 RMAN 03002 failure of recover command at 07 20 2007 12 24 49 RMAN 06163 some datafiles cannot be recovered aborting the RECOVER command RMAN O6166 datafile 7 cannot be recovered RMAN O6166 datafile 6 cannot be recovered RMAN 06166 datafile 5 cannot be recovered In this case you need to find the consistent datafiles in order to restore the tablespace If there are archive log missing you should see Oracle 9i 10g Example Starting recover at 20 JUL 07 using c
6. Rename your Database files by doing the following i Modify the PFILE to update file path Open the PFILE SORACLE_HOME dbs initGDB1 ora change every file path to the new location and then save it DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual For example background dump dest oracle OraHome1 admin GDB2 bdump control files oracle OraHome1 oradata GDB2 control01 ctl oracle OraHome1 oradata GDB2 control02 ctl oracle OraHome1 oradata GDB2 control03 ctl core dump dest oracle OraHome1 admin GDB2 cdump user dump dest oracle OraHome1 admin GDB2 udump Change to background dump dest hew db location OraHome1 admin GDB2 bdump control files new db location OraHome1 oradata GDB2 control01 ctl new db location OraHome1 oradata GDB2 control02 ctl new db location OraHome1 oradata GDB2 control03 ctl core dump dest hew db location OraHome1 admin GDB2 cdump user dump dest new db location OraHome1 admin GDB2 udump ii You may need to quote the values of dispatchers as a single argument Add double quotation marks dispatchers PROTOCOL TCP SERVICE GDB1XDB iii Delete the SPFILE Delete the SPFILE SORACLE HOME dbs spfileGDB1 ora iv Set ORACLE_SID to your database s System Identifier SID S export ORACLE_SID GDB1 assuming your database s SID is GDB1 V Run SQL Plus and connect to database as SYSDBA S sqlplus as sysdba VI Start and mount dat
7. 5671 generated at 06 14 03 02 51 49 needed for thread 1 ORA 00289 suggestion data oraBl15 vin archive ARCH ORA 00280 change 419671 for thread 1 is in sequence 225 ORA 0027B8 log file recovery Specify log lt RET gt suggested filename AUTO CANCEL AUTO Log applied August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual change 547222 generated at 06 18 03 19 58 26 needed for thread 1l suggestion lchange 547222 for thread 1 is in sequence 2384 log file m Cu Gc Gs O GJ EEE sj cn n LER t RU 6 M r3 NN NN Ww Of sj om 00 gt cannot open archived log ORA 27037 unable to obtain file status Linux Error 2 No such file or directory Additional information 3 SVRMGR gt recover database using backup controlfile until cancel ORA 00278 change 547222 generated at 06 18 03 19 58 26 needed for thread 1 ORA 002B89 suggestion ORA 00280 change 547222 for thread 1 is in sequence 3654 Specify log lt RET gt suggested filename AUTO CANCEL CANCEL Media recovery cancelled SVRMGR gt alter database open rezetlogz Statement processed 7 How to restore a single tablespace Restoring a tablespace required a backup of datafiles consistent with the existing archived logs and control files as redo will be applied during the restore operation Please follow the instructions below to restore a tablespace from AhsayOBS
8. APSYS s objects into OLAPSYS importing SYSTEM s objects into SYSTEM importing OLAPSYS s objects into OLAPSYS importing SYSMAN s objects into SYSMAN importing SCOTT7T s objects into SCOTT ort terminated successfully without warnings 8 Additional information For additional information check out our FAQ and blog at www awanbee com If you have any questions suggestions or feedback please feel free to contact us at support awanbee com August 2011 DATA
9. DM oracle OraHome1 oradata GDB1 odm01 dbf 8 10240 TOOLS oracle OraHome1 oradata GDB1 toolsO1 dbf 9 25600 USERS oracle OraHome1 oradata GDB1 usersO1 dbf 10 39040 XDB oracle OraHome1 oradata GDB1 xdb01 dbf 110 TS1 oracle OraHome1 oradata GDB1 TS1 datafile1 dbf 120 TS1 oracle OraHome1 oradata GDB1 TS1 datafile2 dbf 13 0 TS1 oracle OraHome1 oradata GDB1 TS1 datafile3 dbf August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual e Put all the downloaded backup of datafile s that constitute the tablespace to the listed location For example obm restore Oracle Database Server oracle OraHome1 oradata GDB1 TS1 datafile1 dbf obm restore Oracle Database Server oracle OraHome1 oradata GDB1 TS1 datafile2 dbf obm restore Oracle Database Server oracle OraHome1 oradata GDB1 TS1 datafile3 dbf Move to oracle OraHome1 oradata GDB1 TS1 datafile1 dbf oracle OraHome1 oradata GDB1 TS1 datafile2 dbf oracle OraHome1 oradata GDB1 TS1 datafile3 dbf vi Restore tablespace RMAN recover tablespace TS1 assuming your tablespace is TS1 If your datafiles consistent with the database you should see Oracle 9i 10g Example RMAN gt recover tablespace TS1 Starting recover at 19 JUL 07 allocated channel ORA DISK 1 channel ORA DISK 1 sid 15 devtype DISK starting media recovery archive log thread l sequence 1 is already on disk as file D ORACLE PRODUCT 10 2 0 FLASH RECOVERY
10. File K bytes Tablespace RB segs Datafile Nane i 419840 SYSTEM eee oracle OraBomel oradata GDRl systemol dbf z 204800 UNDOTBS1 o oracle OraHomel oradata GDB81 undotbs01 dbf 3 20480 CWMLITE ese oracle OraBomel oradata GDB1 cwmlite01 dbf 4 20480 DRSYS eee f oracie OraHomel oradata GDBl drsys01 d5f 5 141440 EXAMPLE eee oracle OraHomel oradata GD8l1 example0l dbt 6 25600 INDX eve oracle OraHomel oradata GDBl indxOl dbf 7 20480 ODM eee oracle OraHomel oradata GD81 odmol dnf 8 10240 TOOLS vee oracie OraHomel oradata GDBl tools01 d05f 3 25600 USERS eee foracie OraHomel oradata GDBl users01 d05f 10 39040 xDe eee oracle OraHomel oradata GDBl xdbOl dbf 11 0 TS1 eee oracle OraHomel oradata GD61 TS1_ datafilel dbt 12 Oo TS1 eee oracle OraHomel oradata GDBl TS1 datafile2 dbt 13 0 TS1 eve foracle OraHomel oradata GDBl TS1 datafile3 dbt List of Temporary Files File Si2e MB Tablespace Maxsize MB Tempfi le Name 1 20 TEMP 32767 D ORACLE PRODUCT 10 2 0 ORADATA GDB1 TEMPO DBF RHAN gt recover tablespace TS1 Starting recover at 30 AUG 07 allocated channel ORA DISK 1 channel ORA DISK 1 s d 11 devtype DISK Starting media recovery media recovery complete Finished recover at 30 AUG 07 RMAN alter database open database opened August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual Export and Import a Database Logical Backup While physical backup of database files permit the
11. OBS Please refer to the Section 6 2 Backup files directly to the backup server for information on how to upload backup files to AhsayOBS Please follow the instructions below to restore a database iii Download the backup files from AhsayOBS Please refer to the Section 7 1 Restore backup files directly from backup server for information on how to download backup files from AhsayOBS DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual iv Import the full database from the downloaded backup of dump file imp system pwd123 FULL y FILE oracle data dmp LOG oracle import log assuming your system password is pwd123 the name of dump file is oracle data dmp and the name of log file is oracle import log Oracle 9i 10g Example S imp sysaten pwdl23 FULLey FILE oracle data dmp LOG oracle import log Connected to Oracle Database 10g Enterprise Edition Release 10 2 0 1 0 Production With the Partitioning OLAP and Data Mining options Export file created by EXPORT V10 02 01 via conventional path import done in WEBMSNIN1252 character set and ALIGUTF16 NCEAR character set importing SYSTEM s objects into SYSTEM importing OLAPSYS s objects into OLAPSYS importing SYSMAN s objects into SYSMAN importing SYSTEM s objects into SYSTEM importing OLAPSYS s objects into OLAPSYS FEET EEE E TAREE P f Pg 7g Pg 9 ff importing OL
12. SOL Server Backup MySQL Backup i Next Cancel amp You will then be asked to enter the name of the system password the Oracle Database Server Host Name TNS Port and SID August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual New Backup Set Wizard Backup Set Name New Backup Set Type Oracle Database Server Backup CONQACLE Login ID system Password e Host Pot 1521 SID Next Cancel amp e Click the Next button f You will then be asked to select the database s or table space that you want to backup ug ig Oracle Database Server ie Fg SYSTEM O Fg UNDOTBS O Fig SYSAUX O Fig TEMP ie Fig USERS 4 Prewous Next Cancel amp g Once the database s has have been selected you will be asked to select the backup source the database itself or the Archived Log You also need to select the backup schedule See Section 4 6 4 of the awanbee Pro manual for details on setting up the backup schedule e DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual New Backs Add new backup schedule Run Name Backup Schedule Backup Database Tablespaces Control amp Init File Archived Logs Archived Log gt Type Daily Sackup everyday Time At Start 23 00 Stop on completion Full Backup OK Cancel amp h Once the schedule has been set click on the OK button and you
13. abase SQL gt startup mount Vil Create a backup of the control file to trace file SQL gt alter database backup controlfile to trace as New DB Location control trc reuse assuming you create a trace file to New DB Location VIII Rename each of data file log file and tempfile Open the trace file that just created and then check for the filename of each datafile log file and tempfile Please do the following to rename each of the files SQL ALTER DATABASE RENAME FILE xxx TO yyy DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual where xxx is the old filename found in the trace file and yyy is the new filename with updated path For example SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 systemO1 dbf TO new db location oradata GDB1 systemO1 dbf SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 undotbsO1 dbf TO new db location oradata GDB1 undotbsO1 dbf SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 sysaux01 dbf TO new db location oradata GDB1 sysauxO1 dbf SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 usersO1 dbf TO new db location oradata GDB1 usersO1 dbf SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 TS1 TO new db location oradata GDB1 TS1 SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 orad
14. are done i The backup of the Oracle database s will run based on the set schedule If required you can manually initiate the backup process by pressing the T button on the awanbee Pro client window 5 Step by step instructions to create a Oracle Server backup set for Linux Solaris and Unix Machine s a Install awanbee onto your Oracle Server b Create a new backup Set from awanbee Data Protection Server DPS C Select Oracle Database Servers as the backup set type then press Update You may also change the backup set s Name at this stage Backup Set Add Help Name New Backup Set Help Type Q tS File 2 Microsoft SQL Server Q Microsoft Exchange Server fe Oracle Database Server C Sat MySQL Database Server Q D Lotus Domino Q ED Lotus Notes Q System State Microsoft Exchange Mail Level Backup O EP shadowProtect System Q Microsoft Windows System Backup Help Backup Source Backup the following files directories 1 Users punithansupramanima Documents Remove c ve Add Exclude the following files directories 1 Add August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual d Input the Database Backup Setting and the Backup Source oe BackupSet 3 B Add Help Name BackupSet3 Help Type Q ey File a Microsoft SQL Server Q 2 Microsoft Exchange Server L fe Oracle Database Server Sat MySQL Database Server O Lotus Do
15. ata GDB1 redoO1 log TO new db location oradata GDB1 redoO1 log SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db_1 oradata GDB1 redo02 log TO new db location oradata GDB1 redoO02 log SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db 1 oradata GDB1 redo03 log TO new db location oradata GDB1 redo03 log SQL ALTER DATABASE RENAME FILE oracle product 10 2 0 db_1 oradata GDB1 temp01 dbf TO new db location oradata GDB1 tempO1 dbf Restore Database DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual Use Recovery Manager to restore your database by doing the following For Oracle 9i 10g 11g a Set ORACLE SID to your database s System Identifier SID export ORACLE _SID GDB1 assuming your database s SID is GDB1 b Run Oracle Recovery Manager rman and connect to the target database rman target c Start and mount database RMAN startup mount d Reapply all transactions from the archived log files to the last sequence RMAN recover database until sequence 4 thread 1 assuming the sequence number of your last archived redo log is 3 Sequence number are named on the filename of archived redo log e g oracle OraHome1 dbs o1 mf 1 2 3mb5hi1svs arc oracle OraHome1 dbs o1 mf 1 3 3m5h1yby arc in this case the sequence number of archived redo log is 4 e Open database RMAN alter database open resetlogs August 2011 DATA awanbee
16. duction Wath the Partitioning OLAP and Data Mining options SQL gt shutdown immediate Database closed Database dismounted ORACLE instance shut down gt For recover a database that currently does not exist Create a password file S orapwd file SORACLE HOME dbs orapwGDB1 password pwd123 assuming your database s SID is GDB1 and password is pwd123 Oracle 9i 10g 11g Example orapwd file orable OraHomei dbs orapwGDB1 pazzword pwdi123 c Restoreall backup files in place d Control files data files and archived logs are stored on awnabee Pro Client along with their full pathvinformation You just need to put all these files back to their original locations when performing adatabase restore Fox example obm restore Oracle Database Server oracle product 10 2 0 db 1 admin GDB1 obm restore Oracle Database Server oracle product 10 2 0 db 1 dbs initGDB1 ora obm restore Oracle Database Server oracle product 10 2 0 db 1 dbs spfileGDB1 ora obm restore Oracle DatabaseServer oracle product 10 2 0 db 1 flash recovery area GDB1 obm restore Oracle Database Server oracle product 10 2 0 db 1 oradata GDB1 Move to oracle product 10 2 0 db 1 admin GDB1 oracle product 10 2 0 db 1 dbs initGDB1 ora oracle product 10 2 0 db 1 dbs spfileGDB1 ora oracle product 10 2 0 db 1 flash recovery area GDB1 oracle product 10 2 0 db 1 oradata GDB1 e Rename database files Only for Restoring Database to an New Location
17. full reconstruction of database logical backup is a useful supplement to physical backup for some purposes For instance logical backup using the export and import utilities are the only method that Oracle supports for moving an existing database from one platform to another Please follow the instructions below to backup a database i Export the full database to a dump file exp system pwd123 FULL y FILE oracle data dmp LOG oracle export log assuming your system password is pwd123 the name of dump file is oracle data dmp and the name of log file is oracle export log Oracle 9i 10g Example S exp sysaten pwdl23 FULLwey FILEs oracle data dmp LOG oracle export log Connected to Oracle Database 10g Enterprise Edition Release 10 2 0 1 0 Production ith the Partitioning OLAP and Data Mining options Export done in WEBMSWIN1252 character set and ALIGUTF16 NCEAR character set About to export the entire database xporting tablespace definitions exporting profiles exporting user definitions exporting roles exporting resource costs gJ E EEPg PgJHDIFEPTEP Bg PG EE ERLE Ti uporting FK lg LgTPEPFPg PFPBg PPgC Pg y JJ 9g P 9 y exporting dimensions exporting post schema procedural objects and actions xporting history table exporting default and system auditing options exporting statistics xpo rt terminated successfully without warni ngs ii Backup the exported dump file to Ahsay
18. hannel ORA DISK 1 starting media recovery archive log thread 1 sequence 12 is already on disk as file D ORACLE PRODUCT 1O 2 0 FPLASH RECOVERY AREA GDB1 ARCHIVELOG 2007 07 18XO1 MF 1 12 39VF4JNJ ARC RMAN 00571 SSS SS SS SS SS SS SS SSS SS SSS RMAN 00569 z c cz ERROR MESSAGE STACK FOLLOWS RMAN 00571 RMAN 03002 failure of recover command at 07 20 2007 12 28 52 RMAN 06053 unable to perform media recovery because of missing log RMAN 06025 no backup of log thread 1 seq 13 lowscn 660617 found to restore In this case you need to find the missing archive log files in order to restore the tablespace f Open database RMAN alter database open August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual Oracle 9i 10g Exame export ORACLE SID GDB1 man target Recovery Manager Release 9 2 0 1 0 Production Copyright c 1995 2002 Oracle Corporation All rights reserved connected to target database not started PMAN gt startup mount Oracle instance started database mounted Total System Global Area 235999352 bytes Fixed Size 450680 bytes Variable Size 201326532 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes FRHAN gt report schema using target database control file instead of recovery catalog Report of database schema using target database controlfile instead of recovery catalog Report of database schema
19. he backup will run on schedule or you may perform a manual backup i To perform manual backup you will need to edit the script filesawanbee pro _HOME bin RunBackupSet sh Change the script from BACKUP TYPE FILE to BACKUP TYPE DATABASE Then save and exit the file Just local ahin bin j Run the script file with the backup set name or ID as the parameter to perform a manual backup e g sh RunBackupSet sh BackupSet Oracle 6 How to Restore an oracle Database server Please follow the instruction below to restore your Oracle Database a First of all you will need to download the backed up file from awanbee Data Protection Server Please note down the location where the file was downloaded to b For Restore an existing database Shutdown the database To Shutdown the database please do the following gt Set ORACLE_SID to your database s System Identifier SID S export ORACLE_SID GDB1 assuming your database s SID is GDB1 gt Run SQL Plus and connect to database as SYSDBA S sqlplus axs sysdba DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual Shutdown Database SQL shutdown immediate Oracle 9i 10g 11g Example export ORACLB SID GDB1 sqlplus az zyzdba SQL Plus Release 10 0 Production on Thu Now 8 17 Copyright c 1982 2005 Oracle All rights reserved Connected to Oracle Database 10g Enterprise Edition Release 10 2 0 1 0 Pro
20. k as file oracle product 10 2 0 db 1 flash recovery area GDBl archivelog 2007 11 08 ol mf 1 3 3mShly by arc archive log filename oracle product 10 2 0 db 1 flash recovery area GDBl archivelog 2007 11 08 ol mf 1 2 amShlsvs arc thread l sequence 2 archive log filename oracle product 10 2 0 db 1 flash recovery area GDBl archivelog 2007 11 08 ol mf 1 _3_ 3mShlyby arc thread l1 sequence 3 media recovery complete elapsed time 00 00 01 Finished recover at 08 NOV 07 RMAN gt alter database open rezetlogz database opened August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual For Oracle 8i a Set ORACLE SID to your database s System Identifier SID export ORACLE SID GDB41 assuming your database s SID is GDB1 b Run Oracle Server Manager svrmgrl svrmgril c Connect to the target database SVRMGRL gt connect internal d Start and mount database SVRMGRL gt start mount e Reapply all transactions from the archived log files RMAN recover database using backup controlfile f Open database RMAN gt ALTER DATABASE OPEN RESETLOGS Oracle 8i Example svrmgrl SVRMGRL connect internal SVRMGR gt startup mount ORACLE instance started Total System Global Area 55874448 bytes Fixed Size 64912 bytes Variable Size 52744192 bytes Database Butters Redo Butters 2105344 bytes Database mounted SVRMGRL gt recover database using backup controlfile ORA 00278 change 41
21. mino O Lotus Notes O n System State s amp Microsoft Exchange Mail Level Backup SP ShadowProtect System E Q fp Microsoft Windows System Backup Help Database Backup Setting Admin User System Admin Password eae Hostname awanbee poc TNS Port 1521 Delete archived logs older than 60 days 1 Do m Help Backup Source Backup the following files directories 1 Oracle Database Server Remove 2 Add Exclude the following files directories E Add Help Backup Schedule Acc No schedules defined e Set the Backup Source as Oracle Database Server to backup all the table space f You can also include or exclude a specific table space in your backup source e g Set the Backup Source as Oracle Database Server SYSTEM to only backup the SYSTEM table space You may also set up the backup schedule in this stage Backup Source Backup the following files directories i Oracle Database Server Remove 2 Oracle Database Server SYSTEM Remove Sf Add Exclude the following files directories 1 Oracle Database Server TEMP Remove 2 600 Add g Logon to the Oracle Server machine and run Sawanbee pro HOME bin Configurator sh to input theencryption key for the new backup set You can also configure the backup set to run schedulebackup on this computer at this stage DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual h T
22. og mode please do the following l Set the parameters below in the PFILE to enable automatic archiving LOG ARCHIVE DEST directory where archive redo logs will be stored LOG ARCHIVE FORMAT log96t 96s 96r arc LOG ARCHIVE START TRUE Il Set ORACLE SID to your database s System Identifier SID export ORACLE _SID GDB1 assuming your database s SID is GDB1 IIl Run SQL Plus and connect to database as SYSDBA For Oracle 9i 10g 11g sqlplus as sysdba For Oracle 8i connect internal IV Shutdown database shutdown immediate V Start and mount database startup mount VI Switch database to archived log mode alter database archivelog DATA August 2011 awanbee Pro Backup amp Restore Oracle User Manual VII Open database alter database open Oracle 10g Example export ORACLE SID GDBl e Al sqlplus as sysdba on 244 1 135 2 n j Dm zen 57 n SQL Pius Release 10 2 0 1 0 Productior n Thu Nc A 15 08 57 2007 Magus oh 1 19 nos P Tia par et ee a aa LAS J iu jes is e Irie ea TO s i l racle Database lO0g Enterprise Edition Release 10 2 0 1 0 Produ ion Ah r T amp D 3 TT er smb 5 With the Partitioning OLAP and Data Mining options estet e SQL T9 A T orp ue amp run gt ae ae oM ee omo oe ser m c em ot te be ee S ee H startup mount Total System Global Area 2685212672 bytes Fixed Size 1218992 bytes
23. specified by this backup set all control files will be copied to the temporary directory specified by this backup set all archived log files will be copied to the temporary directory specified by this backup set iV If the backup type to run is Archived Log Backup type all archived log files will be copied to the temporary directory specified by this backup set v Run all Post Commands of this backup set vi Upload all files copied to the temporary directory to awanbee Data Protection Server Remove temporary files from the temporary directory Note If your Oracle database is running on Windows please install awanbee Pro Client onto the company running the Oracle database if awanbee Pro Client database This would shorten the time required to backup the Oracle database August 2011 DATA awanbee Pro Backup amp Restore Oracle User Manual d Step by step instructions to create a Oracle Server backup set for Windows Machine Start awanbee Pro Q Create a new backup set by clicking on the Backup Setting button and then clicking on the icon on the left panel Enter an appropriate name for this backup set and then select Oracle Server Backup in the Type drop down menu New Backup Set Wizard X P Backup Set Name New Backup Set Type File Backup File Backup Lotus Domino Server Backup Lotus Notes Client Backup MS Exchange Server Backup MS Exchange Mall Level Backup MS
Download Pdf Manuals
Related Search