Re: arch full, move files, but wont archive these files

From: Joel Garry <joel-garry_at_home.com>
Date: 5 Aug 2003 18:03:25 -0700
Message-ID: <91884734.0308051703.2807b779@posting.google.com>

quarkman <quarkman_at_myrealbox.com> wrote in message news:<oprtdp7faszkogxn_at_haydn>...
> Do you by any chance mean you run RMAN to do backups?
>
> If so, instead of moving the files back and forth (not good for the old
> network bandwidth, I would have thought), why not jsut get RMAN to 'backup
> archivelog all delete input' in the first place?

I learned RMAN when 8.0 first came out, then promptly forgot it 'cause I never used it. Then I learned it again for OCP a few years later, and promptly forgot it 'cause I never used it. Now I'm learning it again, 'cause I might sometime have to use it. So here is your Laugh For The Day: Illustration Why Newbies Might Think Oracle Is Insane:

DB in noarchivelog mode. Change it to archivelog and bounce, verify logs are archived. Start huge import, discover repetitive Failed to Archive on the same log in alertlog, kill import, change out of archivelog, import successfully, back into archivelog, use RMAN to full backup db. Delete all backups to get space for next step, going to do another full backup, right?

Now, to use RMAN for Standby DB. Grab script from Note:, modify to use without catalog. Script backs up full, alters archive log current, backs up archive logs. Hmmmmmm.... backup archivelog fails, complains about not finding the archive log from the Failed to Archive? *bright idea* I'll just resetlogs and try again. [By this time brain is enveloped in fog from too much RMAN documents]. 8.1.7, no OPS.

SQL> alter database close;

Database altered.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01531: a database already open by the instance

[Now, what would a newbie think about that?]

SQL> host oerr ora 1531
01531, 00000, "a database already open by the instance"

// *Cause:  During ALTER DATABASE, an attempt was made to open
//         a database on an instance for which there is already
//         an open database.
// *Action:  If you wish to open a new database on the instance, first
//          shutdown the instance and then startup the instance and
//          retry the operation.

SQL> shutdown
ORA-01109: database not open

[But it said...]

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 494963732 bytes

Fixed Size                    76820 bytes
Variable Size             247545856 bytes
Database Buffers          245760000 bytes
Redo Buffers                1581056 bytes

Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

[But why would I want to recover incompletely? I just want RMAN to work!]

SQL> recover database until cancel;
Media recovery complete.

[But, but, it said it needs incomplete!] SQL> alter database open resetlogs
2 ;

Database altered.

SQL> [Oh, well, OK then.]

Then the archivelog backup works just fine. But now I have to do the complete backup again... then will the backup archivelog work?

--
@home.com is bogus.  So my 2 year old wants to watch Baby Newton tape
and I want to watch Bill Gates on cable.  Hey, split-screen, we can do
both.  bg going on about the next big thing, while cheap-ass
ray-traced clown dances with hula-hoop.  Syncronicity!  Then bg goes
on about unix/SCO IP issue, while animated stack of blocks falls over.
 We were both rolling around laughing!

Received on Tue Aug 05 2003 - 20:03:25 CDT