[oracle@racha1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:50:33 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 184550376 bytes
Database Buffers 444596224 bytes
Redo Buffers 5615616 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '+DATA/testdb/datafile/system.271.860462435'
///////////////
[oracle@racha1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:50:33 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 184550376 bytes
Database Buffers 444596224 bytes
Redo Buffers 5615616 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '+DATA/testdb/datafile/system.271.860462435'
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@racha1 ~]$
[oracle@racha1 ~]$
[oracle@racha1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:54:02 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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL>
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 1541869 02-DEC-14
2 ACTIVE 1541869 02-DEC-14
3 ACTIVE 1541869 02-DEC-14
4 ACTIVE 1541869 02-DEC-14
5 ACTIVE 1541869 02-DEC-14
6 ACTIVE 1541869 02-DEC-14
7 ACTIVE 1541869 02-DEC-14
8 ACTIVE 1541869 02-DEC-14
9 ACTIVE 1541869 02-DEC-14
9 rows selected.
SQL>
SQL>
SQL> alter database end backup;
Database altered.
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1541869 02-DEC-14
2 NOT ACTIVE 1541869 02-DEC-14
3 NOT ACTIVE 1541869 02-DEC-14
4 NOT ACTIVE 1541869 02-DEC-14
5 NOT ACTIVE 1541869 02-DEC-14
6 NOT ACTIVE 1541869 02-DEC-14
7 NOT ACTIVE 1541869 02-DEC-14
8 NOT ACTIVE 1541869 02-DEC-14
9 NOT ACTIVE 1541869 02-DEC-14
9 rows selected.
SQL>
SQL> alter database open;
Database altered.
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
SQL>
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:50:33 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 184550376 bytes
Database Buffers 444596224 bytes
Redo Buffers 5615616 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '+DATA/testdb/datafile/system.271.860462435'
///////////////
[oracle@racha1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:50:33 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 636100608 bytes
Fixed Size 1338392 bytes
Variable Size 184550376 bytes
Database Buffers 444596224 bytes
Redo Buffers 5615616 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '+DATA/testdb/datafile/system.271.860462435'
SQL>
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
[oracle@racha1 ~]$
[oracle@racha1 ~]$
[oracle@racha1 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 2 16:54:02 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, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL>
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 1541869 02-DEC-14
2 ACTIVE 1541869 02-DEC-14
3 ACTIVE 1541869 02-DEC-14
4 ACTIVE 1541869 02-DEC-14
5 ACTIVE 1541869 02-DEC-14
6 ACTIVE 1541869 02-DEC-14
7 ACTIVE 1541869 02-DEC-14
8 ACTIVE 1541869 02-DEC-14
9 ACTIVE 1541869 02-DEC-14
9 rows selected.
SQL>
SQL>
SQL> alter database end backup;
Database altered.
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 1541869 02-DEC-14
2 NOT ACTIVE 1541869 02-DEC-14
3 NOT ACTIVE 1541869 02-DEC-14
4 NOT ACTIVE 1541869 02-DEC-14
5 NOT ACTIVE 1541869 02-DEC-14
6 NOT ACTIVE 1541869 02-DEC-14
7 NOT ACTIVE 1541869 02-DEC-14
8 NOT ACTIVE 1541869 02-DEC-14
9 NOT ACTIVE 1541869 02-DEC-14
9 rows selected.
SQL>
SQL> alter database open;
Database altered.
SQL>
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
SQL>
Excellent help!!
ReplyDeleteThx 2 U
ReplyDeletethank you so much!!!
ReplyDeleteTKS
ReplyDelete