| HOT BKP problem [message #161589] |
Mon, 06 March 2006 03:29  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi all,
I've got one script for taking a hot bkp.One of our team members have provided me this link. I've executed the script .
but i am getting errors.The problem is that i am not able to execute the Windows OS cmd i.e copy cmd thru this script.
But this script is perfectly working on Linux. i.e
we say !cp ....
But in Windows if am saying ,
!copy
I am getting errors. Can any one help me out
This is actual script
---------------------
spool c:\bkp
set serveroutput on
set trimspool on
set line 500
set head off
set feed off
declare
copy_cmnd varchar2(30):= 'copy';
copy_dest varchar2(30):= 'D:\CHOICEBKPS';
dbname varchar2(30);
logmode varchar2(30);
begin
select name,log_mode into dbname,logmode from sys.v_$database;
if logmode <> 'ARCHIVELOG' then
raise_application_error(-20000,'ERROR: Database must compulsorily be in ARCHIVELOG mode For Taking Hot Bkps!!!');
return;
end if;
dbms_output.put_line('spool c:\backup.'||dbname||'.'||to_char(sysdate, 'ddMonyy')||'.log');
-- Loop through tablespaces
for c1 in (select tablespace_name ts from sys.dba_tablespaces)
loop
dbms_output.put_line('alter tablespace '||c1.ts||' begin backup;');
-- Loop through tablespaces' data files
for c2 in (select file_name fil from sys.dba_data_files where tablespace_name = c1.ts)
loop
dbms_output.put_line('!'||copy_cmnd||' '||c2.fil||' '||copy_dest);
end loop;
dbms_output.put_line('alter tablespace '||c1.ts||' end backup;');
end loop;
-- Backup controlfile and switch logfiles
dbms_output.put_line('alter database backup controlfile to trace;');
dbms_output.put_line('alter database backup controlfile to '||''''||copy_dest||'\control.'||dbname||'.'||to_char(sysdate,'DDMonYYHH24MI')||''''||';');
dbms_output.put_line('alter system switch logfile;');
dbms_output.put_line('spool off');
end;
/
spool off
set head on
set feed on
set serveroutput off
output of the above script
---------------------------
spool c:\backup.ORACLE.06Mar06.log
alter tablespace SYSTEM begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\SYSTEM01.DBF D:\CHOICEBKPS
alter tablespace SYSTEM end backup;
alter tablespace UNDOTBS1 begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\UNDOTBS01.DBF D:\CHOICEBKPS
alter tablespace UNDOTBS1 end backup;
alter tablespace TEMP begin backup;
alter tablespace TEMP end backup;
alter tablespace CWMLITE begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\CWMLITE01.DBF D:\CHOICEBKPS
alter tablespace CWMLITE end backup;
alter tablespace DRSYS begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\DRSYS01.DBF D:\CHOICEBKPS
alter tablespace DRSYS end backup;
alter tablespace EXAMPLE begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\EXAMPLE01.DBF D:\CHOICEBKPS
alter tablespace EXAMPLE end backup;
alter tablespace INDX begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\INDX01.DBF D:\CHOICEBKPS
alter tablespace INDX end backup;
alter tablespace ODM begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\ODM01.DBF D:\CHOICEBKPS
alter tablespace ODM end backup;
alter tablespace TOOLS begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\TOOLS01.DBF D:\CHOICEBKPS
alter tablespace TOOLS end backup;
alter tablespace USERS begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS01.DBF D:\CHOICEBKPS
alter tablespace USERS end backup;
alter tablespace XDB begin backup;
!copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\XDB01.DBF D:\CHOICEBKPS
alter tablespace XDB end backup;
alter database backup controlfile to trace;
alter database backup controlfile to 'D:\CHOICEBKPS\control.ORACLE.06Mar061444';
alter system switch logfile;
spool off
And Now when i am executing the above script at SQL> prompt it is showing the following errors.
SQL> alter tablespace SYSTEM begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\SYSTEM01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace SYSTEM end backup;
Tablespace altered.
SQL> alter tablespace UNDOTBS1 begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\UNDOTBS01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace UNDOTBS1 end backup;
Tablespace altered.
SQL> alter tablespace TEMP begin backup;
alter tablespace TEMP begin backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
SQL> alter tablespace TEMP end backup;
alter tablespace TEMP end backup
*
ERROR at line 1:
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
SQL> alter tablespace CWMLITE begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\CWMLITE01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace CWMLITE end backup;
Tablespace altered.
SQL> alter tablespace DRSYS begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\DRSYS01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace DRSYS end backup;
Tablespace altered.
SQL> alter tablespace EXAMPLE begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\EXAMPLE01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace EXAMPLE end backup;
Tablespace altered.
SQL> alter tablespace INDX begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\INDX01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace INDX end backup;
Tablespace altered.
SQL> alter tablespace ODM begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\ODM01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace ODM end backup;
Tablespace altered.
SQL> alter tablespace TOOLS begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\TOOLS01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace TOOLS end backup;
Tablespace altered.
SQL> alter tablespace USERS begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace USERS end backup;
Tablespace altered.
SQL> alter tablespace XDB begin backup;
Tablespace altered.
SQL> !copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\XDB01.DBF D:\CHOICEBKPS
SP2-0734: unknown command beginning "!copy C:\S..." - rest of line ignored.
SQL> alter tablespace XDB end backup;
Tablespace altered.
SQL> alter database backup controlfile to trace;
Database altered.
SQL> alter database backup controlfile to 'D:\CHOICEBKPS\control.ORACLE.06Mar061444';
alter database backup controlfile to 'D:\CHOICEBKPS\control.ORACLE.06Mar061444'
*
ERROR at line 1:
ORA-01580: error creating control backup file D:\CHOICEBKPS\control.ORACLE.06Mar061444
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists
SQL> alter system switch logfile;
System altered.
|
|
|
|
| Re: HOT BKP problem [message #161596 is a reply to message #161589] |
Mon, 06 March 2006 04:11  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
Using "host copy" instead. Further more, oracle recommends using "ocopy" instead of "copy" in windows system.
Alex zeng | Skype me: hans9zeng
|
|
|
|
| Re: HOT BKP problem [message #161615 is a reply to message #161596] |
Mon, 06 March 2006 05:47 |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Thank q Very much alex.Host copy worked out.
Here is the script
spool c:\backup.ORACLE.06Mar06.log
alter tablespace SYSTEM begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\SYSTEM01.DBF D:\CHOICEBKPS
alter tablespace SYSTEM end backup;
alter tablespace UNDOTBS1 begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\UNDOTBS01.DBF D:\CHOICEBKPS
alter tablespace UNDOTBS1 end backup;
alter tablespace CWMLITE begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\CWMLITE01.DBF D:\CHOICEBKPS
alter tablespace CWMLITE end backup;
alter tablespace DRSYS begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\DRSYS01.DBF D:\CHOICEBKPS
alter tablespace DRSYS end backup;
alter tablespace EXAMPLE begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\EXAMPLE01.DBF D:\CHOICEBKPS
alter tablespace EXAMPLE end backup;
alter tablespace INDX begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\INDX01.DBF D:\CHOICEBKPS
alter tablespace INDX end backup;
alter tablespace ODM begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\ODM01.DBF D:\CHOICEBKPS
alter tablespace ODM end backup;
alter tablespace TOOLS begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\TOOLS01.DBF D:\CHOICEBKPS
alter tablespace TOOLS end backup;
alter tablespace USERS begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS01.DBF D:\CHOICEBKPS
alter tablespace USERS end backup;
alter tablespace XDB begin backup;
host copy C:\SOFTWARE\ORACLE\ORADATA\ORACLE\XDB01.DBF D:\CHOICEBKPS
alter tablespace XDB end backup;
alter database backup controlfile to trace;
alter database backup controlfile to 'D:\CHOICEBKPS\control.ORACLE.06Mar061709';
alter system switch logfile;
spool off
thanks a lot Alex.Thank Q very much.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
