Search This Blog

Total Pageviews

Friday, 6 August 2010

Create standby controlfile

oracle@anuj> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Aug 6 13:22:27 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

oracle@anuj>ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/controlfile.ctl';

Database altered

No comments:

Oracle DBA

anuj blog Archive