I ran the following commands and was wondering what the error message at the end means. I am not sure what database it thinks is not open. I ran this hot backup a few times with no errors, now I get this.
Can anyone help me understand what is happening.
Thanks
David
RMAN> run
2> {
3> allocate channel d1 device type disk;
4> backup database format 'd:\backup\pdb1\%d_%t_%s_%p'
5> include current controlfile;
6> sql 'alter system archive log current';
7> backup archivelog all format 'd:\backup\pdb1\%d_ARC_%t_%s_%p'
8> delete input;
9> crosscheck backup;
10> delete obsolete;
11> release channel d1;
12> }
allocated channel: d1
channel d1: sid=10 devtype=DISK
Starting backup at 04-OCT-05
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00004 name=D:\ORANT\DATA\PDB1\LOGICIAN.DB
input datafile fno=00005 name=D:\ORANT\DATA\PDB1\LOGIC_IX.DB
input datafile fno=00012 name=D:\ORANT\DATA\PDB1\LOGICIAN01.DB
input datafile fno=00013 name=D:\ORANT\DATA\PDB1\LOGIC_IX01.DB
input datafile fno=00001 name=D:\ORANT\DATA\PDB1\SYSTEM.DB
input datafile fno=00002 name=D:\ORANT\DATA\PDB1\ROLLBACK.DB
input datafile fno=00008 name=D:\ORANT\DATA\PDB1\LOG_TUT.DB
input datafile fno=00010 name=D:\ORANT\DATA\PDB1\L3.DB
input datafile fno=00014 name=D:\ORANT\DATA\PDB1\ROLLBACK01.DB
input datafile fno=00006 name=D:\ORANT\DATA\PDB1\LOGIC_RO.DB
input datafile fno=00007 name=D:\ORANT\DATA\PDB1\LOG_IXRO.DB
input datafile fno=00011 name=D:\ORANT\DATA\PDB1\PHOTOS.DB
input datafile fno=00009 name=D:\ORANT\DATA\PDB1\MAINT.DB
channel d1: starting piece 1 at 04-OCT-05
channel d1: finished piece 1 at 04-OCT-05
piece handle=D:\BACKUP\PDB1\PDB01_570813246_5_1 comment=NONE
channel d1: backup set complete, elapsed time: 00:03:46
Finished backup at 04-OCT-05
Starting Control File Autobackup at 04-OCT-05
piece handle=D:\ORANT\ORA92\DATABASE\C-3545373654-20051004-01 comment=NONE
Finished Control File Autobackup at 04-OCT-05
sql statement: alter system archive log current
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 10/04/2005 15:17:54
RMAN-11003: failure during parse/execution of SQL statement: alter system archiv
e log current
ORA-01109: database not open
RMAN>
Can anyone help me understand what is happening.
Thanks
David
RMAN> run
2> {
3> allocate channel d1 device type disk;
4> backup database format 'd:\backup\pdb1\%d_%t_%s_%p'
5> include current controlfile;
6> sql 'alter system archive log current';
7> backup archivelog all format 'd:\backup\pdb1\%d_ARC_%t_%s_%p'
8> delete input;
9> crosscheck backup;
10> delete obsolete;
11> release channel d1;
12> }
allocated channel: d1
channel d1: sid=10 devtype=DISK
Starting backup at 04-OCT-05
channel d1: starting full datafile backupset
channel d1: specifying datafile(s) in backupset
including current controlfile in backupset
input datafile fno=00004 name=D:\ORANT\DATA\PDB1\LOGICIAN.DB
input datafile fno=00005 name=D:\ORANT\DATA\PDB1\LOGIC_IX.DB
input datafile fno=00012 name=D:\ORANT\DATA\PDB1\LOGICIAN01.DB
input datafile fno=00013 name=D:\ORANT\DATA\PDB1\LOGIC_IX01.DB
input datafile fno=00001 name=D:\ORANT\DATA\PDB1\SYSTEM.DB
input datafile fno=00002 name=D:\ORANT\DATA\PDB1\ROLLBACK.DB
input datafile fno=00008 name=D:\ORANT\DATA\PDB1\LOG_TUT.DB
input datafile fno=00010 name=D:\ORANT\DATA\PDB1\L3.DB
input datafile fno=00014 name=D:\ORANT\DATA\PDB1\ROLLBACK01.DB
input datafile fno=00006 name=D:\ORANT\DATA\PDB1\LOGIC_RO.DB
input datafile fno=00007 name=D:\ORANT\DATA\PDB1\LOG_IXRO.DB
input datafile fno=00011 name=D:\ORANT\DATA\PDB1\PHOTOS.DB
input datafile fno=00009 name=D:\ORANT\DATA\PDB1\MAINT.DB
channel d1: starting piece 1 at 04-OCT-05
channel d1: finished piece 1 at 04-OCT-05
piece handle=D:\BACKUP\PDB1\PDB01_570813246_5_1 comment=NONE
channel d1: backup set complete, elapsed time: 00:03:46
Finished backup at 04-OCT-05
Starting Control File Autobackup at 04-OCT-05
piece handle=D:\ORANT\ORA92\DATABASE\C-3545373654-20051004-01 comment=NONE
Finished Control File Autobackup at 04-OCT-05
sql statement: alter system archive log current
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 10/04/2005 15:17:54
RMAN-11003: failure during parse/execution of SQL statement: alter system archiv
e log current
ORA-01109: database not open
RMAN>