Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql 'alter system archive log current' error

Status
Not open for further replies.

sgwisby

Technical User
Apr 13, 2005
148
US
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>
 
what does the alert log say?

what media manager product are you using?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top