SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL1/system01.dbf
/u01/app/oracle/oradata/ORCL1/sysaux01.dbf
/u01/app/oracle/oradata/ORCL1/undotbs01.dbf
/u01/app/oracle/oradata/ORCL1/users01.dbf
SQL> !
[oracle@oralinux ORCL1]$ rm system01.dbf
[oracle@oralinux ORCL1]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 5 19:52:50 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut abort;
ORACLE instance shut down.
SQL> !cp /u01/app/oracle/backups/system01.dbf /u01/app/oracle/oradata/ORCL1/
SQL> startup mount;
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 264244312 bytes
Database Buffers 41943040 bytes
Redo Buffers 6336512 bytes
Database mounted.
SQL> recover datafile '/u01/app/oracle/oradata/ORCL1/system01.dbf';
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/ORCL1/system01.dbf
/u01/app/oracle/oradata/ORCL1/sysaux01.dbf
/u01/app/oracle/oradata/ORCL1/undotbs01.dbf
/u01/app/oracle/oradata/ORCL1/users01.dbf
SQL> !
[oracle@oralinux ORCL1]$ rm system01.dbf
[oracle@oralinux ORCL1]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 5 19:52:50 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut abort;
ORACLE instance shut down.
SQL> !cp /u01/app/oracle/backups/system01.dbf /u01/app/oracle/oradata/ORCL1/
SQL> startup mount;
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 264244312 bytes
Database Buffers 41943040 bytes
Redo Buffers 6336512 bytes
Database mounted.
SQL> recover datafile '/u01/app/oracle/oradata/ORCL1/system01.dbf';
Media recovery complete.
SQL> alter database open;
Database altered.
SQL>
hi
ReplyDeleteI want to start my career with dba , so can u give some date to learn Oracle dba . please
kindly send the data to kompelli13456@gmail.com