| First backup of my data [message #166725] |
Fri, 07 April 2006 18:40  |
florida
Messages: 82
Registered: April 2006
|
Member |
|
|
I have always used Access 2000 where I can copy/backup each database and put it on my zip everyday.
Now I have my first Schema with objects that include 3 tables that is about 2MB in size on an Oracle 9i database. Please advise how I can copy my tables and store them on my zip?
|
|
|
|
| Re: First backup of my data [message #166729 is a reply to message #166725] |
Fri, 07 April 2006 21:16  |
marks20101
Messages: 74
Registered: May 2005
|
Member |
|
|
Oracle is a client/server database. An Access database is a file(.mdb). In Oracle Tables are stored in a tablespace. Look into cold back ups.
set ORACLE_CID=PROG
sqlplus /nolog
sys as sysdba/pw
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
ALTER DATABASE BACKUP CONTROLFILE to 'H:\cdbkups\prog_4_2_6\bkup_controlfiles\bkuptxt_cf.log';
shutdown immediate;
copy datafiles, controlfiles ,cf_txt,cf_binary, redos and archives,pw(datbase folder) and init.ora(pfile folder)
to appropriate directories
startup pfile='Z:\oracle\admin\prog\pfile\init.ora'
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
