asked on

Putting a datafile backup online.

Can i put a datafile backup online using OEM? I am experiencing this error: Alert Log: 4 new line(s) found: WARNING: datafile #5 was not in online backup mode ,ORA-1142 signalled during: alter tablespace USERS end backup...,Thread 1 cannot allocate new log, sequence 43923,Checkpoint not complete.

Thx.
V.

johnsone

ORA-1142 is that you are trying to end backup for a tablespace that is not in backup mode.

You cannot put individual files in backup mode, only tablespaces.

Nakuru1234

ASKER

Johnsone,

How do I find out the tablespace that is not in backup mode...and how do I put it back into backup mode? Can I do it via OEM or command line in Unix or sqlplus? Thx!

Cheers,
V.

johnsone

Look at the V$BACKUP view to see what is and is not in backup mode. This query should give you a list of the datafiles and their backup status:

select a.file_name, b.status
from dba_data_files a, v$backup b
where a.file_id = b.file#;

I am not very familiar with OEM, but I am sure you can put them in backup mode there. Otherwise the SQL command is:

alter tablespace <ts> begin backup;

Then to take it out the command is:

alter tablespace <ts> end backup;

<ts> would represent the name of the tablespace.

Nakuru1234

ASKER

Johnsone,

All my backups completed last night per the time...the V$BACKUP view came back with NOT ACTIVE status on all the datafiles which should be fine...is that right? Thx.

Cheers,
V.

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nakuru1234

ASKER

Thx for your help!

Cheers,
V.