Changing Available Status via RMAN

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202915429)



RMAN> copy datafile 2 to 'c:\backup\undotbs01.dbf';

Starting copy at 08-JAN-10
using channel ORA_DISK_1
channel ORA_DISK_1: copied datafile 2
output filename=C:\BACKUP\UNDOTBS01.DBF recid=7 stamp=707781538
Finished copy at 08-JAN-10


RMAN> change datafilecopy 'c:\backup\system01.dbf' unavailable;

using target database controlfile instead of recovery catalog
changed datafile copy unvailable
datafile copy filename=C:\BACKUP\SYSTEM01.DBF recid=2 stamp=707754037
Changed 1 objects to UNAVAILABLE status





RMAN> change datafilecopy 'c:\backup\system01.dbf' available;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
changed datafile copy available
datafile copy filename=C:\BACKUP\SYSTEM01.DBF recid=2 stamp=707754037
Changed 1 objects to AVAILABLE status


Rman>







SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 8 22:50:24 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /as sysdba;
Connected.
SQL>
SQL>

SQL> alter database backup controlfile to 'control0002.bkp';

Database altered.

SQL>




Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202915429)



RMAN>



RMAN> change backup of controlfile unavailable;

changed backup piece unavailable
backup piece handle=H:\ORACLE\ORA92\DATABASE\04L2UT0Q_1_1 recid=4 stamp=70775298
9
changed backup piece unavailable
backup piece handle=H:\ORACLE\ORA92\DATABASE\06L2UT92_1_1 recid=5 stamp=70775325
2
Changed 2 objects to UNAVAILABLE status


RMAN> change backup of controlfile available;

using channel ORA_DISK_1
RMAN-06481: backup piece 'H:\ORACLE\ORA92\DATABASE\04L2UT0Q_1_1' cannot be found
 on the storage medium
RMAN-06486: changed backup piece expired
backup piece handle=H:\ORACLE\ORA92\DATABASE\04L2UT0Q_1_1 recid=4 stamp=70775298
9
changed backup piece available
backup piece handle=H:\ORACLE\ORA92\DATABASE\06L2UT92_1_1 recid=5 stamp=70775325
2
Changed 1 objects to AVAILABLE status


RMAN>