| problem while trying to take a HOT BKP [message #161560] |
Mon, 06 March 2006 01:03  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
hi all,
I've one problem.can anyone please explain .
There is a TABLESPACE called USERS in my database.
I want to take an HOT BKP of this USERS tablespace;
and when i am saying ,
SQL>ALTER TABLESPACE users begin backup;
It is showing an error as foows.:
alter tablespace users begin backup
*
ERROR at line 1:
ORA-01128: cannot start online backup - file 11 is offline
ORA-01110: data file 11: 'C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS02.DBF'
And later what i've done is that :
1* select file#,name,status from v$datafile where name LIKE '%USER%'
SQL> /
FILE# NAME STATUS
---------- --------------------------------------------- -------
9 C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS01.DBF ONLINE
11 C:\SOFTWARE\ORACLE\ORADATA\ORACLE\USERS02.DBF RECOVER
AND ALSO
SQL> select file_id,file_name,status from dba_data_files
2 where tablespace_name='USERS';
FILE_ID FILE_NAME STATUS
---------- ------------------------------------------------- ----
9 C:\SOFTWARE\ORACLE\ORADAT\ORACLE\USERS01.DBF AVAILABLE
11 C:\SOFTARE\ORACLE\ORADATA\ORACLE\USERS02.DBF AVAILABLE
can anyone tell me what is the necessart action to be taken now
so that i can take the tablespace to begin backup mode;
Waiting for quick reply guys ...
Thank Q,
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
