|
Blue Forest http://www.lslnet.com at 3:18 p.m. on August 26, 2006
 Rman back on the plane to ask questions
I have completed the restoration of catalog data on the mainframe establish restore catalog and registration database (in another machine).
The question now is :
I would now like to database backup (or restore control experiments using rman spfile file and the test database has been opened automatic backup function).
I am going to help? ? These tests are done in single environment!
I think it is :
Datafile increase in the target database, catalog database in restoring open rman restore catalog database on the mainframe will be a corresponding back-record, but I did not see why all show with the corresponding record back-ah? ?
There is not open rman catalog database in order to restore the results are shown in the information database show? ? Rman rather than restoring the catalog database information? ? On how to restore catalog database backup?
|
1, it is necessary to restore even the catalog database
2, register databse |
I have done this a few steps go up in smoke.
My question is : : :
Datafile increase in the target database, catalog database in restoring open rman restore catalog database on the mainframe will be a corresponding back-record, but I did not see why all show with the corresponding record back-ah? ?
There is not open rman catalog database in order to restore the results are shown in the information database show? ? Rman rather than restoring the catalog database information? ? On how to restore catalog database backup?
--------------------------------------------------------------------
I do step is a very well-known online files (RMAN Beginners Guide).
1) Creating the catalog database table space used to restore Contents
SQL> create tablespace rmants datafile 'c:\oracle\oradata\cc\rmants.ora' size 20M;
2, in the list of authorized users and database creation RMAN
SQL> create user rman identified by rman default tablespace rmants temporary tablespace temperature quota unlimited on rmants;
SQL> grant recovery_catalog_owner to rman;
3, created in the directory database restore Contents
C:\>rman catalog rman/rman
RMAN>create catalog tablespace rmants;
Contents : restoring established RMAN-06431
4, the registration database to restore Contents
Attention Oh, my goal here is the name of the database to use the services rman means to perform backup of the database using RMAN, and the directory database is used by service name CC.
C:\>rman target sys/sys@rman
RMAN>connect catalog rman/rman@cc
RMAN-06008 connect to restore catalog database :
RMAN>register database;
RMAN-03022 order : register translation is :
RMAN-03023 being implemented order : register :
RMAN-08006 : restoring registered in the database catalog
RMAN-03023 : full resync is executing orders :
Contents : RMAN-08002 being initiated to restore all the resync
RMAN-08004 complete resync :
--> |
| |
