Create pfile from spfile
Oracle on the AIX OS Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
B-54
Remote Mirroring of an Oracle Database Using Data Replicator Software
./.primary/oracle/
db_backup_controlfile.sql
set pagesize 0
set heading off
set feedback off
set ver off
set linesize 200
ALTER DATABASE BACKUP CONTROLFILE TO '$ORACLE_HOME/admin/
$ORACLE_SID/udump/backup_control.ctl' REUSE;
ALTER DATABASE BACKUP CONTROLFILE TO trace;
exit sql.sqlcode
./.primary/oracle/db_begin_backup.sql
set pagesize 0
set heading off
set feedback off
set ver off
set linesize 200
ALTER DATABASE BEGIN BACKUP;
exit sql.sqlcode
./.primary/oracle/db_check_pfile.sql
set pagesize 0
set heading off
set feedback off
set ver off
set linesize 200
SELECT value
FROM v$parameter
WHERE name='spfile';
exit sql.sqlcode
./.primary/oracle/db_create_pfile.sql
set pagesize 0
set heading off
set feedback off
set ver off
