|
I must write an online backup script for the
database 8.1.7 .
Are my steps below true ?
1) Alter system archive log current ;
2) Alter tablespace ....begin backup;
copy datafiles
Alter tablespace ....end
backup;
FOR ALL TABLESPACES EXCEPT TEMPORARY
ONES.
3) alter database backup controlfile to
trace;
4) alter database backup controlfile to
:\bunyamin\yedek\controlfiles\controlxxx.ctl'
5) alter system archive log
current;
6) alter system switch logfile;
7) copy
e:\orafiles\archivefiles\uybs\archive\*.*
E:\bunyamin\yedek\archivefiles
del e:\orafiles\archivefiles\uybs\archive\*.* /q 8) copy G:\orafiles\redologfiles\UYBS\*.*
E:\bunyamin\yedek\redologfiles
What is the differnce between
"ALTER SYSTEM SWITCH LOGFILE ,
ALTER SYSTEM ARCHIVE LOG CURRENT,
ALTER SYSTEM ARCHIVE LOG ALL"
Thank you ...
Bunyamin
|
