![]() ![]() Sfdisk -d /dev/cciss/c0d0 | ssh remoteserver 'cat > /path/to/c0d0_sfdisk-d' Shutdown Windows, use RIP CD or system rescue cd to backup the whole C drive(c:\program files\oracle) and d:\oracle (where data exists) by ntfsclone program. ![]() SQL> SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP' ![]() SQL> ALTER TABLESPACE temp ADD TEMPFILE 'D:\ORACLE\ORADATA\orcl\TEMP01.DBF' SIZE 50mĪUTOEXTEND ON NEXT 20m MAXSIZE 17000M SQL> ALTER DATABASE TEMPFILE 'D:\ORACLE\ORADATA\orcl\TEMP01.DBF' DROP INCLUDING DATAFILES SQL> SELECT tablespace_name, file_name, bytesįROM dba_temp_files WHERE tablespace_name = 'TEMP' Shutdown listener and make sure nobody is using database (bounce db if required) If you have enough space to backup, no matter how big the temporary tablespace is, just copy them.Īfter doing copy and before running dbua, check temporary tablespace datafile size, shrink it if it's huge as follows: Objective: upgrade it to Oracle standard edition 11.2.0.2.īACKUP DATABASE FORMAT 'some_backup_directory%U' TAG before_upgrade īACKUP CURRENT CONTROLFILE FORMAT 'controlfile location and name' īACKUP CURRENT CONTROLFILE TO 'save_controlfile_location' īACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG DELETE ALL INPUT Įxp backup_admin/password file=d:\oracle\oradata\orcl\backup\full_orcl.dmp log=d:\oracle\oradata\orcl\backup\exp_full_orcl.log consistent=y full=yīackup c:\program files\oracle directory and d:\oracle data directory. The kernel supports the important file systems (ext2/ext3/ext4, ReiserFS, Reiser4, Btrfs, XFS, JFS, VFAT, NTFS, iso9660), as well as network file systems (Samba and NFS).Environment: Windows 2003 server SP2 32bit, Oracle 10.2.0.4(was upgraded from Oracle 9.2) It can be used on Linux servers, Linux desktops, or Windows boxes. It comes with many Linux software such as system tools (parted, partimage, fstools, etc.) and basic tools (editors, Midnight Commander, network tools, etc.). It provides you with an easy way to carry out admin tasks on your computer, such as creating and editing the hard disk partitions. SystemRescueCd is a Linux system rescue disk available as a bootable CD-ROM or USB stick to administrate or repair your system and data after a crash. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |