Linux Oracle Cool Back SCRITP

Oracle Cold backup is a consistent backup, the contents of the backup are data files, redo files, temp files, control files, etc.

Sqlblanklines on is the prevention script has a space, sqlplus mistakenly think is the end, reported

Sp2-0734:unknown command Beginning "where t.bg ..."-rest of line ignored.

Error.

Set feedback off heading off verify off Trimspool off Sqlblanklines on

Set pagesize 0 linesize 200

Define dir= '/u01/backup '

Define script= '/tmp/coolbak.sql '

Spool &script

Select '! CP ' | | name | | ' &dir ' from V$datafile order by 1;

Select '! CP ' | | Member | | ' &dir ' from V$logfile order by 1;

Select '! CP ' | | name | | ' &dir ' from V$controlfile order by 1;

Select '! CP ' | | name | | ' &dir ' from V$tempfile order by 1;

Create pfile = ' &dir/initdbid.ora ' from SPFile;

Ho cp/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdbid ' &dir '

Spool off

Shutdown immediate

@&script

Startup

This article from "Permanent" blog, declined reprint!